public override void edit_button_Click(object sender, EventArgs e)
{
if (name_textBox.Text == "" || phone_textBox.Text == "" || address_textBox.Text == "" || password_textBox.Text == "" || username_textBox.Text == "" || roles_comboBox.SelectedIndex == -1)
{
CodingSourceClass.ShowMsg("Please select a record to edit.", "Error");
enable_crud_buttons();
CodingSourceClass.disable_reset(left_panel);
}
else
{
CodingSourceClass.enable(left_panel);
edit = true; //editing option enabled
add_button.Enabled = false; //can't add
delete_button.Enabled = false; //can't delete
view_button.Enabled = false; //can't view
save_button.Enabled = true; //can save after editing
}
}
private void PAYMENT_Load(object sender, EventArgs e)
{
try
{
edit_button.Enabled = false;
LoadPayments();
SQL_TASKS.LoadList("st_getSHOPS", shop_comboBox_payments, "ID", "Name");
cheque_no_textBox.Visible = false; cheque_no_label.Visible = false;
bank_and_branch_label.Visible = false; bank_and_branch_textBox.Visible = false;
clearing_date_label.Visible = false; clearing_date_dateTimePicker.Visible = false;
base.edit_button.Text = "CANNOT EDIT";
CodingSourceClass.disable_reset(left_panel);
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel);
enable_crud_buttons();
}
}
public override void edit_button_Click(object sender, EventArgs e)
{
if (roles_textBox.Text == "" || roles_textBox.Enabled == true)
{
CodingSourceClass.ShowMsg("Please select a record to edit.", "Error");
enable_crud_buttons();
CodingSourceClass.disable_reset(left_panel);
}
else
{
CodingSourceClass.enable(left_panel);
edit = true;
add_button.Enabled = false; //can't add
delete_button.Enabled = false; //can't delete
view_button.Enabled = false; //can't view
save_button.Enabled = true;
}
}
private void sales_invoice_comboBox_payments_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (sales_invoice_comboBox_payments.SelectedIndex != -1)
{
Hashtable ht = new Hashtable();
ht.Add("@custID", Convert.ToInt32(customer_comboBox_payments.SelectedValue.ToString()));
ht.Add("@salesinvoiceID", Convert.ToInt64(sales_invoice_comboBox_payments.SelectedValue.ToString()));
double[] arr = SQL_TASKS.SaleInvoiceAmounts("st_getSALESINVOICEAMOUNT", ht);
total_amount_textBox_payments.Text = arr[0].ToString();
amount_paid_textBox_payments.Text = arr[1].ToString();
remaining_amount_textBox_payments.Text = arr[2].ToString();
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel); enable_crud_buttons();
}
}
private void SALES_RETURN_Load(object sender, EventArgs e)
{
try
{
CodingSourceClass.disable_reset(left_panel);
edit_button.Enabled = false; delete_button.Enabled = false;
LoadSalesReturn();
SQL_TASKS.LoadList("st_getSHOPS", shop_comboBox_salesreturn, "ID", "Name");
base.delete_button.Text = "CANNOT DELETE"; base.delete_button.Enabled = false;
base.edit_button.Text = "CANNOT EDIT"; base.edit_button.Enabled = false;
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel);
enable_crud_buttons();
}
}
public static void load_data(string proc, DataGridView dv, ListBox lb)
{
try
{
SqlConnection sql_con = new SqlConnection(CodingSourceClass.connection());
SqlCommand command = new SqlCommand(proc, sql_con);
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dat = new DataTable();
adapter.Fill(dat);
for (int i = 0; i < lb.Items.Count; i++)
{
string colName1 = ((DataGridViewColumn)lb.Items[i]).Name;
dv.Columns[colName1].DataPropertyName = dat.Columns[i].ToString();
}
dv.DataSource = dat;
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
}
}
//to be fixed
//overloaded version:
public static void load_roles_like(DataGridView dv, DataGridViewColumn RoleGV, string data)
{
SqlConnection sql_con = new SqlConnection(CodingSourceClass.connection());
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "st_getROLESlike";
cmd.Parameters.AddWithValue("@data", data);
cmd.Connection = sql_con;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sqladp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sqladp.Fill(dt);
RoleGV.DataPropertyName = dt.Columns["Role"].ToString();
dv.DataSource = dt;
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
}
}
public override void edit_button_Click(object sender, EventArgs e)
{
try
{
if (shops_comboBox_customers.SelectedIndex == -1)
{
throw new Exception("Please select a record to edit.");
}
else
{
CodingSourceClass.enable(left_panel);
edit = true; //editing option enabled
add_button.Enabled = false; //can't add
delete_button.Enabled = false; //can't delete
view_button.Enabled = false; //can't view
save_button.Enabled = true; //can save after editing
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel); enable_crud_buttons();
}
}
public static void LoadList(string proc, ComboBox cb, string valueMember, string displayMember)
{
try
{
cb.Items.Clear();
SqlConnection sql = new SqlConnection(CodingSourceClass.connection());
SqlCommand cmd = new SqlCommand(proc, sql);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable(); da.Fill(dt);
cb.DisplayMember = displayMember; cb.ValueMember = valueMember;
cb.DataSource = dt; cb.SelectedIndex = -1;
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
}
}
public static int insert_update_delete(string proc, Hashtable ht)
{
int res = 0;
try
{
SqlConnection sql_con = new SqlConnection(CodingSourceClass.connection());
SqlCommand cmd = new SqlCommand(proc, sql_con);
cmd.CommandType = CommandType.StoredProcedure;
foreach (DictionaryEntry item in ht)
{
cmd.Parameters.AddWithValue(item.Key.ToString(), item.Value);
}
sql_con.Open();
//returns an integer which indicates how many rows have been affected
res = cmd.ExecuteNonQuery();
sql_con.Close();
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
}
return(res);
}
private void send_code_button_Click(object sender, EventArgs e)
{
if (email_address_textBox.Text == "")
{
CodingSourceClass.ShowMsg("Please enter email address.", "error");
}
else
{
try
{
Random r = new Random();
x = r.Next(1, 1000000); //Generating 6-digit verification code
SmtpClient cl = new SmtpClient("smtp.gmail.com");
cl.Port = 587;
cl.Credentials = new System.Net.NetworkCredential("*****@*****.**", "syedkamranali90.");
cl.EnableSsl = true;
MailMessage mail = new MailMessage("*****@*****.**", email_address_textBox.Text, "VERIFICATION CODE", "Your confirmation code is " + x.ToString() + ".");
cl.Send(mail);
MessageBox.Show("A code is sent to " + email_address_textBox.Text + ".Enter code to verify it.", "CODE SENT...", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "error");
}
}
}
private void users_dataGridView_CellClick_1(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
add_button.Enabled = false;
if (edit == true) //updating member
{
save_button.Enabled = true;
}
else if (edit == false) //adding member
{
save_button.Enabled = false;
}
DataGridViewRow row = users_dataGridView.Rows[e.RowIndex];
userID = Convert.ToInt32(row.Cells[0].Value.ToString());
name_textBox.Text = row.Cells[1].Value.ToString();
username_textBox.Text = row.Cells[2].Value.ToString();
password_textBox.Text = row.Cells[3].Value.ToString();
phone_textBox.Text = row.Cells[4].Value.ToString();
address_textBox.Text = row.Cells[5].Value.ToString();
roles_comboBox.SelectedValue = row.Cells[6].Value;
CodingSourceClass.disable(left_panel);
delete_button.Enabled = true;
edit_button.Enabled = true;
save_button.Enabled = false;
cancel_button.Enabled = true;
view_button.Enabled = true;
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
enable_crud_buttons();
CodingSourceClass.disable_reset(left_panel);
}
}
private void save_new_details_button_change_Click(object sender, EventArgs e)
{
try
{
if (new_password_textBox_change.Text != "" && admin_radioButton.Checked == true && other_radioButton.Checked == false)
{
Hashtable ht = new Hashtable();
ht.Add("@username", usernameGLOBAL);
ht.Add("@password", new_password_textBox_change.Text);
if (SQL_TASKS.insert_update_delete("st_updateAdminPASSWORD", ht) > 0)
{
CodingSourceClass.ShowMsg("Password changed successfully.", "Success");
clear(); sq.Close();
}
else
{
throw new Exception("An error occured.");
}
}
else if (new_password_textBox_change.Text != "" && admin_radioButton.Checked == false && other_radioButton.Checked == true)
{
Hashtable ht = new Hashtable();
ht.Add("@username", usernameGLOBAL);
ht.Add("@password", new_password_textBox_change.Text);
if (SQL_TASKS.insert_update_delete("st_updateUSERPASSWORD", ht) > 0)
{
CodingSourceClass.ShowMsg("Password changed successfully.", "Success");
clear(); sq.Close();
}
else
{
throw new Exception("An error occured.");
}
}
else
{
throw new Exception("Please fill all required fields properly.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
sq.Close();
}
}
public override void delete_button_Click(object sender, EventArgs e)
{
try
{
if (roles_textBox.Text != "" && roles_textBox.Enabled == false)
{
Hashtable ht = new Hashtable();
DialogResult dr = MessageBox.Show("Are you sure? ", "Question.....", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
//key , value
ht.Add("@id", roleID);
if (SQL_TASKS.insert_update_delete("st_deleteROLES", ht) > 0)
{
MainClass.CodingSourceClass.ShowMsg(roles_textBox.Text + " deleted successfully from the system.", "Success");
CodingSourceClass.disable_reset(left_panel);
enable_crud_buttons();
LoadRoles();
SQL_TASKS.TotalRecords("getTOTALROLES", total_roles_label);
}
else
{
CodingSourceClass.ShowMsg("Unable to delete.", "Error");
CodingSourceClass.disable_reset(left_panel);
enable_crud_buttons();
}
}
}
else
{
CodingSourceClass.ShowMsg("Select a record to delete.", "Error");
enable_crud_buttons();
CodingSourceClass.disable_reset(left_panel);
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel); enable_crud_buttons();
}
}
private void save_settings_button_Click(object sender, EventArgs e)
{
try
{
bool windowsAuth;
if (integrated_checkBox_settings.Checked)
{
if (server_name_textBox_settings.Text != "" && database_textBox_settings.Text != "")
{
windowsAuth = true;
CodingSourceClass.createFile("\\bms_connect", windowsAuth, server_name_textBox_settings.Text, database_textBox_settings.Text);
login log = new login();
CodingSourceClass.ShowWindow(log, this, MDI.ActiveForm);
}
else
{
CodingSourceClass.ShowMsg("Please fill all required fields", "Error");
}
}
else
{
if (server_name_textBox_settings.Text != "" && database_textBox_settings.Text != "" && username_textBox_settings.Text != "" && password_textBox_settings.Text != "")
{
windowsAuth = false;
bool result = CodingSourceClass.createFile("\\bms_connect", windowsAuth, server_name_textBox_settings.Text, database_textBox_settings.Text, username_textBox_settings.Text, password_textBox_settings.Text);
if (result == true)
{
login log = new login();
CodingSourceClass.ShowWindow(log, this, MDI.ActiveForm);
LoginCodeClass.set_logged(true);
}
}
else
{
LoginCodeClass.set_logged(false);
CodingSourceClass.ShowMsg("Please fill all required fields", "Error");
}
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
}
}
private void users_button_Click(object sender, EventArgs e)
{
if (LoginCodeClass.isAdmin == true)
{
USERS us = new USERS();
CodingSourceClass.ShowWindow(us, MDI.ActiveForm);
}
else
{
CodingSourceClass.ShowMsg("You do not have permission to view users.", "Error");
}
}
private void roles_button_Click(object sender, EventArgs e)
{
if (LoginCodeClass.isAdmin == true)
{
ROLES rl = new ROLES();
CodingSourceClass.ShowWindow(rl, MDI.ActiveForm);
}
else
{
CodingSourceClass.ShowMsg("You do not have permission to view roles.", "Error");
}
}
private void logoutToolStripMenuItem1_Click(object sender, EventArgs e)
{
if (LoginCodeClass.get_logged() == true)
{
login lg = new login();
CodingSourceClass.ShowWindow(lg, MDI.ActiveForm);
}
else
{
CodingSourceClass.ShowMsg("Already logged out!", "Error");
}
}
private void verify_code_button_Click(object sender, EventArgs e)
{
if (x.ToString() == verification_code_textBox.Text)
{
disabled_new_details_label.Text = "ENABLED";
disable_control_panel.Enabled = true;
}
else
{
CodingSourceClass.ShowMsg("Incorrect code.", "error");
}
}
private void customers_dataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
add_button.Enabled = false;
if (edit == true) //updating member
{
save_button.Enabled = true;
}
else if (edit == false) //adding member
{
save_button.Enabled = false;
}
DataGridViewRow row = customers_dataGridView.Rows[e.RowIndex];
customerID = Convert.ToInt32(row.Cells[0].Value.ToString());
customer_name_textBox.Text = row.Cells["CustomernameGV"].Value.ToString();
shops_comboBox_customers.SelectedValue = Convert.ToInt32(row.Cells["ShopIDGV"].Value.ToString());
email_textBox_customers.Text = row.Cells["CustomeremailGV"].Value.ToString();
phone_textBox_customers.Text = row.Cells["CustomerphoneGV"].Value.ToString();
CodingSourceClass.disable(left_panel);
delete_button.Enabled = true;
edit_button.Enabled = true;
save_button.Enabled = false;
cancel_button.Enabled = true;
view_button.Enabled = true;
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel);
enable_crud_buttons();
}
}
public static bool getlogindetails(string proc, Hashtable ht)
{
bool check = false;
try
{
SqlConnection sql_con = new SqlConnection(MainClass.CodingSourceClass.connection());
SqlCommand cmd = new SqlCommand(proc, sql_con);
cmd.CommandType = CommandType.StoredProcedure;
foreach (DictionaryEntry item in ht)
{
cmd.Parameters.AddWithValue(item.Key.ToString(), item.Value);
}
sql_con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
check = true;
while (dr.Read())
{
USERID = Convert.ToInt32(dr[0].ToString());
NAME = dr[1].ToString();
ROLEID = Convert.ToInt32(dr[2].ToString());
ROLE = dr[3].ToString();
}
}
else
{
check = false;
CodingSourceClass.ShowMsg("Invalid username or password", "Error");
}
sql_con.Close();
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
}
return(check);
}
public override void delete_button_Click(object sender, EventArgs e)
{
try
{
if (true)
{
Hashtable ht = new Hashtable();
DialogResult dr = MessageBox.Show("Are you sure? ", "Question.....", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
ht.Add("@payid", paymentID);
if (SQL_TASKS.insert_update_delete("st_deletePAYMENTS", ht) > 0)
{
CodingSourceClass.ShowMsg("Record deleted successfully from the system.", "Success");
enable_crud_buttons();
CodingSourceClass.disable_reset(left_panel);
LoadPayments();
}
else
{
CodingSourceClass.ShowMsg("Unable to delete.An error occured.", "Error");
enable_crud_buttons();
CodingSourceClass.disable_reset(left_panel);
}
}
}
else
{
throw new Exception("Select a record to delete.");
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel); enable_crud_buttons();
}
}
public override void delete_button_Click(object sender, EventArgs e)
{
try
{
if (name_textBox.Text != "" && phone_textBox.Text != "" && address_textBox.Text != "" && password_textBox.Text != "" && username_textBox.Text != "" && roles_comboBox.SelectedIndex != -1)
{
Hashtable ht = new Hashtable();
DialogResult dr = MessageBox.Show("Are you sure? ", "Question.....", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
ht.Add("@id", userID);
if (SQL_TASKS.insert_update_delete("st_deleteUSERS", ht) > 0)
{
CodingSourceClass.ShowMsg("Record deleted successfully from the system.", "Success");
enable_crud_buttons();
CodingSourceClass.disable_reset(left_panel);
LoadUsers();
}
else
{
CodingSourceClass.ShowMsg("Unable to delete.An error occured.", "Error");
enable_crud_buttons();
CodingSourceClass.disable_reset(left_panel);
}
}
}
else
{
throw new Exception("Select a record to delete.");
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel); enable_crud_buttons();
}
}
private void SALES_INVOICE_Load(object sender, EventArgs e)
{
try
{
base.edit_button.Enabled = false;
base.edit_button.Text = "CANNOT EDIT";
LoadSalesInvoice();
SQL_TASKS.LoadList("st_getSHOPS", shops_comboBox_sales_invoice, "ID", "Name");
CodingSourceClass.disable_reset(left_panel);
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
}
}
public override void delete_button_Click(object sender, EventArgs e)
{
try
{
if (shops_comboBox_sales_invoice.SelectedIndex == -1 || order_details_textBox.Text == "" || amount_textBox_sales_invoice.Text == "")
{
throw new Exception("Please enter/select a record.");
}
else
{
DialogResult dr = MessageBox.Show("SaleInvoice " + bill_no_textBox_salesinvoice.Text + "is associated with Payments,Sales Return and Vendor/Owner Ledger.\nDeleting this invoice will delete the particular data related to that invoice from Payments,Sales Return and Vendor/Owner Ledger.\nAlso particular data of Customer Leder which is associated with Payments will be deleted.\nWe recommend you to not delete this.\nAre you sure you want to delete?", "!!!WARNING!!!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (DialogResult.Yes == dr)
{
Hashtable ht = new Hashtable();
ht.Add("@salesinvoiceID", salesinvoiceID);
if (SQL_TASKS.insert_update_delete("st_deleteSALESINVOICE", ht) > 0)
{
CodingSourceClass.ShowMsg("Record deleted successfully.", "Success");
CodingSourceClass.disable_reset(left_panel); enable_crud_buttons();
LoadSalesInvoice();
}
else
{
throw new Exception("Unabled to delete record.");
}
}
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel);
enable_crud_buttons();
}
}
private void load_button_ledger_Click(object sender, EventArgs e)
{
try
{
if (shop_comboBox_ledger.SelectedIndex == -1 || customers_comboBox_ledger.SelectedIndex == -1 || (complete_ledger_radioButton.Checked == false && range_radioButton.Checked == false))
{
CodingSourceClass.ShowMsg("Please enter/select a record.", "Error");
}
else if (shop_comboBox_ledger.SelectedIndex != -1 && customers_comboBox_ledger.SelectedIndex != -1)
{
Hashtable ht = new Hashtable();
ht.Add("@custID", Convert.ToInt32(customers_comboBox_ledger.SelectedValue.ToString()));
ht.Add("@shopID", Convert.ToInt32(shop_comboBox_ledger.SelectedValue.ToString()));
string path = Application.StartupPath + "\\Reports\\CustomerLedger.rpt";
if (range_radioButton.Checked == true && complete_ledger_radioButton.Checked == false)
{
ht.Add("@from", FROM_dateTimePicker.Value);
ht.Add("@to", TO_dateTimePicker.Value);
SQL_TASKS.LoadReport("st_getCUSTOMERLEDGERwrtRANGE", crystalReportViewer1, ht, rd, path);
}
else if (range_radioButton.Checked == false && complete_ledger_radioButton.Checked == true)
{
SQL_TASKS.LoadReport("st_getCUSTOMERLEDGER", crystalReportViewer1, ht, rd, path);
}
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
if (rd != null)
{
rd.Close();
}
}
}
public override void edit_button_Click(object sender, EventArgs e)
{
if (shop_name_textBox.Text == "" || vendors_comboBox_shops.SelectedIndex == -1 || shop_branch_address_textBox.Text == "" || managers_comboBox_shops.SelectedIndex == -1)
{
CodingSourceClass.ShowMsg("Please select a record to edit.", "Error");
}
else
{
CodingSourceClass.enable(left_panel);
edit = true; //editing option enabled
add_button.Enabled = false; //can't add
delete_button.Enabled = false; //can't delete
view_button.Enabled = false; //can't view
save_button.Enabled = true; //can save after editing
}
}
public override void delete_button_Click(object sender, EventArgs e)
{
try
{
if (shop_name_textBox.Text != "" || vendors_comboBox_shops.SelectedIndex != -1 || shop_branch_address_textBox.Text != "" || managers_comboBox_shops.SelectedIndex != -1)
{
Hashtable ht = new Hashtable();
DialogResult dr = MessageBox.Show("Are you sure? ", "Question.....", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
ht.Add("@id", shopID);
if (SQL_TASKS.insert_update_delete("st_deleteSHOPS", ht) > 0)
{
CodingSourceClass.ShowMsg("Record deleted successfully from the system.", "Success");
CodingSourceClass.disable_reset(left_panel);
enable_crud_buttons();
LoadShops();
}
}
}
else
{
throw new Exception("Select a record to delete.");
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
CodingSourceClass.disable_reset(left_panel);
enable_crud_buttons();
}
}
private void payments_dataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
add_button.Enabled = false;
if (edit == true) //updating member
{
save_button.Enabled = true;
}
else if (edit == false) //adding member
{
save_button.Enabled = false;
}
DataGridViewRow row = payments_dataGridView.Rows[e.RowIndex];
paymentID = Convert.ToInt32(row.Cells[0].Value.ToString());
customer_comboBox_payments.Text = row.Cells["customernameGV"].Value.ToString();
sales_invoice_comboBox_payments.Text = row.Cells["billnoGV"].Value.ToString();
shop_comboBox_payments.Text = row.Cells["shopGV"].Value.ToString();
customerID = Convert.ToInt32(row.Cells["customerIDGV"].Value);
salesinvoiceID = Convert.ToInt32(row.Cells["salesinvoiceIDGV"].Value);
if (/*sales_invoice_comboBox_payments.SelectedIndex != -1*/ true)
{
Hashtable ht = new Hashtable();
ht.Add("@custID", customerID);
ht.Add("@salesinvoiceID", salesinvoiceID);
double[] arr = SQL_TASKS.SaleInvoiceAmounts("st_getSALESINVOICEAMOUNT", ht);
total_amount_textBox_payments.Text = arr[0].ToString();
amount_paid_textBox_payments.Text = arr[1].ToString();
remaining_amount_textBox_payments.Text = arr[2].ToString();
}
dateTimePicker_payments.Value = Convert.ToDateTime(row.Cells[1].Value);
userID = Convert.ToInt32(row.Cells[3].Value.ToString());
postedby = row.Cells[4].Value.ToString();
amount_to_pay_textBox_payments.Text = row.Cells[10].Value.ToString();
cheque_no_textBox.Text = row.Cells[11].Value.ToString();
bank_and_branch_textBox.Text = row.Cells[12].Value.ToString();
clearing_date_dateTimePicker.Text = row.Cells["clearingdateGV"].Value.ToString();
if (cheque_no_textBox.Text == "" && bank_and_branch_textBox.Text == "")
{
cash_radioButton_sales_invoice.Checked = true;
}
else
{
cheque_radioButton.Checked = true;
}
CodingSourceClass.disable(left_panel);
delete_button.Enabled = true;
edit_button.Enabled = true;
save_button.Enabled = false;
cancel_button.Enabled = true;
view_button.Enabled = true;
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
enable_crud_buttons();
CodingSourceClass.disable_reset(left_panel);
}
}
public override void save_button_Click(object sender, EventArgs e)
{
try
{
if (shop_comboBox_payments.SelectedIndex == -1 || customer_comboBox_payments.SelectedIndex == -1 || sales_invoice_comboBox_payments.SelectedIndex == -1 || total_amount_textBox_payments.Text == "" || amount_paid_textBox_payments.Text == "" || remaining_amount_textBox_payments.Text == "" || amount_to_pay_textBox_payments.Text == "" || (cash_radioButton_sales_invoice.Checked == false && cheque_radioButton.Checked == false))
{
throw new Exception("Please enter/select a record.");
}
else if ((shop_comboBox_payments.SelectedIndex != -1 && customer_comboBox_payments.SelectedIndex != -1 && sales_invoice_comboBox_payments.SelectedIndex != -1 && total_amount_textBox_payments.Text != "" && amount_paid_textBox_payments.Text != "" && remaining_amount_textBox_payments.Text != "" && amount_to_pay_textBox_payments.Text != "" && cheque_radioButton.Checked == true) && (clearing_date_dateTimePicker.Text == "" || bank_and_branch_textBox.Text == "" || cheque_no_textBox.Text == ""))
{
throw new Exception("Please enter/select a record.");
}
else
{
if (Convert.ToDouble(amount_to_pay_textBox_payments.Text) > Convert.ToDouble(total_amount_textBox_payments.Text))
{
throw new Exception("Amount to pay cannot be greater than total amount.");
}
else
{
double debit = 0, credit = 0, bal = 0;
using (TransactionScope sc = new TransactionScope())
{
Hashtable ht = new Hashtable();
if (cash_radioButton_sales_invoice.Checked == true)
{
ht.Add("@salesinvoiceid", Convert.ToInt32(sales_invoice_comboBox_payments.SelectedValue.ToString()));
ht.Add("@amount", Convert.ToInt32(amount_to_pay_textBox_payments.Text));
ht.Add("@date", dateTimePicker_payments.Value);
if (LoginCodeClass.isAdmin)
{
throw new Exception("Admin cannot enter payments.");
}
else
{
ht.Add("@userID", LoginCodeClass.USERID);
}
SQL_TASKS.insert_update_delete("st_insertPAYMENTSwrtCASH", ht);
}
else
{
ht.Add("@salesinvoiceid", Convert.ToInt32(sales_invoice_comboBox_payments.SelectedValue.ToString()));
ht.Add("@amount", Convert.ToInt32(amount_to_pay_textBox_payments.Text));
ht.Add("@date", dateTimePicker_payments.Value);
if (LoginCodeClass.isAdmin)
{
ht.Add("@userID", LoginCodeClass.idOFadmin);
}
else
{
ht.Add("@userID", LoginCodeClass.USERID);
}
ht.Add("@cheque", cheque_no_textBox.Text);
ht.Add("@bank", bank_and_branch_textBox.Text);
ht.Add("@clearing", clearing_date_dateTimePicker.Value);
SQL_TASKS.insert_update_delete("st_insertPAYMENTSwrtCHEQUE", ht);
}
Hashtable loadht = new Hashtable();
loadht.Add("@custID", Convert.ToInt32(customer_comboBox_payments.SelectedValue.ToString()));
loadht.Add("@shopID", Convert.ToInt32(shop_comboBox_payments.SelectedValue.ToString()));
double[] dd = SQL_TASKS.LoadLastBalance("st_getLASTBALANCES", loadht);
bal = dd[0]; //customer balance
debit = 0;
credit = Convert.ToDouble(amount_to_pay_textBox_payments.Text);
bal += debit - credit;
Hashtable ht2 = new Hashtable();
Int64 salesinvoiceID = Convert.ToInt64(sales_invoice_comboBox_payments.SelectedValue.ToString());
DataRowView drvcustomer = customer_comboBox_payments.SelectedItem as DataRowView;
DataRowView drvshop = shop_comboBox_payments.SelectedItem as DataRowView;
DataRowView drvsalesinvoice = sales_invoice_comboBox_payments.SelectedItem as DataRowView;
ht2.Add("@custID", Convert.ToInt32(customer_comboBox_payments.SelectedValue.ToString()));
ht2.Add("@desc", drvcustomer[1].ToString() + " has done the payment of Rs. " + amount_to_pay_textBox_payments.Text + " on bill # " + drvsalesinvoice[1].ToString() + " to " + drvshop[1].ToString());
ht2.Add("@debit", debit);
ht2.Add("@credit", credit);
ht2.Add("@balance", bal);
ht2.Add("@date", dateTimePicker_payments.Value);
ht2.Add("@salesinvoiceid", salesinvoiceID);
SQL_TASKS.insert_update_delete("st_insertCUSTOMERLEDGER", ht2);
bal = dd[1]; //shop balance
debit = Convert.ToDouble(amount_to_pay_textBox_payments.Text);
credit = 0;
bal += debit - credit;
Hashtable ht3 = new Hashtable();
ht3.Add("@shopID", Convert.ToInt32(shop_comboBox_payments.SelectedValue.ToString()));
ht3.Add("@desc", drvshop[1].ToString() + " has received Rs. " + amount_to_pay_textBox_payments.Text + " as paid from customer " + drvcustomer[1].ToString() + " on bill # " + drvsalesinvoice[1].ToString());
ht3.Add("@debit", debit);
ht3.Add("@credit", credit);
ht3.Add("@balance", bal);
ht3.Add("@date", dateTimePicker_payments.Value);
ht3.Add("@salesinvoiceid", salesinvoiceID);
SQL_TASKS.insert_update_delete("insertVENDORLEDGER", ht3);
Hashtable ht4 = new Hashtable();
if (Convert.ToDouble(amount_to_pay_textBox_payments.Text) == Convert.ToDouble(total_amount_textBox_payments.Text))
{
//complete payment
ht4.Add("@status", 2);
}
else if (Convert.ToDouble(amount_to_pay_textBox_payments.Text) < Convert.ToDouble(total_amount_textBox_payments.Text))
{
//partial payment
ht4.Add("@status", 1);
}
/*else //if status == 2
* {
* ht4.Add("@status", 0);
* }*/
ht4.Add("@salesinvoiceid", salesinvoiceID);
CodingSourceClass.ShowMsg("Record added successfully into the system.", "Success");
CodingSourceClass.disable_reset(left_panel);
LoadPayments();
sc.Complete();
}
}
}
}
catch (Exception ex)
{
CodingSourceClass.ShowMsg(ex.Message, "Error");
}
}
