private List <EC_tb_SalesPerson> GetSalesperson()
{
list_ec_tb_salesperson.Clear();
using (DataTable dt_salesperson = bus_tb_salesperson.GetSalesPerson("WHERE [Active] = 1"))
{
foreach (DataRow datarow in dt_salesperson.Rows)
{
EC_tb_SalesPerson ec_tb_salasperson = new EC_tb_SalesPerson();
ec_tb_salasperson.SalespersonID = Convert.ToInt32(datarow["SalespersonID"].ToString());
ec_tb_salasperson.Name = datarow["Name"].ToString();
ec_tb_salasperson.Address = datarow["Address"].ToString();
ec_tb_salasperson.Password = datarow["Password"].ToString();
ec_tb_salasperson.Active = Convert.ToInt32(datarow["Active"].ToString());
ec_tb_salasperson.Defaul = Convert.ToInt32(datarow["Default"].ToString());
if (ec_tb_salasperson.Defaul == 1)
{
ec_tb_salasperson.ImageUrl = @"pack://*****:*****@"pack://application:,,,/Resources/login.png";
}
list_ec_tb_salesperson.Add(ec_tb_salasperson);
}
}
dtgSalesperson.Items.Refresh();
return(list_ec_tb_salesperson);
}
//InSertAllSalesperson
private int InSertAllSalesperson(DataTable tb_salesperson)
{
int result = 0;
foreach (DataRow datarow in tb_salesperson.Rows)
{
if (datarow[0].ToString() != "")
{
EC_tb_SalesPerson ec_tb_salesperson = new EC_tb_SalesPerson();
ec_tb_salesperson.SalespersonID = Convert.ToInt32(datarow[0].ToString());
ec_tb_salesperson.Name = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[1].ToString());
ec_tb_salesperson.Birthday = datarow[2].ToString();
ec_tb_salesperson.Address = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[3].ToString());
ec_tb_salesperson.Email = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[4].ToString());
ec_tb_salesperson.Password = datarow[5].ToString();
ec_tb_salesperson.Active = Convert.ToInt32(datarow[6].ToString());
ec_tb_salesperson.Defaul = Convert.ToInt32(datarow[7].ToString());
if (bus_tb_salesperson.InsertSalesPerson(ec_tb_salesperson, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
result++;
}
}
}
return(result);
}
private void GetSalesperson()
{
if (thread_salesperson != null && thread_salesperson.ThreadState == ThreadState.Running)
{
}
else
{
thread_salesperson = new Thread(() =>
{
try
{
list_ec_tb_salesperson.Clear();
this.Dispatcher.Invoke((Action)(() => { lbSalesperson.Items.Refresh(); }));
dt_tb_salesperson.Clear();
dt_tb_salesperson = bus_tb_salesperson.GetSalesPerson("");
foreach (DataRow datarow in dt_tb_salesperson.Rows)
{
EC_tb_SalesPerson ec_tb_salesperson = new EC_tb_SalesPerson();
ec_tb_salesperson.SalespersonID = Convert.ToInt32(datarow["SalespersonID"].ToString());
ec_tb_salesperson.Name = datarow["Name"].ToString();
ec_tb_salesperson.Birthday = datarow["Birthday"].ToString();
ec_tb_salesperson.Address = datarow["Address"].ToString();
ec_tb_salesperson.Email = datarow["Email"].ToString();
ec_tb_salesperson.Password = datarow["Password"].ToString();
ec_tb_salesperson.Active = Convert.ToInt32(datarow["Active"].ToString());
list_ec_tb_salesperson.Add(ec_tb_salesperson);
}
this.Dispatcher.Invoke((Action)(() =>
{
tblSalespersonTotal.Text = list_ec_tb_salesperson.Count.ToString();
lbSalesperson.Items.Refresh();;
}));
if (list_ec_tb_salesperson.Count > 0)
{
this.Dispatcher.Invoke((Action)(() => { this.lbSalesperson.SelectedIndex = 0; }));
}
}
catch (Exception ex)
{
this.Dispatcher.Invoke((Action)(() =>
{
ModernDialog md = new ModernDialog();
md.CloseButton.Content = FindResource("close").ToString();
md.Title = FindResource("notification").ToString();
md.Content = ex.Message;
md.ShowDialog();
}));
}
});
thread_salesperson.Start();
}
}
//muiBtnOK_Click
private void muiBtnOK_Click(object sender, RoutedEventArgs e)
{
if (txbName.Text == "")
{
tblNotification.Text = FindResource("name_null").ToString();
txbName.Focus();
return;
}
if (pwbPassword.Password.Trim() == "")
{
tblNotification.Text = FindResource("password_null").ToString();
pwbPassword.Focus();
return;
}
else
{
try
{
EC_tb_SalesPerson ec_tb_salesperson = new EC_tb_SalesPerson();
//ec_tb_salesperson.SalespersonID = bus_tb_salesperson.GetMaxSalespersonID("") + 1;
ec_tb_salesperson.Name = StaticClass.GeneralClass.HandlingSpecialCharacter(txbName.Text);
ec_tb_salesperson.Birthday = dtpBirthday.Text;
ec_tb_salesperson.Address = StaticClass.GeneralClass.HandlingSpecialCharacter(txbAddress.Text);
ec_tb_salesperson.Email = StaticClass.GeneralClass.HandlingSpecialCharacter(txbEmail.Text);
ec_tb_salesperson.Password = StaticClass.GeneralClass.MD5Hash(pwbPassword.Password);
ec_tb_salesperson.Defaul = 0;
if (chkActive.IsChecked == false)
{
ec_tb_salesperson.Active = 0;
}
else
{
ec_tb_salesperson.Active = 1;
}
if (bus_tb_salesperson.InsertSalesPerson(ec_tb_salesperson, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
if (muibtnadd_delegate != null)
{
muibtnadd_delegate();
}
this.Close();
}
}
catch (Exception ex)
{
tblNotification.Text = ex.Message;
}
}
}
//upadate SalesPerson
public int UpdateSalesperson(EC_tb_SalesPerson ec_tb_sp, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Salesperson] SET [Name] ='" + ec_tb_sp.Name + "', [Birthday]='" + ec_tb_sp.Birthday + "', [Address]='" + ec_tb_sp.Address + "', [Email]='" + ec_tb_sp.Email + "', [Password]='" + ec_tb_sp.Password + "', [Active]=" + ec_tb_sp.Active + " WHERE [SalespersonID]=" + ec_tb_sp.SalespersonID;
}
else
{
sql = "UPDATE [tb_Salesperson] SET [Name] = N'" + ec_tb_sp.Name + "', [Birthday] = N'" + ec_tb_sp.Birthday + "', [Address] = N'" + ec_tb_sp.Address + "', [Email]= N'" + ec_tb_sp.Email + "', [Password]= N'" + ec_tb_sp.Password + "', [Active] = " + ec_tb_sp.Active + " WHERE [SalespersonID] = " + ec_tb_sp.SalespersonID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert SalesPerson
public int InsertSalesperson(EC_tb_SalesPerson ec_tb_sp, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Salesperson]([Name], [Birthday], [Address], [Email], [Password], [Active]) VALUES('" + ec_tb_sp.Name + "', '" + ec_tb_sp.Birthday + "', '" + ec_tb_sp.Address + "', '" + ec_tb_sp.Email + "', '" + ec_tb_sp.Password + "', " + ec_tb_sp.Active + ")";
}
else
{
sql = "INSERT INTO [tb_Salesperson]([Name], [Birthday], [Address], [Email], [Password], [Active]) VALUES(N'" + ec_tb_sp.Name + "', N'" + ec_tb_sp.Birthday + "', N'" + ec_tb_sp.Address + "', N'" + ec_tb_sp.Email + "', N'" + ec_tb_sp.Password + "', " + ec_tb_sp.Active + ")";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//muiBtnOK_Click
private void muiBtnOK_Click(object sender, RoutedEventArgs e)
{
if (StaticClass.GeneralClass.list_ec_tb_salesperson_general.Count == 0)
{
tblNotification.Text = FindResource("select_least_salesperson").ToString();
}
else
{
try
{
int result = 0;
for (int i = 0; i < StaticClass.GeneralClass.list_ec_tb_salesperson_general.Count; i++)
{
if (bus_tb_order.GetOrder("WHERE [SalespersonID]=" + StaticClass.GeneralClass.list_ec_tb_salesperson_general[i].SalespersonID).Rows.Count > 0)
{
tblNotification.Text = FindResource("salesperson_id").ToString() + ": " + StaticClass.GeneralClass.list_ec_tb_salesperson_general[i].SalespersonID.ToString() + " " + FindResource("already_uses").ToString();
}
else
{
EC_tb_SalesPerson ec_tb_salesperson = new EC_tb_SalesPerson();
ec_tb_salesperson.SalespersonID = StaticClass.GeneralClass.list_ec_tb_salesperson_general[i].SalespersonID;
if (bus_tb_salesperson.DeleteSalesPerson(ec_tb_salesperson) == 1)
{
result++;
}
}
}
if (result > 0)
{
if (muibtndelete_delegate != null)
{
StaticClass.GeneralClass.flag_add_edit_delete_salesperson_general = true;
StaticClass.GeneralClass.list_ec_tb_salesperson_general.Clear();
muibtndelete_delegate();
this.Close();
}
}
}
catch (Exception ex)
{
tblNotification.Text = ex.Message;
}
}
}
//get salesperson
private void GetSalesperson(string condition)
{
if (thread_content != null && thread_content.ThreadState == ThreadState.Running)
{
}
else
{
thread_content = new Thread(() =>
{
try
{
list_ec_tb_salesperson.Clear();
this.Dispatcher.Invoke((Action)(() =>
{
this.mpr.IsActive = true;
this.chkCheckAll.IsChecked = false;
this.dtgSalesperson.Items.Refresh();
this.dtgSalesperson.Visibility = System.Windows.Visibility.Hidden;
}));
using (DataTable dt_salesperson = bus_tb_salesperson.GetSalesPerson(condition))
{
int no = 0;
foreach (DataRow dr in dt_salesperson.Rows)
{
no++;
EC_tb_SalesPerson ec_tb_salasperson = new EC_tb_SalesPerson();
ec_tb_salasperson.No = no;
ec_tb_salasperson.SalespersonID = Convert.ToInt32(dr["SalespersonID"].ToString());
ec_tb_salasperson.Name = dr["Name"].ToString();
ec_tb_salasperson.Birthday = dr["Birthday"].ToString();
ec_tb_salasperson.Address = dr["Address"].ToString();
ec_tb_salasperson.Email = dr["Email"].ToString();
ec_tb_salasperson.Password = dr["Password"].ToString();
ec_tb_salasperson.Active = Convert.ToInt32(dr["Active"].ToString());
ec_tb_salasperson.CheckDel = false;
ec_tb_salasperson.ImageUrl = @"pack://application:,,,/Resources/edit.png";
list_ec_tb_salesperson.Add(ec_tb_salasperson);
}
}
this.Dispatcher.Invoke((Action)(() =>
{
tblTotal.Text = FindResource("total").ToString() + "(" + list_ec_tb_salesperson.Count + ")";
dtgSalesperson.Items.Refresh();
}));
Thread.Sleep(500);
this.mpr.Dispatcher.Invoke((Action)(() =>
{
this.mpr.Visibility = System.Windows.Visibility.Hidden;
this.mpr.IsActive = false;
}));
this.dtgSalesperson.Dispatcher.Invoke((Action)(() => { this.dtgSalesperson.Visibility = System.Windows.Visibility.Visible; }));
}
catch (Exception ex)
{
this.Dispatcher.Invoke((Action)(() =>
{
ModernDialog md = new ModernDialog();
md.CloseButton.Content = FindResource("close").ToString();
md.Title = FindResource("notification").ToString();
md.Content = ex.Message;
md.ShowDialog();
}));
}
});
thread_content.Start();
}
}
//delete SalesPerson
public int DeleteSalesperson(EC_tb_SalesPerson ec_tb_sp)
{
string sql = "DELETE from [tb_SalesPerson] where [SalespersonID]=" + ec_tb_sp.SalespersonID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
//muiBtnOK_Click
private void muiBtnOK_Click(object sender, RoutedEventArgs e)
{
if (txbName.Text.Trim() == "")
{
tblNotification.Text = FindResource("salesperson_name_null").ToString();
return;
}
else
{
try
{
if ((bus_tb_salesperson.GetSalesPerson("WHERE [Active]=1").Rows.Count <= 1) && (chkActive.IsChecked == false))
{
tblNotification.Text = FindResource("choose_a_salesperson").ToString();
}
EC_tb_SalesPerson ec_tb_salesperson = new EC_tb_SalesPerson();
ec_tb_salesperson.SalespersonID = Convert.ToInt32(tblSalespersonID.Text.Trim().ToString());
ec_tb_salesperson.Name = StaticClass.GeneralClass.HandlingSpecialCharacter(txbName.Text.Trim());
ec_tb_salesperson.Birthday = dtpBirthday.Text;
ec_tb_salesperson.Address = StaticClass.GeneralClass.HandlingSpecialCharacter(txbAddress.Text.Trim());
ec_tb_salesperson.Email = StaticClass.GeneralClass.HandlingSpecialCharacter(txbEmail.Text.Trim());
ec_tb_salesperson.Defaul = 0;
if (pwbPassword.Password.Trim() == "")
{
ec_tb_salesperson.Password = StaticClass.GeneralClass.salespersonpassword_general;
StaticClass.GeneralClass.salespersonpassword_general = "";
}
else
{
ec_tb_salesperson.Password = StaticClass.GeneralClass.MD5Hash(pwbPassword.Password.Trim().ToString());
}
if (chkActive.IsChecked == true)
{
ec_tb_salesperson.Active = 1;
}
else
{
ec_tb_salesperson.Active = 0;
}
if (bus_tb_salesperson.UpdateSalesPerson(ec_tb_salesperson, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
if (edit_delegate != null)
{
StaticClass.GeneralClass.flag_add_edit_delete_salesperson_general = true;
edit_delegate();
}
this.Close();
}
}
catch (Exception ex)
{
tblNotification.Text = ex.Message;
}
}
}
//delete SalesPerson
public int DeleteSalesPerson(EC_tb_SalesPerson ec_tb_sp)
{
return(sql_tb_sp.DeleteSalesperson(ec_tb_sp));
}
//update SalesPerson
public int UpdateSalesPerson(EC_tb_SalesPerson ec_tb_sp, bool data_type)
{
return(sql_tb_sp.UpdateSalesperson(ec_tb_sp, data_type));
}
//inser SalesPerson
public int InsertSalesPerson(EC_tb_SalesPerson ec_tb_sp, bool data_type)
{
return(sql_tb_sp.InsertSalesperson(ec_tb_sp, data_type));
}
