private void button3_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); try { int curQuantity = Int32.Parse(textBox2.Text); int retQuantity = Int32.Parse(textBox3.Text); if (retQuantity <= curQuantity) { int newQuantity = curQuantity - retQuantity; int drugID = 0; string saveDrugName = ""; int buyCost = 0; int sellPrice = 0; var q = from n in db.SalesTables where n.Id == Int32.Parse(textBox1.Text) select n; foreach (var nn in q) { drugID = (int)nn.DrugID; saveDrugName = nn.DrugName; buyCost = (int)nn.DrugTable.BuyingCostPerUnit; sellPrice = (int)nn.DrugTable.SellingPricePerUnit; break; } // update salestable -> quantity sold is dec and new profit/loss SalesTable qq = (from n in db.SalesTables where n.Id == Int32.Parse(textBox1.Text) select n).Single(); qq.QuantitySold = newQuantity; qq.Profit_Loss = newQuantity * sellPrice - newQuantity * buyCost; db.SubmitChanges(); // update drugtable -> item sold decrease! DrugTable qq2 = (from n in db.DrugTables where n.Id == drugID select n).Single(); qq2.QuantitySold -= retQuantity; db.SubmitChanges(); string msg = ""; msg += "ITEM UPDATED: \n"; msg += "Sells ID: " + textBox1.Text + "\n"; msg += "Drug Name: " + saveDrugName + "\n"; msg += "Return Quantity: " + retQuantity.ToString() + "\n"; MessageBox.Show(msg); } else { MessageBox.Show("Return Amount is bigger than Sold Amount"); } } catch { MessageBox.Show("invalid input"); } }
private void cancel() { DataClasses1DataContext db = new DataClasses1DataContext(); OrderTable dt = new OrderTable(); try { var q = from OrderTable in db.OrderTables where OrderTable.Id == Int32.Parse(domainUpDown1.Text) select OrderTable; db.OrderTables.DeleteAllOnSubmit(q); db.SubmitChanges(); MessageBox.Show("Succesfully cancelled!\n"); DrugTable q2 = (from DrugTable in db.DrugTables where DrugTable.Id == Int32.Parse(domainUpDown2.Text) select DrugTable).Single(); q2.Status = "valid"; db.SubmitChanges(); clearFields(); loadDomainBoxOrderID(); } catch { MessageBox.Show("invalid input\n"); } }
// add to recipt private void button1_Click(object sender, EventArgs e) { try { if (textBox2.Text != "" && textBox4.Text != "") { int dID = Int32.Parse(textBox2.Text); int quantity = Int32.Parse(textBox4.Text); DataClasses1DataContext db = new DataClasses1DataContext(); DrugTable dt = new DrugTable(); var q = from DrugTable in db.DrugTables where DrugTable.Id == dID select DrugTable; foreach (var DrugTable in q) { if (quantity <= DrugTable.QuantityBought - DrugTable.QuantitySold && (DateTime)DrugTable.ExpiredDate > System.DateTime.Today && arrSoldQuantityChk[DrugTable.Id] + quantity <= DrugTable.QuantityBought - DrugTable.QuantitySold) { this.dataGridView1.Rows.Add(rowCount + 1, DrugTable.Name, quantity, DrugTable.SellingPricePerUnit, DrugTable.ExpiredDate, DrugTable.BatchNo); arrSoldID[rowCount + 1] = DrugTable.Id; arrSoldQuantity[rowCount + 1] = quantity; arrSoldQuantityChk[DrugTable.Id] += quantity; rowCount++; totalCost += quantity * (int)DrugTable.SellingPricePerUnit; label6.Text = "Total Cost = " + totalCost.ToString(); } else if (quantity > DrugTable.QuantityBought - DrugTable.QuantitySold || arrSoldQuantityChk[DrugTable.Id] + quantity > DrugTable.QuantityBought - DrugTable.QuantitySold) { MessageBox.Show("Not Enough Quantity Remaining!"); } else if ((DateTime)DrugTable.ExpiredDate <= System.DateTime.Today) { MessageBox.Show("Date Expired!!!"); } break; } } } catch { MessageBox.Show("Invalid Input!"); } }
private void discardDrug() { try { DataClasses1DataContext db = new DataClasses1DataContext(); DrugTable q3 = (from DrugTable in db.DrugTables where DrugTable.Id == Int32.Parse(domainUpDown1.Text) select DrugTable).Single(); q3.Status = "invalid"; db.SubmitChanges(); MessageBox.Show("Succesfully Discarded!"); clearFields(); } catch { MessageBox.Show("invalid input!"); } }
private void button1_Click(object sender, EventArgs e) { string s = textBox1.Text; string sCol = comboBox1.Text; DataClasses1DataContext db = new DataClasses1DataContext(); DrugTable dt = new DrugTable(); try { if (sCol.ToLower() == "name") { var q = from DrugTable in db.DrugTables where DrugTable.Name == s select DrugTable; dataGridView1.DataSource = q; } else if (sCol.ToLower() == "batchno") { var q = from DrugTable in db.DrugTables where DrugTable.BatchNo == Int32.Parse(s) select DrugTable; dataGridView1.DataSource = q; } else { MessageBox.Show("Not Found!\n"); } } catch { MessageBox.Show("Error! Input is invalid!\n"); } }
private void updateDrug() { DataClasses1DataContext db = new DataClasses1DataContext(); DrugTable dt = new DrugTable(); try { int cataID = 0; bool validCata = false; if (comboBox1.Text != "") { var q = from CatagoryTable in db.CatagoryTables where CatagoryTable.Name == comboBox1.Text select CatagoryTable; foreach (var Ct in q) { cataID = Ct.Id; validCata = true; break; } } var q2 = from DrugTable in db.DrugTables where DrugTable.Name == textBox1.Text select DrugTable; bool alreadyExist = false; foreach (var DrugTable in q2) { alreadyExist = true; break; } if (alreadyExist) { MessageBox.Show("Drug Already Exists \nTo make a new order please go to order page"); } else if (validCata && !alreadyExist) { DrugTable q3 = (from DrugTable in db.DrugTables where DrugTable.Id == Int32.Parse(domainUpDown1.Text) select DrugTable).Single(); q3.Name = textBox1.Text; q3.CatagoryId = cataID; q3.Status = comboBox2.Text; q3.ExpiredDate = DateTime.Parse(dateTimePicker1.Text); q3.SellingPricePerUnit = Int32.Parse(textBox2.Text); q3.BuyingCostPerUnit = Int32.Parse(textBox3.Text); db.SubmitChanges(); MessageBox.Show("Succesfully updated! \nPlease Check in Orderpage to make a new order"); clearFields(); } else { MessageBox.Show("invalid input!"); } } catch { MessageBox.Show("invalid input!"); } }
private void addNewDrug() { DataClasses1DataContext db = new DataClasses1DataContext(); DrugTable dt = new DrugTable(); try { int cataID = 0; bool validCata = false; if (comboBox1.Text != "") { var q = from CatagoryTable in db.CatagoryTables where CatagoryTable.Name == comboBox1.Text select CatagoryTable; foreach (var Ct in q) { cataID = Ct.Id; validCata = true; break; } } var q2 = from DrugTable in db.DrugTables where DrugTable.Name == textBox1.Text select DrugTable; bool alreadyExist = false; foreach (var DrugTable in q2) { alreadyExist = true; } if (alreadyExist) { MessageBox.Show("Drug Already Exists \nTo make a new order please go to order page"); } else if (validCata && !alreadyExist) { dt.Name = textBox1.Text; dt.CatagoryId = cataID; dt.BatchNo = 0; dt.ExpiredDate = DateTime.Now; dt.QuantityBought = 0; dt.QuantitySold = 0; dt.SellingPricePerUnit = 0; dt.BuyingCostPerUnit = 0; dt.Status = "valid"; db.DrugTables.InsertOnSubmit(dt); db.SubmitChanges(); MessageBox.Show("Succesfully added! \nPlease Check in Orderpage to make a new order"); clearFields(); } else { MessageBox.Show("invalid input!"); } } catch { MessageBox.Show("invalid input!"); } }
// sell button aka update drugtable and add to salesTable private void button8_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); try { bool sold = false; int prvSaleID = 0; for (int i = 0; i < 1000; i++) { if (arrSoldID[i] != -1) { if (!sold) { var q22 = from n in db.SalesTables select n; foreach (var nn in q22) { prvSaleID = nn.Id; } } sold = true; // updating drugtable DrugTable q = (from DrugTable in db.DrugTables where DrugTable.Id == arrSoldID[i] select DrugTable).Single(); q.QuantitySold += arrSoldQuantity[i]; db.SubmitChanges(); // adding to sales table var q2 = from DrugTable in db.DrugTables where DrugTable.Id == arrSoldID[i] select DrugTable; foreach (var DrugTable in q2) { SalesTable st = new SalesTable(); st.DrugID = DrugTable.Id; st.DrugName = DrugTable.Name; st.CatagoryID = DrugTable.CatagoryId; st.QuantitySold = arrSoldQuantity[i]; st.Date = System.DateTime.Now; st.Profit_Loss = (DrugTable.SellingPricePerUnit - DrugTable.BuyingCostPerUnit) * arrSoldQuantity[i]; st.StaffID = userID; db.SalesTables.InsertOnSubmit(st); db.SubmitChanges(); break; } } } if (sold) { var q22 = from n in db.SalesTables where n.Id > prvSaleID select n; string s = ""; foreach (var nn in q22) { if (nn.Id == prvSaleID + 1) { s += "SOLD ITEMS: \n"; } s += "Sell ID: " + (nn.Id).ToString() + "\n"; s += "DrugName: " + nn.DrugName + "\n"; s += "Quantity: " + nn.QuantitySold + "\n"; s += "\n\n"; } s += label6.Text; MessageBox.Show(s); refreshDataGrid2(); } } catch { MessageBox.Show("Invalid Input!"); } }
// change button! private void button1_Click(object sender, EventArgs e) { try { if (textBox1.Text != "") { int oID = Int32.Parse(textBox1.Text); DataClasses1DataContext db = new DataClasses1DataContext(); OrderTable q = (from OrderTable in db.OrderTables where OrderTable.Id == oID select OrderTable).Single(); if (radioButton1.Checked && q.OrderStatus == "Pending") { q.OrderStatus = "Ordered"; q.OrderDate = DateTime.Now; q.QuantityToAdd = Int32.Parse(textBox4.Text); db.SubmitChanges(); MessageBox.Show("Successfully Ordered"); loadDataGridView1(); } else if (radioButton2.Checked && q.OrderStatus == "Ordered") { if (DateTime.Parse(dateTimePicker1.Text) <= DateTime.Now) { MessageBox.Show("Check Expired Date!"); } else if (textBox2.Text == "" && textBox3.Text == "") { MessageBox.Show("SPPU and BCPU is empty!"); } else { q.OrderStatus = "Received"; q.OrderReceiveDate = DateTime.Now; db.SubmitChanges(); var q2 = from DrugTable in db.DrugTables where DrugTable.Name == drugName select DrugTable; int maxBatchNo = 0; int cid = 0; foreach (var DrugTable in q2) { cid = (int)DrugTable.CatagoryId; if (maxBatchNo < (int)DrugTable.BatchNo) { maxBatchNo = (int)DrugTable.BatchNo; } } DrugTable dt = new DrugTable(); dt.Name = drugName; dt.CatagoryId = cid; dt.BatchNo = maxBatchNo + 1; dt.QuantityBought = Int32.Parse(textBox4.Text); dt.QuantitySold = 0; dt.SellingPricePerUnit = Int32.Parse(textBox2.Text); dt.BuyingCostPerUnit = Int32.Parse(textBox3.Text); dt.ExpiredDate = DateTime.Parse(dateTimePicker1.Text); db.DrugTables.InsertOnSubmit(dt); db.SubmitChanges(); MessageBox.Show("Successfully Received\n" + q.DrugName + "\nNew Batch No :" + (maxBatchNo + 1).ToString() + "\n" + "New Quantities : " + textBox4.Text); loadDataGridView1(); } } } } catch { MessageBox.Show("Invalid Input"); } }
private void button1_Click(object sender, EventArgs e) { try { //MessageBox.Show(dataGridView1.Rows[1].Cells[2].Value.ToString()); if (textBox1.Text != "" && textBox3.Text != "" && textBox2.Text != "") { //int index = dataGridView1.CurrentCell.RowIndex; //int index2 = dataGridView2.CurrentCell.RowIndex; //textBox1.Text = dataGridView1.Rows[index].Cells[0].Value.ToString(); ////textBox2.Text = dataGridView1.Rows[index].Cells[7].Value.ToString(); //textBox3.Text = dataGridView1.Rows[index2].Cells[0].Value.ToString(); DataClasses1DataContext db = new DataClasses1DataContext(); OrderTable dt = new OrderTable(); dt.DrugID = Int32.Parse(textBox1.Text); dt.QuantityToAdd = Int32.Parse(textBox2.Text); if (dt.QuantityToAdd <= 0) { MessageBox.Show("Check Quantity to add again!"); dt.QuantityToAdd = 0; } else { dt.AdminID = userID; //dt.OrderDate = DateTime.Now; dt.VendorID = Int32.Parse(textBox3.Text); dt.OrderStatus = "Pending"; var q = from DrugTable in db.DrugTables where DrugTable.Id == Int32.Parse(textBox1.Text) select DrugTable; foreach (var DrugTable in q) { dt.DrugName = DrugTable.Name; break; } db.OrderTables.InsertOnSubmit(dt); db.SubmitChanges(); DrugTable q2 = (from DrugTable in db.DrugTables where DrugTable.Id == Int32.Parse(textBox1.Text) select DrugTable).Single(); q2.Status = "invalid"; db.SubmitChanges(); MessageBox.Show("Successfully Added to Order List \nPlease Check the status in Order List"); } } else { MessageBox.Show("Empty text box!"); } } catch { MessageBox.Show("Invalid Input"); } }