//btnAdd_Click
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
try
{
if (txbCard.Text.Trim() == "")
{
tblNotification.Text = FindResource("card_null").ToString();
return;
}
EC_tb_Payment ec_payment = new EC_tb_Payment();
//ec_payment.PaymentID = bus_payment.GetMaxPaymentID("") + 1;
ec_payment.Card = txbCard.Text.Trim();
if (bus_payment.InsertPayment(ec_payment, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
if (add_delegate != null)
{
add_delegate();
this.Close();
}
}
}
catch (Exception ex)
{
tblNotification.Text = ex.Message;
}
}
//GetPayment
private void GetPayment()
{
list_ec_payment.Clear();
int no = 0;
foreach (DataRow dr in bus_tb_payment.GetPayment("").Rows)
{
if (Convert.ToInt32(dr["PaymentID"].ToString()) != 1)
{
EC_tb_Payment ec_payment = new EC_tb_Payment();
ec_payment.No = ++no;
ec_payment.PaymentID = Convert.ToInt32(dr["PaymentID"].ToString());
ec_payment.Card = dr["Card"].ToString();
ec_payment.RdoCard = new RadioButton();
if (no == 1)
{
ec_payment.RdoCard.IsChecked = true;
}
stpCard.Children.Add(ec_payment.RdoCard);
ec_payment.SepCard = new Separator();
stpCard.Children.Add(ec_payment.SepCard);
list_ec_payment.Add(ec_payment);
}
}
}
//btnSave_Click
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
if (txbCard.Text.Trim() == "")
{
tblNotification.Text = FindResource("card_null").ToString();
return;
}
EC_tb_Payment ec_payment = new EC_tb_Payment();
ec_payment.PaymentID = Convert.ToInt32(tblPaymentID.Text.Trim());
ec_payment.Card = txbCard.Text.Trim();
if (bus_payment.UpdatePayment(ec_payment, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
if (edit_delegate != null)
{
edit_delegate();
this.Close();
}
}
}
catch (Exception ex)
{
tblNotification.Text = ex.Message;
}
}
private void GetPayment()
{
if (thread_payment != null && thread_payment.ThreadState == ThreadState.Running)
{
}
else
{
thread_payment = new Thread(() =>
{
try
{
list_ec_tb_payment.Clear();
this.lbPayment.Dispatcher.Invoke((Action)(() => { this.lbPayment.Items.Refresh(); }));
dt_tb_payment.Clear();
dt_tb_payment = bus_tb_payment.GetPayment("");
foreach (DataRow datarow in dt_tb_payment.Rows)
{
EC_tb_Payment ec_tb_payment = new EC_tb_Payment();
ec_tb_payment.PaymentID = Convert.ToInt32(datarow["PaymentID"].ToString());
ec_tb_payment.Card = datarow["Card"].ToString();
list_ec_tb_payment.Add(ec_tb_payment);
}
this.Dispatcher.Invoke((Action)(() =>
{
this.tblPaymentTotal.Text = list_ec_tb_payment.Count.ToString();
this.lbPayment.Items.Refresh();
}));
if (list_ec_tb_payment.Count > 0)
{
this.Dispatcher.Invoke((Action)(() => { this.lbPayment.SelectedIndex = 0; }));
}
}
catch (Exception ex)
{
this.Dispatcher.Invoke((Action)(() =>
{
ModernDialog md = new ModernDialog();
md.Title = FindResource("notification").ToString();
md.CloseButton.Content = FindResource("close").ToString();
md.Content = ex.Message;
md.ShowDialog();
}));
}
});
thread_payment.Start();
}
}
//update Payment
public int UpdatePayment(EC_tb_Payment ec_tb_pay, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Payment] SET [Card]= '" + ec_tb_pay.Card + "' WHERE [PaymentID]=" + ec_tb_pay.PaymentID + ";";
}
else
{
sql = "UPDATE [tb_Payment] SET [Card]= N'" + ec_tb_pay.Card + "' WHERE [PaymentID]=" + ec_tb_pay.PaymentID + ";";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert Payment
public int InsertPayment(EC_tb_Payment ec_tb_pay, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Payment] ([Card]) VALUES('" + ec_tb_pay.Card + "');";
}
else
{
sql = "INSERT INTO [tb_Payment] ([Card]) VALUES(N'" + ec_tb_pay.Card + "');";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//InSertAllPayment
private int InSertAllPayment(DataTable tb_payment)
{
int result = 0;
foreach (DataRow datarow in tb_payment.Rows)
{
if (datarow[0].ToString() != "")
{
EC_tb_Payment ec_tb_payment = new EC_tb_Payment();
ec_tb_payment.PaymentID = Convert.ToInt32(datarow[0].ToString());
ec_tb_payment.Card = StaticClass.GeneralClass.HandlingSpecialCharacter(datarow[1].ToString());
if (bus_tb_payment.InsertPayment(ec_tb_payment, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
result++;
}
}
}
return(result);
}
//delete Payment
public int DeletePayment(EC_tb_Payment ec_tb_pay)
{
return(sql_tb_pay.DeletePayment(ec_tb_pay));
}
//update Payment
public int UpdatePayment(EC_tb_Payment ec_tb_pay, bool data_type)
{
return(sql_tb_pay.UpdatePayment(ec_tb_pay, data_type));
}
//insert Payment
public int InsertPayment(EC_tb_Payment ec_tb_pay, bool data_type)
{
return(sql_tb_pay.InsertPayment(ec_tb_pay, data_type));
}
//delete Payment
public int DeletePayment(EC_tb_Payment ec_tb_pay)
{
string sql = "DELETE FROM [tb_Payment] WHERE [PaymentID]=" + ec_tb_pay.PaymentID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
private void GetPayment()
{
if (thread_content != null && thread_content.ThreadState == ThreadState.Running)
{
}
else
{
thread_content = new Thread(() =>
{
try
{
list_ec_payment.Clear();
this.Dispatcher.Invoke((Action)(() =>
{
this.dtgCard.Visibility = System.Windows.Visibility.Hidden;
this.mpr.Visibility = System.Windows.Visibility.Visible;
this.mpr.IsActive = true;
}));
int no = 0;
foreach (DataRow datarow in bus_payment.GetPayment("").Rows)
{
//if(datarow["Card"].ToString() != "Cash" && datarow["Card"].ToString() != "Gift Card")
//{
EC_tb_Payment ec_payment = new EC_tb_Payment();
ec_payment.No = ++no;
ec_payment.PaymentID = Convert.ToInt32(datarow["PaymentID"].ToString());
ec_payment.Card = datarow["Card"].ToString();
ec_payment.EditImage = @"pack://*****:*****@"pack://application:,,,/Resources/delete.png";
list_ec_payment.Add(ec_payment);
//}
}
this.Dispatcher.Invoke((Action)(() =>
{
tblTotal.Text = FindResource("total").ToString() + "(" + list_ec_payment.Count.ToString() + ")";
dtgCard.Items.Refresh();
}));
Thread.Sleep(500);
this.Dispatcher.Invoke((Action)(() =>
{
this.mpr.Visibility = System.Windows.Visibility.Hidden;
this.mpr.IsActive = false;
this.dtgCard.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();
}
}
