//insert Setting
public int InsertSetting(EC_tb_Setting ec_tb_set, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Currency] ([Currency],[TaxRate],[Active],[Version]) VALUES('" + ec_tb_set.Currency + "'," + ec_tb_set.TaxRate.ToString(new CultureInfo("en-US")) + "," + ec_tb_set.Active + "," + ec_tb_set.Version + ")";
}
else
{
sql = "INSERT INTO [tb_Currency] ([Currency],[TaxRate],[Active],[Version]) VALUES( N'" + ec_tb_set.Currency + "', " + ec_tb_set.TaxRate.ToString(new CultureInfo("en-US")) + ", " + ec_tb_set.Active + ", " + ec_tb_set.Version + ")";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update Setting
public int UpdateSetting(EC_tb_Setting ec_tb_set, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Currency] SET [Currency] ='" + ec_tb_set.Currency + "', [TaxRate] = " + ec_tb_set.TaxRate.ToString(new CultureInfo("en-US")) + ", [Active]= " + ec_tb_set.Active + ", [Version] = " + ec_tb_set.Version +
" WHERE [SettingID] =" + ec_tb_set.SettingID;
}
else
{
sql = "UPDATE [tb_Currency] SET [Currency] = N'" + ec_tb_set.Currency + "', [TaxRate] = " + ec_tb_set.TaxRate.ToString(new CultureInfo("en-US")) + ", [Active] = " + ec_tb_set.Active + ", [Version] = " + ec_tb_set.Version +
" WHERE [SettingID] =" + ec_tb_set.SettingID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//muiBtnOK_Click
private void muiBtnOK_Click(object sender, RoutedEventArgs e)
{
if (StaticClass.GeneralClass.list_ec_tb_setting_general.Count == 0)
{
tblNotification.Text = FindResource("select_least_currency").ToString();
}
else
{
try
{
int result = 0;
for (int i = 0; i < StaticClass.GeneralClass.list_ec_tb_setting_general.Count; i++)
{
EC_tb_Setting ec_tb_setting = new EC_tb_Setting();
ec_tb_setting.SettingID = StaticClass.GeneralClass.list_ec_tb_setting_general[i].SettingID;
if (StaticClass.GeneralClass.list_ec_tb_setting_general[i].Active == 1)
{
tblNotification.Text = FindResource("currency").ToString() + (" ") + StaticClass.GeneralClass.list_ec_tb_setting_general[i].Currency + " " + FindResource("already_uses").ToString();
}
else
{
if (bus_tb_setting.DeleteSetting(ec_tb_setting) == 1)
{
result++;
}
}
}
if (result > 0)
{
if (delete_delegate != null)
{
StaticClass.GeneralClass.list_ec_tb_setting_general.Clear();
delete_delegate();
this.Close();
}
}
}
catch (Exception ex)
{
tblNotification.Text = ex.Message;
}
}
}
//InSertAllSetting
private int InSertAllSetting(DataTable tb_setting)
{
int result = 0;
foreach (DataRow datarow in tb_setting.Rows)
{
if (datarow[0].ToString() != "")
{
EC_tb_Setting ec_tb_setting = new EC_tb_Setting();
ec_tb_setting.SettingID = Convert.ToInt32(datarow[0].ToString());
ec_tb_setting.Currency = datarow[1].ToString();
ec_tb_setting.TaxRate = Convert.ToDecimal(datarow[2].ToString());
ec_tb_setting.Active = Convert.ToInt32(datarow[3].ToString());
ec_tb_setting.Version = Convert.ToInt32(datarow[4].ToString());
if (bus_tb_setting.InsertSetting(ec_tb_setting, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
result++;
}
}
}
return(result);
}
//btnAdd_Click
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
try
{
if (txbCurrency.Text.Trim() == "")
{
tblNotification.Text = FindResource("currency_null").ToString();
return;
}
if (txbTaxRate.Text.Trim() == "")
{
tblNotification.Text = FindResource("tax_rate_null").ToString();
return;
}
decimal taxrate = 0;
if (!decimal.TryParse(txbTaxRate.Text.Trim(), NumberStyles.AllowDecimalPoint, StaticClass.GeneralClass.app_settings["decimalSeparator"].ToString() == "0" ? new CultureInfo("en-US") : new CultureInfo("fr-FR"), out taxrate))
{
tblNotification.Text = FindResource("tax_rate_invalid").ToString();
return;
}
if (taxrate >= 100 || taxrate < 0)
{
tblNotification.Text = FindResource("tax_rate_value_invalid").ToString();
return;
}
int version = 1;
if (int.TryParse(txbVersion.Text.Trim().ToString(), out version) == false)
{
tblNotification.Text = FindResource("version_invalid").ToString();
return;
}
else
{
EC_tb_Setting setting = new EC_tb_Setting();
setting.Currency = StaticClass.GeneralClass.HandlingSpecialCharacter(txbCurrency.Text.Trim().ToString());
setting.TaxRate = taxrate;
setting.Version = version;
if (chkActive.IsChecked == true)
{
setting.Active = 1;
bus_tb_setting.UpdateSettingActive();
}
else
{
setting.Active = 0;
}
if (bus_tb_setting.InsertSetting(setting, StaticClass.GeneralClass.flag_database_type_general) == 1)
{
if (setting.Active == 1)
{
DataTable tb_setting = bus_tb_setting.GetSetting("WHERE [SettingID] = (SELECT MAX([SettingID]) FROM [tb_Currency])");
if (tb_setting.Rows.Count == 1)
{
StaticClass.GeneralClass.flag_add_edit_setting_general = true;
StaticClass.GeneralClass.settingid_setting_general = Convert.ToInt32(tb_setting.Rows[0]["SettingID"].ToString());
StaticClass.GeneralClass.currency_setting_general = tb_setting.Rows[0]["Currency"].ToString() + " ";
StaticClass.GeneralClass.taxrate_setting_general = Convert.ToDecimal(tb_setting.Rows[0]["TaxRate"].ToString());
StaticClass.GeneralClass.active_setting_general = Convert.ToInt32(tb_setting.Rows[0]["Active"].ToString());
StaticClass.GeneralClass.version_setting_general = Convert.ToInt32(tb_setting.Rows[0]["Version"].ToString());
}
}
if (add_delegate != null)
{
add_delegate();
this.Close();
}
}
}
}
catch (Exception ex)
{
tblNotification.Text = ex.Message;
}
}
//delete Setting
public int DeleteSetting(EC_tb_Setting ec_tb_set)
{
string sql = "DELETE FROM [tb_Currency] WHERE [SettingID] =" + ec_tb_set.SettingID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
private void GetListSetting()
{
if (thread_set != null && thread_set.ThreadState == ThreadState.Running)
{
}
else
{
thread_set = new Thread(() =>
{
try
{
dt_setting.Clear();
list_ec_tb_setting.Clear();
this.Dispatcher.Invoke((Action)(() =>
{
this.chkAll.IsChecked = false;
this.dtgCurrency.Items.Refresh();
this.dtgCurrency.Visibility = System.Windows.Visibility.Hidden;
this.mpr.Visibility = System.Windows.Visibility.Visible;
this.mpr.IsActive = true;
}));
dt_setting = bus_tb_setting.GetSetting("");
int no = 0;
foreach (DataRow datarow in dt_setting.Rows)
{
no++;
EC_tb_Setting ec_tb_setting = new EC_tb_Setting();
ec_tb_setting.No = no;
ec_tb_setting.SettingID = Convert.ToInt32(datarow["SettingID"].ToString());
ec_tb_setting.Currency = datarow["Currency"].ToString();
ec_tb_setting.TaxRate = Convert.ToDecimal(datarow["TaxRate"].ToString());
ec_tb_setting.StrTaxRate = GeneralClass.GetNumFormatDisplay(ec_tb_setting.TaxRate);
ec_tb_setting.Active = Convert.ToInt32(datarow["Active"].ToString());
ec_tb_setting.Version = Convert.ToInt32(datarow["Version"].ToString());
ec_tb_setting.ImageUrl = @"pack://application:,,,/Resources/edit.png";
list_ec_tb_setting.Add(ec_tb_setting);
}
this.Dispatcher.Invoke((Action)(() =>
{
this.dtgCurrency.Items.Refresh();
this.tblTotal.Text = FindResource("total").ToString() + "(" + list_ec_tb_setting.Count.ToString() + ")";
}));
Thread.Sleep(500);
this.mpr.Dispatcher.Invoke((Action)(() =>
{
this.mpr.Visibility = System.Windows.Visibility.Hidden;
this.mpr.IsActive = false;
}));
this.dtgCurrency.Dispatcher.Invoke((Action)(() => { this.dtgCurrency.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_set.Start();
}
}
//delete Setting
public int DeleteSetting(EC_tb_Setting ec_tb_set)
{
return(sql_tb_set.DeleteSetting(ec_tb_set));
}
//update Setting
public int UpdateSetting(EC_tb_Setting ec_tb_set, bool data_type)
{
return(sql_tb_set.UpdateSetting(ec_tb_set, data_type));
}
//insert Setting
public int InsertSetting(EC_tb_Setting ec_tb_set, bool data_type)
{
return(sql_tb_set.InsertSetting(ec_tb_set, data_type));
}
