public static void LoadList(string proc, ComboBox cb, string valueMember, string displayMember)
{
try
{
var sql = new SqlConnection(MainClass.connection());
var cmd = new SqlCommand(proc, sql);
cmd.CommandType = CommandType.StoredProcedure;
var da = new SqlDataAdapter(cmd);
var dt = new DataTable();
da.Fill(dt);
cb.DisplayMember = displayMember;
cb.ValueMember = valueMember;
cb.DataSource = dt;
cb.SelectedIndex = -1;
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
//Generic load data:
public static void load_data(string proc, DataGridView dv, ListBox lb)
{
try
{
SqlConnection sql_con = new SqlConnection(MainClass.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)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
public int insertPurchaseinvoicedetails(Int64 purchID, int prodID, int quan, float price)
{
SqlConnection sql_con = new SqlConnection(MainClass.connection());
try
{
SqlCommand cmd = new SqlCommand("st_insertPURCHASEINVOICEDETAILS", sql_con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@purchaseID", purchID);
cmd.Parameters.AddWithValue("@prodID", prodID);
cmd.Parameters.AddWithValue("@quant", quan);
cmd.Parameters.AddWithValue("@total", price);
sql_con.Open();
PIDcount = cmd.ExecuteNonQuery();
sql_con.Close();
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
sql_con.Close();
}
return(PIDcount);
}
public static int insert_update_delete(string proc, Hashtable ht)
{
int res = 0;
try
{
SqlConnection sql_con = new SqlConnection(MainClass.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)
{
MainClass.ShowMsg(ex.Message, "Error");
}
return(res);
}
public override void edit_button_Click(object sender, EventArgs e)
{
if (name_textBox.Text == "" || phone_number_textBox.Text == "" || email_textBox.Text == "" || password_textBox.Text == "")
{
MainClass.ShowMsg("Please enter a record to edit.", "error");
MainClass.disbale_reset(left_panel_sample2);
enable_crude_buttons();
}
else
{
edit = 1;
temp_name = name_textBox.Text;
temp_phone = phone_number_textBox.Text;
temp_password = password_textBox.Text;
temp_mail = email_textBox.Text;
temp_status = status_comboBox.Text;
save_button.Enabled = true;
add_button.Enabled = false;
MainClass.enable(left_panel_sample2);
}
}
private void send_code_button_Click(object sender, EventArgs e)
{
if (email_address_textBox.Text == "" || current_username_textBox_forgot_password.Text == "")
{
MainClass.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.");
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
}
private void usersToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (LoginCodeClass.IsLogged == false)
{
throw new Exception("Login first.");
}
else
{
if (LoginCodeClass.isAdmin == true)
{
users us = new users();
MainClass.ShowWindow(us, MDI.ActiveForm);
}
else
{
MainClass.ShowMsg("You do not have permission to view users.", "Error");
}
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
public override void edit_button_Click(object sender, EventArgs e)
{
if (supplier_comboBox.SelectedIndex == -1 || product_barcode_textBox_purchase_invoice.Text == "" || product_quantity_textBox.Text == "")
{
MainClass.ShowMsg("Please enter/select a record to edit.", "error");
MainClass.disbale_reset(left_panel_sample2);
enable_crude_buttons();
}
else
{
supplier_comboBox.Enabled = false; product_barcode_textBox_purchase_invoice.Enabled = false;
product_name_textBox_purchase_invoice.Enabled = false;
delete_button.Enabled = true;
save_button.Enabled = true;
add_button.Enabled = false; edit = true;
per_unit_price_textBox.Enabled = true; product_quantity_textBox.Enabled = true;
}
}
private void stockToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (LoginCodeClass.IsLogged == false)
{
throw new Exception("Login first.");
}
else
{
if (LoginCodeClass.isAdmin == true)
{
var st = new STOCK();
MainClass.ShowWindow(st, MDI.ActiveForm);
}
else
{
MainClass.ShowMsg("You do not have permission to view Purchase Invoice window.", "Error");
}
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
private void check_out_button_Click(object sender, EventArgs e)
{
try
{
if (sales_dataGridView.Rows.Count > 0)
{
float disc = 0, gross = 0;
foreach (DataGridViewRow row in sales_dataGridView.Rows)
{
disc += Convert.ToSingle(row.Cells["discountGV"].Value);
gross += Convert.ToSingle(row.Cells["TotalAmountGV"].Value);
}
gross_textBox.Text = Math.Round(gross, 0).ToString();
discount_textBox.Text = disc.ToString();
payment_Type_comboBox.Enabled = true; amount_given_textBox.Enabled = true;
}
else
{
gross_textBox.Text = ""; discount_textBox.Text = "";
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
private string[] loadProductswrtBarcode(string proc, Hashtable ht)
{
SqlConnection sql_con = new SqlConnection(MainClass.connection());
string[] productswrt = new string[6];
try
{
SqlCommand command = new SqlCommand(proc, sql_con);
command.CommandType = CommandType.StoredProcedure;
foreach (DictionaryEntry item in ht)
{
command.Parameters.AddWithValue(item.Key.ToString(), item.Value);
}
sql_con.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
productswrt[0] = dr[0].ToString(); //prod ID
productswrt[1] = dr[1].ToString(); //product
productswrt[2] = dr[2].ToString(); //Barcode
productswrt[3] = dr[3].ToString(); //Per Unit Price
productswrt[4] = dr[4].ToString(); //Per Unit Discount
productswrt[5] = dr[5].ToString(); //Total Amount
}
}
else
{
MainClass.ShowMsg("No products available....", "Error");
MainClass.disbale_reset(left_panel_sample2);
sql_con.Close();
}
sql_con.Close();
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
MainClass.disbale_reset(left_panel_sample2);
sql_con.Close();
}
return(productswrt);
}
public static void ShowReportSaleReturn(CrystalReportViewer crv, string proc, string param = null, object val1 = null)
{
try
{
ReportDocument rd;
SqlConnection sql_con = new SqlConnection(MainClass.connection());
SqlCommand cmd = new SqlCommand(proc, sql_con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(param, val1);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dat = new DataTable();
adapter.Fill(dat);
rd = new ReportDocument();
rd.Load(Application.StartupPath + "\\Reports\\SalesReturnReport.rpt");
rd.SetDataSource(dat);
crv.ReportSource = rd;
crv.RefreshReport();
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
public static object getLASTID(string proc)
{
object o = null;
SqlConnection con = new SqlConnection(MainClass.connection());
try
{
SqlCommand cmd = new SqlCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
o = cmd.ExecuteScalar();
con.Close();
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
con.Close();
}
return(o);
}
public static bool getlogindetails(string proc, Hashtable ht, bool admin)
{
bool check = false;
try
{
var sql_con = new SqlConnection(MainClass.connection());
var 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()) //reading data
{
if (admin == true) //fetch admin username & password
{
usernameOFadmin = dr["email"].ToString();
passwordOFadmin = dr["password"].ToString();
}
else
{
USERID = Convert.ToInt32(dr[0].ToString());
NAME = dr[1].ToString();
USERROLE = dr[2].ToString();
}
}
}
else
{
check = false;
MainClass.ShowMsg("Invalid username or password", "Error");
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
check = false;
}
return(check);
}
private void purchaseinvoice_dataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
add_button.Enabled = false;
if (edit == true) //updating member
{
save_button.Enabled = true;
}
else if (edit == false) //adding member
{
save_button.Enabled = false;
}
if (e.ColumnIndex == 8)
{
DataGridViewRow row = purchase_dataGridView.Rows[e.RowIndex];
gross_total -= Convert.ToSingle(row.Cells["totalGV"].Value.ToString());
gross_total_price_label.Text = gross_total.ToString();
purchase_dataGridView.Rows.Remove(row);
save_button.Enabled = true;
view_button.Enabled = false;
}
else
{
DataGridViewRow row = purchase_dataGridView.Rows[e.RowIndex];
supplier_comboBox.Text = row.Cells["suppliernameGV"].Value.ToString();
product_name_textBox_purchase_invoice.Text = row.Cells["productnameGV"].Value.ToString();
product_barcode_textBox_purchase_invoice.Text = row.Cells["productbarcodeGV"].Value.ToString();
per_unit_price_textBox.Text = row.Cells["perunitpriceGV"].Value.ToString();
product_quantity_textBox.Text = row.Cells["productquantityGV"].Value.ToString();
MainClass.disbale(left_panel_sample2);
delete_button.Enabled = true;
}
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons();
}
}
private void login_button_Click(object sender, EventArgs e)
{
try
{
if (username_textBox.Text != "" && password_textBox.Text != "")
{
Hashtable ht = new Hashtable();
ht.Add("@email", username_textBox.Text);
ht.Add("@password", password_textBox.Text);
if (other_radioButton.Checked == true)
{
if (LoginCodeClass.getlogindetails("st_getAuthenticationDetails", ht, false))
{
LoginCodeClass.isAdmin = false; //not admin, common user
LoginCodeClass.IsLogged = true;
var sal = new SALES();
MainClass.ShowWindow(sal, MDI.ActiveForm);
}
}
else if (admin_radioButton.Checked == true)
{
if (LoginCodeClass.getlogindetails("st_getAuthenticationDetailsFromAUTH", ht, true))
{
LoginCodeClass.isAdmin = true; //Admin,not common user
LoginCodeClass.IsLogged = true;
var cat = new CATEGORIES();
MainClass.ShowWindow(cat, MDI.ActiveForm);
}
}
else
{
MainClass.ShowMsg("Please select if you are admin or any other person.", "Error");
LoginCodeClass.IsLogged = false;
}
}
else
{
MainClass.ShowMsg("Please fill all fields.", "Error"); LoginCodeClass.IsLogged = false;
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
LoginCodeClass.IsLogged = false;
}
}
private void load_button_Click(object sender, EventArgs e)
{
try
{
if (sale_ID_textBox.Text != "")
{
if (rg.Match(sale_ID_textBox.Text).Success)
{
LoadSales();
dateTimePicker_sales_return.Value = Convert.ToDateTime(sales_return_dataGridView.Rows[0].Cells["DateGV"].Value);
user_textBox.Text = sales_return_dataGridView.Rows[0].Cells["UserIDGV"].Value.ToString();
paymentType_textBox.Text = sales_return_dataGridView.Rows[0].Cells["PaymentGV"].Value.ToString();
total_amount_label.Text = "Total Amount: " + sales_return_dataGridView.Rows[0].Cells["TotalAmountGV"].Value.ToString();
total_discount_label.Text = "Total Discount: " + sales_return_dataGridView.Rows[0].Cells["TotalDiscountGV"].Value.ToString();
}
else
{
sale_ID_textBox.Text = "";
sale_ID_textBox.Focus();
dateTimePicker_sales_return.Value = DateTime.Now;
user_textBox.Text = "";
paymentType_textBox.Text = "";
total_amount_label.Text = "Total Amount: 0";
total_discount_label.Text = "Total Discount: 0";
}
}
else
{
MainClass.ShowMsg("Enter sale ID first.", "Error");
dateTimePicker_sales_return.Value = DateTime.Now;
user_textBox.Text = "";
paymentType_textBox.Text = "";
total_amount_label.Text = "Total Amount: 0";
total_discount_label.Text = "Total Discount: 0";
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
private void save_new_details_button_Click(object sender, EventArgs e)
{
if (new_username_textBox.Text == "" || new_password_textBox.Text == "")
{
MainClass.ShowMsg("Please enter all details.", "error");
}
else
{
try
{
sq.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = sq;
cmd.CommandText = "st_deleteusers";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", LoginCodeClass.USERID);
cmd.ExecuteNonQuery();
cmd.Dispose();
SqlCommand newcom = new SqlCommand();
string query = "insert into users values(@username,@password)";
newcom.Parameters.AddWithValue("@username", new_username_textBox.Text);
newcom.Parameters.AddWithValue("@password", new_password_textBox.Text);
newcom.CommandText = query;
newcom.ExecuteNonQuery();
MainClass.ShowMsg("Username and password changed successfully.", "success");
sq.Close();
disable_clear();
newcom.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "success", MessageBoxButtons.OK, MessageBoxIcon.Error);;
sq.Close();
disable_clear();
}
}
}
private void products_dataGridView_CellClick_1(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
add_button.Enabled = false;
if (edit == 1) //updating member
{
save_button.Enabled = true;
}
else if (edit == 0) //adding member
{
save_button.Enabled = false;
}
DataGridViewRow row = products_dataGridView.Rows[e.RowIndex];
productID = Convert.ToInt32(row.Cells["productidGV"].Value.ToString());
product_name_textBox.Text = row.Cells["ProductnameGV"].Value.ToString();
barcode_textBox.Text = row.Cells["ProductbarcodeGV"].Value.ToString();
if (row.Cells["ExpirydateGV"].FormattedValue.ToString() == "")
{
dateTimePicker_expiry_products.Value = DateTime.Now;
}
else
{
dateTimePicker_expiry_products.Value = Convert.ToDateTime(row.Cells["ExpirydateGV"].Value.ToString());
}
categories_comboBox.SelectedValue = row.Cells["categoryIDGV"].Value.ToString();
disable();
delete_button.Enabled = true;
edit_button.Enabled = true;
save_button.Enabled = false;
cancel_button.Enabled = true;
view_button.Enabled = true;
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
private void verify_code_button_Click(object sender, EventArgs e)
{
if (x.ToString() == verification_code_textBox.Text)
{
disabled_new_details_label.Text = "ENABLED";
new_details_panel.Enabled = true;
}
else
{
MainClass.ShowMsg("Incorrect code.", "Error");
}
}
private void users_dataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
add_button.Enabled = false;
if (edit == 1) //updating member
{
save_button.Enabled = true;
}
else if (edit == 0) //adding member
{
save_button.Enabled = false;
}
DataGridViewRow row = users_dataGridView.Rows[e.RowIndex];
USERID = Convert.ToInt32(row.Cells["useridGV"].Value.ToString());
name_textBox.Text = row.Cells["nameGV"].Value.ToString();
email_textBox.Text = row.Cells["emailGV"].Value.ToString();
password_textBox.Text = row.Cells["passwordGV"].Value.ToString();
phone_number_textBox.Text = row.Cells["phonenumberGV"].Value.ToString();
status_comboBox.SelectedItem = row.Cells["statusGV"].Value.ToString();
role_textBox.Text = row.Cells["roleGV"].Value.ToString();
MainClass.disbale(left_panel_sample2);
delete_button.Enabled = true;
edit_button.Enabled = true;
save_button.Enabled = false;
cancel_button.Enabled = true;
view_button.Enabled = true;
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
private void product_quantity_textBox_TextChanged(object sender, EventArgs e)
{
try
{
if (product_quantity_textBox.Text != "")
{
if (rg.Match(product_quantity_textBox.Text).Success)
{
float quan = 0, price = 0, total = 0;
if (product_quantity_textBox.Text == "" || per_unit_price_textBox.Text == "")
{
throw new Exception("No fields can be empty.Please enter details in an order");
}
else
{
quan = Convert.ToSingle(product_quantity_textBox.Text);
price = Convert.ToSingle(per_unit_price_textBox.Text);
total = quan * price;
total_amount_label.Text = total.ToString("############.##");
}
}
else
{
product_quantity_textBox.SelectAll();
}
}
else
{
total_amount_label.Text = "0.00";
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
product_barcode_textBox_purchase_invoice.Text = "";
product_name_textBox_purchase_invoice.Text = "";
per_unit_price_textBox.Text = ""; product_quantity_textBox.Text = "";
}
}
public override void delete_button_Click(object sender, EventArgs e)
{
if (supplier_comboBox.SelectedIndex == -1 || product_barcode_textBox_purchase_invoice.Text == "" || product_quantity_textBox.Text == "")
{
MainClass.ShowMsg("Please enter/select a record to delete.", "error");
MainClass.disbale_reset(left_panel_sample2);
enable_crude_buttons();
}
else
{
try
{
DialogResult ans = MessageBox.Show("Are you sure you want to delete current record.", "CONFIRM?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (ans == DialogResult.Yes)
{
purchase_dataGridView.Rows.Remove(purchase_dataGridView.CurrentRow);
MainClass.disbale_reset(left_panel_sample2);
gross_total = 0;
foreach (DataGridViewRow row in purchase_dataGridView.Rows)
{
gross_total += Convert.ToSingle(row.Cells["totalGV"].Value);
gross_total_price_label.Text = gross_total.ToString();
}
MainClass.disbale_reset(left_panel_sample2);
enable_crude_buttons();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
MainClass.disbale_reset(left_panel_sample2);
enable_crude_buttons();
}
}
}
public Int64 InsertPurchaseinvoice(DateTime date, int doneBy, int suppID)
{
SqlConnection sql_con = new SqlConnection(MainClass.connection());
try
{
using (TransactionScope sc = new TransactionScope())
{
var cmd = new SqlCommand("st_insertPURCHASEINVOICE", sql_con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@date", date);
cmd.Parameters.AddWithValue("@doneby", doneBy);
cmd.Parameters.AddWithValue("@suppID", suppID);
sql_con.Open();
cmd.ExecuteNonQuery();
sql_con.Close();
SqlCommand cmd1 = new SqlCommand("st_getLASTPURCHASEINVOICEID", sql_con);
cmd1.CommandType = CommandType.StoredProcedure;
sql_con.Open();
purchaseinvoiceIDSQLTASKS = Convert.ToInt64(cmd1.ExecuteScalar());
sql_con.Close();
sc.Complete();
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
sql_con.Close();
}
return(purchaseinvoiceIDSQLTASKS);
}
private void product_barcode_textBox_purchase_invoice_Validating(object sender, CancelEventArgs e)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@barcode", product_barcode_textBox_purchase_invoice.Text);
string[] productswrt = new string[3];
if (product_barcode_textBox_purchase_invoice.Text != "")
{
productswrt = loadProductswrtBarcode("st_getPRODUCTbyBarcodeForPurchaseInvoice", ht);
productID = Convert.ToInt32(productswrt[0]);
productNAME = productswrt[1];
product_name_textBox_purchase_invoice.Text = productNAME;
productBARCODE = productswrt[2];
product_name_textBox_purchase_invoice.Enabled = false;
if (productBARCODE != null)
{
per_unit_price_textBox.Focus();
}
}
else
{
productID = 0;
product_name_textBox_purchase_invoice.Text = "";
per_unit_price_textBox.Text = "";
Array.Clear(productswrt, 0, productswrt.Length);
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
private void amount_given_textBox_TextChanged(object sender, EventArgs e)
{
try
{
if (amount_given_textBox.Text != "")
{
if (!rg.Match(amount_given_textBox.Text).Success)
{
amount_given_textBox.Text = ""; amount_given_textBox.Focus();
}
}
else
{
change_to_give_textBox.Text = "";
}
}
catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); }
}
private void product_pricing_dataGridView_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
DataGridViewRow row = product_pricing_dataGridView.Rows[e.RowIndex];
if (row.Cells["profitmarginGV"].Value != null && rg.Match(row.Cells["profitmarginGV"].Value.ToString()).Success)
{
float perunitPrice = (Convert.ToSingle(row.Cells["PerUnitPriceGV"].Value.ToString()));
float profitmargin = (Convert.ToSingle(row.Cells["profitmarginGV"].Value.ToString()) / 100);
float amountTOincrease = profitmargin * perunitPrice;
float finalsellingprice = perunitPrice + amountTOincrease;
float discount;
if (row.Cells["discountGV"].Value != null && rg.Match(row.Cells["discountGV"].Value.ToString()).Success)
{
discount = finalsellingprice * (Convert.ToSingle(row.Cells["discountGV"].Value.ToString()) / 100);
}
else
{
discount = 0;
}
row.Cells["finalpriceGV"].Value = finalsellingprice - discount;
}
else
{
row.Cells["finalpriceGV"].Value = null;
row.Cells["profitmarginGV"].Value = null;
row.Cells["discountGV"].Value = null;
}
}
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
public static void LoadListModifiedHashTable(string proc, ComboBox cb, string valueMember, string displayMember, Hashtable ht)
{
try
{
cb.DataSource = null;
cb.Items.Clear();
SqlConnection sql = new SqlConnection(MainClass.connection());
SqlCommand cmd = new SqlCommand(proc, sql);
cmd.CommandType = CommandType.StoredProcedure;
foreach (DictionaryEntry item in ht)
{
cmd.Parameters.AddWithValue(item.Key.ToString(), item.Value);
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow dr = dt.NewRow();
dr.ItemArray = new object[] { 0, "Select..." };
dt.Rows.InsertAt(dr, 0);
cb.DisplayMember = displayMember;
cb.ValueMember = valueMember;
cb.DataSource = dt;
cb.SelectedIndex = -1;
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
public static double[] SaleInvoiceAmounts(string proc, Hashtable ht)
{
double[] arr = new double[3];
try
{
SqlConnection sql_con = new SqlConnection(MainClass.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)
{
while (dr.Read())
{
arr[0] = Convert.ToDouble(dr["Total Amount"].ToString());
arr[1] = Convert.ToDouble(dr["Amount Paid"].ToString());
arr[2] = Convert.ToDouble(dr["Remaining Amount"].ToString());
}
}
sql_con.Close();
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
return(arr);
}
public static double[] LoadLastBalance(string proc, Hashtable ht)
{
SqlConnection sql_con = new SqlConnection(MainClass.connection());
double[] amounts = new double[2];
try
{
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)
{
while (dr.Read())
{
amounts[0] = Convert.ToDouble(dr[0].ToString());
amounts[1] = Convert.ToDouble(dr[1].ToString());
}
}
sql_con.Close();
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
sql_con.Close();
}
return(amounts);
}
