//InSertAllCustomer
private int InSertAllCustomer(DataTable tb_customer)
{
int result = 0;
foreach (DataRow datarow in tb_customer.Rows)
{
if (datarow[0].ToString() != "")
{
EC_tb_Customer ec_tb_customer = new EC_tb_Customer();
ec_tb_customer.CustomerID = Convert.ToInt32(datarow[0].ToString());
ec_tb_customer.FirstName = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[1].ToString());
ec_tb_customer.LastName = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[2].ToString());
ec_tb_customer.Address1 = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[3].ToString());
ec_tb_customer.Address2 = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[4].ToString());
ec_tb_customer.City = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[5].ToString());
ec_tb_customer.State = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[6].ToString());
ec_tb_customer.Zipcode = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[7].ToString());
ec_tb_customer.Phone = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[8].ToString());
ec_tb_customer.Email = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[9].ToString());
if (bus_tb_customer.InsertCustomer(ec_tb_customer, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
result++;
}
}
}
return(result);
}
//muiBtnOK_Click
private void muiBtnOK_Click(object sender, RoutedEventArgs e)
{
if (txbFirstname.Text == "")
{
tblNotification.Text = FindResource("first_name_null").ToString();
txbFirstname.Focus();
return;
}
if (txbLastname.Text == "")
{
tblNotification.Text = FindResource("last_name_null").ToString();
txbLastname.Focus();
return;
}
else
{
try
{
EC_tb_Customer ec_tb_customer = new EC_tb_Customer();
//ec_tb_customer.CustomerID = bus_tb_customer.GetMaxCustomerID("") + 1;
ec_tb_customer.FirstName = StaticClass.GeneralClass.HandlingSpecialCharacter(txbFirstname.Text.Trim().ToString());
ec_tb_customer.LastName = StaticClass.GeneralClass.HandlingSpecialCharacter(txbLastname.Text.Trim().ToString());
ec_tb_customer.Address1 = StaticClass.GeneralClass.HandlingSpecialCharacter(txbAddress1.Text.Trim().ToString());
ec_tb_customer.Address2 = StaticClass.GeneralClass.HandlingSpecialCharacter(txbAddress2.Text.Trim().ToString());
ec_tb_customer.City = StaticClass.GeneralClass.HandlingSpecialCharacter(txbCity.Text.Trim().ToString());
ec_tb_customer.State = StaticClass.GeneralClass.HandlingSpecialCharacter(txbState.Text.Trim().ToString());
ec_tb_customer.Zipcode = StaticClass.GeneralClass.HandlingSpecialCharacter(txbZipcode.Text.Trim().ToString());
ec_tb_customer.Phone = StaticClass.GeneralClass.HandlingSpecialCharacter(txbPhone.Text.Trim().ToString());
ec_tb_customer.Email = StaticClass.GeneralClass.HandlingSpecialCharacter(txbEmail.Text.Trim().ToString());
if (bus_tb_customer.InsertCustomer(ec_tb_customer, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
if (muibtnadd_delegate != null)
{
muibtnadd_delegate(true);
}
this.Close();
}
else
{
tblNotification.Text = FindResource("error_insert").ToString();
}
}
catch (Exception ex)
{
tblNotification.Text = ex.Message;
}
}
}
