public void addTransactionDetails( int Cust_ID, DateTime TransactionDate, double billAmount ) { try { SqlConnection conn = DBClass.getsqlcon(); conn.Open(); SqlCommand cmd = new SqlCommand("strpdAddUpdateTransactionDetails", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Cust_ID", Cust_ID); cmd.Parameters.AddWithValue("@billAmount", billAmount); cmd.Parameters.AddWithValue("@TransactionDate", TransactionDate.ToShortDateString()); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void addTransactionProductDetails( double Quantity, double Amount, string poductName ) { try { SqlConnection conn = DBClass.getsqlcon(); conn.Open(); SqlCommand cmd = new SqlCommand("strpdAddUpdateTransactionProductDetails", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Quantity", Quantity); cmd.Parameters.AddWithValue("@Amount", Amount); cmd.Parameters.AddWithValue("@poductName", poductName); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void addUpdateUnitMeasure( string unitMeasure, int IDToUpdate, int flag ) { try { SqlConnection conn = DBClass.getsqlcon(); conn.Open(); SqlCommand cmd = new SqlCommand("strpdAddUpdateUnitMeasure", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@unitMeasure", unitMeasure); cmd.Parameters.AddWithValue("@IDToUpdate", IDToUpdate); cmd.Parameters.AddWithValue("@flag", flag); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void addUpdateCategories(string categoryName, string categoryDesc, int IDToUpdate, int flag) { try { int id = 0; SqlConnection conn = DBClass.getsqlcon(); conn.Open(); SqlCommand cmd = new SqlCommand("strpdAddUpdateCategories", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@categoryName", categoryName); cmd.Parameters.AddWithValue("@categoryDesc", categoryDesc); cmd.Parameters.AddWithValue("@IDToUpdate", IDToUpdate); cmd.Parameters.AddWithValue("@flag", flag); id = Convert.ToInt32(cmd.ExecuteScalar()); switch (id) { case -1: System.Windows.Forms.MessageBox.Show("Category exists for ' " + categoryName + " ' .."); break; case 2: System.Windows.Forms.MessageBox.Show("Category Deatils Updated for ' " + categoryName + " ' .."); break; default: { System.Windows.Forms.MessageBox.Show("Category Added"); break; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }