Comments by Tshumore (Top 29 by date)

The issue was with permissions. My IP address needed to be added to Exchange Server as an email originator

Tried using that way . I still get the same exception "The remote certificate is invalid according to the validation procedure."

I have amended the code as in the solutions. The problem is at String[] strlist . strlist returns only 6 substrings - actually only the 6 substrings for the first line. Its not repeating for each returned line. Unless im missing something very obvious i think this is where the flow is failing

The problem is at String[] strlist . strlist returns only 6 substrings - actually 6 substrings for the first line only. Its not repeating for each returned line.

Its an array and contains 24 elements which is in actual case the whole dataset. The problem however is when i read and add them to servers object. Im only getting 1

When i use Linq i am getting error :
Cannot convert from 'bool' to 'system.func<renci.ssh.sftp.sftpfile, bool="">

Perfect ! Works like a charm

Typo, i have amended as necessary now im getting Exception Caught during processing: The entity name must immediately follow the '&' in the entity reference. on line
string outresult = componentExecutor.Execute(authVoucher, "", ComponentName, ComponentMethod, "", inputPayload);

Ok i get it. So what permissions do i need to change, in which folder, to enable this

Thanks guys, but is there something amiss in how im passing the parameters to stream

@MadMyche. I want EmployeeNumber to be an array , its an overtime requisition for multiple employees hence I have used ListBoxFor. in the controller i have var employees = request.EmployeeNumber.Split(','); which then extracts the selected employees.

I have amended the code to have :
request.EmployeeNumber = new string[] { Convert.ToString(formcollection["EmployeeNumber"]) };

but im getting an exception Argument 1: Cannot convert from 'System.Collections.Generic.IEnumerable<string> to string for the employee object on the line
foreach (var employee in employees)
{
request.OverTimeAmount = payrun.CalculateOverTimeAmount(employee, request.RateId); //employee

What am i doing wrong.

Thanks Richard, regrets a typo when writing the question. I have amended the program as per your comments. I am now getting an exception for 'item' in the foreach loop : "foreach statement cannot operate on variables of type 'ContractData' because 'ContractData' does not contain a public instance definition for 'GetEnumerator'

ok thanks

I have removed . The form attempts a PostBack but still reloads back with form values filled in. In the database table its not committing anything still

Thanks @RichardDeeming. This validates the dropdownfor well but i am getting an exception "The ViewData item that has the key 'BankId' is of type 'System.Int32' but must be of type 'IEnumerable<selectlistitem>'." Im getting this on all other DropDowns for the form , i have tried re-assigning the model back as :
[HttpPost]
public ActionResult Bank(Models.Employee.Registration bank)
{
if (!ModelState.IsValid)
{
bank.Banks = PopulateBank();
return View(bank);
}

try
{
using (SqlConnection conn = new SqlConnection(Helpers.DatabaseConnect))
using (SqlCommand cmd = new SqlCommand("SaveEmployeeBankDetail", conn))
{
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@EmployeeNumber", bank.EmployeeNumber);
cmd.Parameters.AddWithValue("@BankId", bank.BankId);

conn.Open();
cmd.ExecuteNonQuery();
}

return RedirectToAction("Index");
}
catch (Exception)
{
var data = from p in bank.SortCodes
select new
{
BankName = p.Text,
BankId = p.Value
};

SelectList list = new SelectList(data, "BankId", "BankName");
ViewBag.SortCodes = list;
ViewBag.ErrorMessage = Helpers.Messages.GENERAL_ERROR;
return View();
}
}

Sorry typo. I meant to say with code above 2nd set SHOULD update to .. For now i can only update the 1st set as illustarted. Thanks in advance to all who can offer additional insight

I am able to get all the DISTINCT duplicates sets using :

var duplicateBrokers = gnbc.FindDuplicates(p => p.Code);

var result = duplicateBrokers.Distinct(StringComparer.OrdinalIgnoreCase);

Output
ALID-HEA-CO-001
EMIL-MTR-CO-012

Using this representative result set i have been able to update all values in the first DISTINCT duplicates set using the following snippet:
static void Main(string[] args)
{
NewAGAgentMapping();

}
public static void NewAGAgentMapping()
{

List<broker> gnbc = GetData();
using (SqlConnection conn = new SqlConnection(Helpers.DatabaseConnect))
{
conn.Open();
Models.Broker mappinggg = new Models.Broker();
SqlCommand cmd = new SqlCommand("GetHighestAGCode", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param = new SqlParameter("@returnValue", SqlDbType.Int);
cmd.Parameters.Add("@returnValue", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();

int Counter = Convert.ToInt32(cmd.Parameters["@returnValue"].Value);
int newCode = Counter + 1;
mappinggg.Counter = "AG" + newCode.ToString("000000");

conn.Close();

//Update the Duplicates
var duplicateBrokers = gnbc.FindDuplicates(p => p.Code);

var result = duplicateBrokers.Distinct(StringComparer.OrdinalIgnoreCase);
var first = result.ElementAt(0);

foreach (var dupBroker in duplicateBrokers)
{

using (SqlConnection conn1 = new SqlConnection(Helpers.DatabaseConnect))
{
conn1.Open();
Models.Broker mappingg = new Models.Broker();
var query = "UPDATE BrokerTest SET agent_shortname =@newanalysiscode WHERE agent_shortname=@firstdistinctset";
SqlCommand command = new SqlCommand(query, conn1);
command.Parameters.AddWithValue("@newanalysiscode", Convert.ToString(mappinggg.Counter));
command.Parameters.AddWithValue("@firstdistinctset", first);
SqlCommand command = new SqlCommand(query, conn1);

command.ExecuteNonQuery();
conn1.Close();
}
}
}


i.e
ALID-HEA-CO-001 -- AG00024
ALID-HEA-CO-001 -- AG00024
ALID-HEA-CO-001 -- AG00024

My question , how do i then update all values in the 2nd distinct set, 3rd distinct set etc .With code above 2nd set is successfully updating to :
EMIL-MTR-CO-012 -- AG00025
EMIL-MTR-CO-012 -- AG00025

I feel there is some LINQ method that i can apply to the "result" variable. Ideally a dynamic way of referencing the values in "result" rather than using ElementAt()... it should then be easier to update all values in duplicateBrokers that are similar to the value at index 0, 1 , 2 etc of "result".

Thanks for the insight. I have amended to
static void Main(string[] args) {
List<broker> BrokerList = GetData();
foreach(Broker b in BrokerList) {
Console.WriteLine(b);
}
}
as above .. Console prints a list but incorrect values :
StringsTest.Models.Broker.
StringsTest.Models.Broker
StringsTest.Models.Broker
StringsTest.Models.Broker
..........................
Seems GetData() is still not retrieving values. Could it be because my SP does not have an OUTPUT parameter.

Thanks guys.. On changing to an UPDATE statement i am still unable to insert into the columns with NULL values..What am i missing,
using (SqlConnection conn = new SqlConnection(Helpers.DatabaseConnect))
{
Models.FileUpload.Mapping mapping = new Models.FileUpload.Mapping();

SqlCommand cmd = new SqlCommand("SELECT DISTINCT transdetail_id FROM TData WHERE period_name='" + Convert.ToString(reportingPeriod) + "' AND agent_shortname IS NULL", conn);

conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read() == true)
{
mapping.TransactionDetailId = Convert.ToString(dr["transdetail_id"]);
}

else if (dr.Read() == false)
{
mapping.TransactionDetailId = string.Empty;
}
conn.Close();

SqlCommand cmd1 = new SqlCommand("SELECT company_code FROM TData WHERE transdetail_id='" + Convert.ToString(mapping.TransactionDetailId) + "'", conn);
conn.Open();
SqlDataReader dr1 = cmd1.ExecuteReader();
if (dr1.Read() == true)
{

mapping.companycode = Convert.ToString(dr1["company_code"]);
}
else if (dr.Read() == false)
{
mapping.companycode = string.Empty;
}

conn.Close();
}
using (SqlConnection conn1 = new SqlConnection(Helpers.DatabaseConnect))
{
Models.FileUpload.Mapping mapping = new Models.FileUpload.Mapping();

if (mapping.companycode == Harare)
{
String query = "UPDATE TData SET agent_shortname =@agentanalysiscode WHERE company_code=@companycode";
SqlCommand cmd3 = new SqlCommand(query, conn1);
cmd3.Parameters.AddWithValue("@company_code", Convert.ToString(mapping.companycode));
cmd3.Parameters.AddWithValue("@agentanalysiscode", HreCode);
try
{
conn1.Open();
cmd3.ExecuteNonQuery();
}
catch (SqlException e)
{
ViewBag.ErrorMessage = "Processing error !";
return View();
}
conn1.Close();
}

else if (mapping.companycode == Bulawayo)
{

String query = "UPDATE TData SET agent_shortname =@agentanalysiscode WHERE company_code=@companycode";
SqlCommand cmd3 = new SqlCommand(query, conn1);
cmd3.Parameters.AddWithValue("@company_code", Convert.ToString(mapping.companycode));
cmd3.Parameters.AddWithValue("@agentanalysiscode", ByoCode);
try
{
conn1.Open();
cmd3.ExecuteNonQuery();
}
catch (SqlException e)
{
ViewBag.ErrorMessage = "Processing error !";
return View();
}
conn1.Close();
}


}

I have changed my SP as above. In code i no longer get DBNull exception, i can retrieve the value but it reterieves a 0.

Runnning the query as-is without the MAX, i get the integer parts only i.e 123, 768, 769. I have changed the code to
int counter = Convert.ToInt32(cmd.Parameters["@returnValue"].Value); and indeed i still get Object cannot be cast from dbnull to other types

Will it be a case of reading the XML data via the class then , if so how. im not entirely sure how to incorporate the deserialized object in my implementation.