public void InsertBook() { Function iFt = new Function(); string sql = "INSERT book SET book_id = '" + book_id + "' ,book_type = '" + book_type + "', book_name = '" + book_name + "', author = '" + author + "',book_price = '" + book_price + "', publisher = '" + publisher + "', amount = '" + amount + "'"; iFt.Update(sql); }
public void AddSelline() { Function iFt = new Function(); string sql = "INSERT INTO sellline SET sale_id = '" + sale_id + "', book_id = '" + book_id + "', amount = '" + amount + "'"; iFt.Update(sql); UpdateStock(); }
public void Insert(string purchase_id) { Function iFt = new Function(); string sql = string.Format("INSERT INTO purchaseline " + "VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')" , purchase_id, book_id, amount, 0, price * amount); iFt.Update(sql); }
public void Insert() { // Insert this item and item.line into database Function iFt = new Function(); string sql = ""; sql = string.Format("INSERT INTO purchaseorder " + "VALUES ('{0}', '{1}', NOW()) " , purchase_id, employee_id); iFt.Update(sql); purchase_item.ForEach(item => item.Insert(purchase_id)); }
public void UpdateStock() { Function iFt = new Function(); string sql1 = "SELECT amount FROM book WHERE book_id = '" + book_id + "'"; DataTable Dtable = iFt.Select(sql1); string temp = ""; foreach (DataRow row in Dtable.Rows) { temp = row[0].ToString(); } string sql = "UPDATE book SET amount = '" + (Int32.Parse(temp) - amount).ToString() + "' WHERE book_id = '" + book_id + "'"; iFt.Update(sql); }
public void AddSell(DataGridViewRowCollection data_rows) { Function iFt = new Function(); string sql = "INSERT INTO sell SET sale_id = '" + sale_id + "', employee_id = '" + employee_id + "', sale_date = '" + date + "'"; //string sql = String.Format("INSERT INTO sell SET sale_id = '{0}', employee_id = '{1}', sale_date = '{2}'", sale_id, employee_id, date); iFt.Update(sql); foreach (DataGridViewRow dr in data_rows) { sale_item = new Sellline(); sale_item.sale_id = sale_id; sale_item.book_id = dr.Cells["ID"].Value.ToString(); sale_item.amount = Int32.Parse(dr.Cells["qty"].Value.ToString()); sale_item.AddSelline(); } }