public void SaveCustomer(List<Customers> custdata)
{
string cs = ConfigurationManager.ConnectionStrings["YleanaConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand cmd = new SqlCommand("spaddcustomer", con);
cmd.CommandType = CommandType.StoredProcedure;
//yourArrayList.get(yourArrayList.size() - 1);
// int i=custdata.get(custdata.l - 1);
var lastitem= custdata.LastOrDefault();
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@CustomerName",
// Value = custdata[0].CustomerName
Value=lastitem.CustomerName
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@ContactName",
//Value = custdata[0].ContactName
Value=lastitem.ContactName
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Address",
// Value = custdata[0].Address
Value = lastitem.Address
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@City",
// Value = custdata[0].City
Value=lastitem.City
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Postalcode",
// Value = custdata[0].Postalcode
Value=lastitem.Postalcode
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Country",
// Value = custdata[0].Country
Value=lastitem.Country
});
cmd.ExecuteNonQuery();
con.Close();
}
//return custdata;
}
