private void dataGridView2_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView2.Columns[e.ColumnIndex].Name == "Delete") { DialogResult myResult; myResult = MessageBox.Show("Are you really delete the item?", "Delete Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (myResult == DialogResult.OK) { _entities = new KBBQEntities(); var cellId = Convert.ToInt32(dataGridView2.CurrentRow.Cells[0].Value); updateClass = new clsUpdate(); updateClass.updateBillAndSettlement(cellId.ToString(), "CANCELLED", "", 0); _entities = new KBBQEntities(); var data = _entities.DailySales.Where(x => x.KOT == cellId.ToString()).ToList(); foreach (var item in data) { _entities.DailySales.Remove(item); _entities.SaveChanges(); } bindGridViewForPageLoad(); } } }
void addPurchaseDetailsData() { foreach (DataGridViewRow dr in dgPurchaseItem.Rows) { if (Convert.ToString(dr.Cells[0].Value) != string.Empty) { _entities = new KBBQEntities(); tbl_PurchaseDetails purchaseDetails = new tbl_PurchaseDetails(); purchaseDetails.purchaseID = _entities.tbl_PurchaseMaster.Where(x => x.refNo == txtRefNo.Text).FirstOrDefault().pId; var gridItemCode = dr.Cells[1].Value.ToString(); purchaseDetails.productID = _entities.purchaseProducts.Where(x => x.pName == gridItemCode).FirstOrDefault().id; purchaseDetails.qty = Convert.ToDecimal(dr.Cells[2].Value.ToString()); purchaseDetails.weight = Convert.ToDecimal(dr.Cells[3].Value.ToString()); purchaseDetails.unit = dr.Cells[4].Value.ToString(); purchaseDetails.rate = Convert.ToDecimal(dr.Cells[5].Value.ToString()); purchaseDetails.createdDate = DateTime.Now; _entities.tbl_PurchaseDetails.Add(purchaseDetails); _entities.SaveChanges(); //Update Qty in stock var itemQty = _entities.purchaseProducts.Where(x => x.id == purchaseDetails.productID).FirstOrDefault(); if (itemQty != null) { itemQty.qty = itemQty.qty + purchaseDetails.qty; itemQty.udate = DateTime.Now; } else { itemQty.qty = purchaseDetails.qty; itemQty.udate = DateTime.Now; } _entities.SaveChanges(); } } }
//REMOVE DULPICATE public void _CheckProductExist() { try { if (btnSave.Text == "Save") { SqlConnection con = new SqlConnection(insertClass.dbPath); string sql = "select proSubCate from tblProType where proSubCate = @proSubCate"; SqlCommand cmd = new SqlCommand(sql, con); con.Open(); DataSet ds = new DataSet(); SqlDataAdapter adapt = new SqlDataAdapter(cmd); cmd.Parameters.AddWithValue("@proSubCate", txtCategory.Text.Trim()); adapt.Fill(ds); con.Close(); int count = ds.Tables[0].Rows.Count; //If count is equal to 1 //meaning user already exist if (count == 1) { MessageBox.Show("Menu Subgroup Already Exist", "Help - King Bar Beque", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } else { //PERFORM INSERT insertClass.insertToProType(cboProductTypeName, txtCategory.Text); _setInitialState(); } } else { _entities = new KBBQEntities(); var data = _entities.tblProTypes.Where(x => x.proTypeID == passedId).FirstOrDefault(); if (data != null) { data.prodTypeName = cboProductTypeName.Text.ToString(); data.proSubCate = txtCategory.Text.Trim(); _entities.SaveChanges(); } } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message, "Throwing Exception - Fronty", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void dgPurchaseDetails_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dgPurchaseDetails.Columns[e.ColumnIndex].Name == "Delete") { DialogResult myResult; myResult = MessageBox.Show("Are you really delete the item?", "Delete Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (myResult == DialogResult.OK) { _entities = new KBBQEntities(); var cellId = Convert.ToInt32(dgPurchaseDetails.CurrentRow.Cells[0].Value); var selectedData1 = _entities.tbl_PurchaseDetails.Where(x => x.purchaseID == cellId).FirstOrDefault(); var selectedData2 = _entities.tbl_PurchaseMaster.Where(x => x.pId == cellId).FirstOrDefault(); if (selectedData1 != null) { _entities.tbl_PurchaseDetails.Remove(selectedData1); } else { MessageBox.Show("Something went wrong. Record cannot be deleted."); } if (selectedData2 != null) { _entities.tbl_PurchaseMaster.Remove(selectedData2); } else { MessageBox.Show("Something went wrong. Record cannot be deleted."); } _entities.SaveChanges(); MessageBox.Show("Record deleted "); dataGridBind(); } else { //No delete } } } catch (Exception x) { MessageBox.Show("Record Cannot be deleted. Reference of this record is present in other entries"); } }
private void txtitemName_Leave(object sender, EventArgs e) { try { _entities = new KBBQEntities(); if (txtitemName.Text != string.Empty) { var checkLedgername = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim().ToString()).FirstOrDefault(); if (checkLedgername == null) { DialogResult myResult; myResult = MessageBox.Show("No such product exists. Want to create new product?", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (myResult == DialogResult.OK) { //frmAddPurchaseProduct ledger = new frmAddPurchaseProduct(0,txtitemName.Text.Trim()); //ledger.ShowDialog(); purchaseProduct pp = new purchaseProduct(); pp.pName = txtitemName.Text.Trim().ToString(); _entities.purchaseProducts.Add(pp); _entities.SaveChanges(); itemAutocomplete(); txtitemName.Focus(); } else { txtitemName.Focus(); } } } } catch (Exception x) { } }
private void dgAdvBookingDetails_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dgAdvBookingDetails.Columns[e.ColumnIndex].Name == "Delete") { DialogResult myResult; myResult = MessageBox.Show("Are you really delete the item?", "Delete Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (myResult == DialogResult.OK) { _entities = new KBBQEntities(); var cellId = Convert.ToInt32(dgAdvBookingDetails.CurrentRow.Cells[0].Value); var selectedData1 = _entities.tblAdvBookings.Where(x => x.id == cellId).FirstOrDefault(); if (selectedData1 != null) { _entities.tblAdvBookings.Remove(selectedData1); } else { MessageBox.Show("Something went wrong. Record cannot be deleted."); } _entities.SaveChanges(); MessageBox.Show("Record deleted "); gridViewBind(); } } } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void btnCreate_Click(object sender, EventArgs e) { try { if (txtRefNo.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtRefNo, "Enter reference number."); txtRefNo.Focus(); panel3.Visible = true; lblError.Text = "Enter reference number."; } else if (txtTotalWeight.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtTotalWeight, "Enter total weight."); txtTotalWeight.Focus(); panel3.Visible = true; lblError.Text = "Enter total weight."; } else if (txtTotalAmt.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtTotalAmt, "Enter total rate."); txtTotalAmt.Focus(); panel3.Visible = true; lblError.Text = "Enter total rate."; } else { if (btnCreate.Text == "Create") { //Save Code _entities = new KBBQEntities(); tbl_PurchaseMaster purchaseData = new tbl_PurchaseMaster(); purchaseData.refNo = txtRefNo.Text.Trim().ToString(); DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null); purchaseData.date = date; purchaseData.totalWeight = Convert.ToDecimal(txtTotalWeight.Text); purchaseData.unit = lblUnit.Text; purchaseData.totalAmt = Convert.ToDecimal(txtTotalAmt.Text); purchaseData.remarks = txtRemark.Text.ToString(); purchaseData.createdDate = DateTime.Now; purchaseData.updateDate = DateTime.Now; purchaseData.partyName = txtPartyName.Text.Trim().ToString(); _entities.tbl_PurchaseMaster.Add(purchaseData); _entities.SaveChanges(); //add data to purchase detials addPurchaseDetailsData(); MessageBox.Show("Record Successfull Saved"); } else { //Update Code _entities = new KBBQEntities(); var purchaseDataUpdate = _entities.tbl_PurchaseMaster.Where(x => x.pId == passedPid).FirstOrDefault(); purchaseDataUpdate.refNo = txtRefNo.Text.Trim().ToString(); DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null); purchaseDataUpdate.date = Convert.ToDateTime(date); purchaseDataUpdate.totalWeight = Convert.ToDecimal(txtTotalWeight.Text); purchaseDataUpdate.unit = lblUnit.Text; purchaseDataUpdate.totalAmt = Convert.ToDecimal(txtTotalAmt.Text); purchaseDataUpdate.remarks = txtRemark.Text.ToString(); purchaseDataUpdate.updateDate = DateTime.Now; purchaseDataUpdate.partyName = txtPartyName.Text.Trim().ToString(); _entities.SaveChanges(); var purchaseDetailsUpdate = _entities.tbl_PurchaseDetails.Where(x => x.purchaseID == passedPid).ToList(); foreach (var item in purchaseDetailsUpdate) { _entities.tbl_PurchaseDetails.Remove(item); _entities.SaveChanges(); } addPurchaseDetailsData(); //grid data entry in purchse details //Update transaction MessageBox.Show("Record Successfull Updated"); } clear(); clearDetails(); count = 0; passedPid = 0; } } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void btnCreate_Click(object sender, EventArgs e) { try { if (txtCustName.Text == string.Empty && txtMob.Text == string.Empty && txtChild.Text == string.Empty && txtAdults.Text == string.Empty && txtAdvPayment.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtCustName, "Enter all details."); txtCustName.Focus(); panel3.Visible = true; lblError.Text = "Enter all details."; } else if (txtCustName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtCustName, "Enter Customer-name"); txtCustName.Focus(); panel3.Visible = true; lblError.Text = "Enter Customer-name."; } else if (txtMob.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtMob, "Enter Mobile Number."); txtMob.Focus(); panel3.Visible = true; lblError.Text = "Enter Qty."; } else if (txtAdults.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtAdults, "Enter Adults."); txtAdults.Focus(); panel3.Visible = true; lblError.Text = "There must be atleast 1 adult."; } else if (txtAdvPayment.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtAdvPayment, "Enter Adv. Payment."); txtAdvPayment.Focus(); panel3.Visible = true; lblError.Text = "Adv. Payment."; } else { //DateTime date = DateTime.ParseExact(dateToday.Text, "yyyy-MM-dd", null); if (btnCreate.Text == "Create") { tblAdvBooking data = new tblAdvBooking(); data.custName = txtCustName.Text.Trim().ToString(); data.mob = txtMob.Text.Trim().ToString(); data.child = Convert.ToInt32(txtChild.Text.ToString()); data.adults = Convert.ToInt32(txtAdults.Text); data.eventDate = dtpBookingDate.Value.Date; data.todayDate = dateToday.Value.Date; data.advancePayment = Convert.ToDecimal(txtAdvPayment.Text); data.status = "UNPAID"; data.cdate = DateTime.Now; _entities.tblAdvBookings.Add(data); _entities.SaveChanges(); MessageBox.Show("Record Created Successfully"); DialogResult myResult; myResult = MessageBox.Show("Are you want to print receipt?", "Print Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (myResult == DialogResult.OK) { _entities = new KBBQEntities(); long lastId = _entities.tblAdvBookings.OrderByDescending(x => x.id).FirstOrDefault().id; frmRptAdvanceBookingMEMO rpt = new frmRptAdvanceBookingMEMO(lastId); rpt.ShowDialog(); } } else { //Update Code _entities = new KBBQEntities(); //var pId = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim()).FirstOrDefault().id; var advBookingData = _entities.tblAdvBookings.Where(x => x.id == passedId).FirstOrDefault(); advBookingData.custName = txtCustName.Text.Trim().ToString(); advBookingData.mob = txtMob.Text.Trim().ToString(); advBookingData.child = Convert.ToInt32(txtChild.Text.ToString()); advBookingData.adults = Convert.ToInt32(txtAdults.Text); advBookingData.eventDate = dtpBookingDate.Value.Date; advBookingData.todayDate = dateToday.Value.Date; advBookingData.advancePayment = Convert.ToDecimal(txtAdvPayment.Text); _entities.SaveChanges(); MessageBox.Show("Record Updated Successfully"); DialogResult myResult; myResult = MessageBox.Show("Are you want to print receipt?", "Print Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (myResult == DialogResult.OK) { _entities = new KBBQEntities(); frmRptAdvanceBookingMEMO rpt = new frmRptAdvanceBookingMEMO(passedId); rpt.ShowDialog(); } } clear(); gridViewBind(); } } catch (Exception x) { } }
private void btnCreate_Click(object sender, EventArgs e) { try { if (txtitemName.Text == string.Empty && txtQty.Text == string.Empty && txtWeight.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtitemName, "Enter all details."); txtitemName.Focus(); panel3.Visible = true; lblError.Text = "Enter all details."; } else if (txtitemName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtitemName, "Enter Product-name"); txtitemName.Focus(); panel3.Visible = true; lblError.Text = "Enter Party-name."; } else if (txtQty.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtQty, "Enter Qty."); txtQty.Focus(); panel3.Visible = true; lblError.Text = "Enter Qty."; } else if (txtWeight.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtWeight, "Enter Weight."); txtWeight.Focus(); panel3.Visible = true; lblError.Text = "Enter Weight."; } else { DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null); if (btnCreate.Text == "Create") { //save code _entities = new KBBQEntities(); var pId = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim()).FirstOrDefault().id; //var checkForExisitingData = _entities.tblPurchaseOrders.Where(x => x.productId == pId).FirstOrDefault(); //if (checkForExisitingData != null) //{ // MessageBox.Show("Entry Already Exists. Update the Exisiting Entry.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); // clear(); // txtitemName.Focus(); // return; //} //else //{ //save Code tblPurchaseOrder proDate = new tblPurchaseOrder(); proDate.productId = pId; proDate.qty = Convert.ToDecimal(txtQty.Text); proDate.weight = Convert.ToDecimal(txtWeight.Text); proDate.unit = comboUnit.Text.ToString(); proDate.date = date; proDate.cdate = DateTime.Now; _entities.tblPurchaseOrders.Add(proDate); _entities.SaveChanges(); clear(); MessageBox.Show("Record Added Successfully"); //} } else { //Update Code _entities = new KBBQEntities(); var pId = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim()).FirstOrDefault().id; var proDataUpdate = _entities.tblPurchaseOrders.Where(x => x.id == passedId).FirstOrDefault(); proDataUpdate.productId = pId; proDataUpdate.qty = Convert.ToDecimal(txtQty.Text); proDataUpdate.weight = Convert.ToDecimal(txtWeight.Text); proDataUpdate.unit = comboUnit.Text.ToString(); proDataUpdate.date = date; proDataUpdate.udate = DateTime.Now; _entities.SaveChanges(); clear(); MessageBox.Show("Record Updated Successfully"); } dataGridBind(); } } catch (Exception x) { } }
private void btnSubmit_Click(object sender, EventArgs e) { try { if (txtProductName.Text == string.Empty && txtQuantity.Text == string.Empty && txtWeight.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtProductName, "Enter all details."); txtProductName.Focus(); panel3.Visible = true; lblError.Text = "Enter all details."; } else if (txtProductName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtProductName, "Enter Product-name"); txtProductName.Focus(); panel3.Visible = true; lblError.Text = "Enter Party-name."; } else if (txtQuantity.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtQuantity, "Enter Qty."); txtQuantity.Focus(); panel3.Visible = true; lblError.Text = "Enter Qty."; } else if (txtWeight.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtWeight, "Enter Weight."); txtWeight.Focus(); panel3.Visible = true; lblError.Text = "Enter Weight."; } else { DateTime date = DateTime.ParseExact(dateToday.Text, "dd-MM-yyyy", null); if (btnSubmit.Text == "Submit") { //save code _entities = new KBBQEntities(); purchaseProduct proDate = new purchaseProduct(); proDate.pName = txtProductName.Text.Trim().ToString(); proDate.qty = Convert.ToDecimal(txtQuantity.Text); proDate.weight = Convert.ToDecimal(txtWeight.Text); proDate.unit = comboUnit.Text.ToString(); proDate.date = date; proDate.cdate = DateTime.Now; _entities.purchaseProducts.Add(proDate); _entities.SaveChanges(); clear(); MessageBox.Show("Record Added Successfully"); } else { //update code _entities = new KBBQEntities(); var proDataUpdate = _entities.purchaseProducts.Where(x => x.id == passedId).FirstOrDefault(); proDataUpdate.pName = txtProductName.Text.Trim().ToString(); proDataUpdate.qty = Convert.ToDecimal(txtQuantity.Text); proDataUpdate.weight = Convert.ToDecimal(txtWeight.Text); proDataUpdate.unit = comboUnit.Text.ToString(); proDataUpdate.date = date; proDataUpdate.udate = DateTime.Now; _entities.SaveChanges(); clear(); MessageBox.Show("Record Updated Successfully"); } } } catch (Exception x) { MessageBox.Show(x.ToString()); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (txtExpName.Text == string.Empty && txtExpBy.Text == string.Empty && txtAmt.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtExpName, "Enter all details."); txtExpName.Focus(); panel3.Visible = true; lblError.Text = "Enter all details."; } else if (txtExpName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtExpName, "Enter Expense-name"); txtExpName.Focus(); panel3.Visible = true; lblError.Text = "Enter Customer-name."; } else if (txtExpBy.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtExpBy, "Enter Expense By."); txtExpBy.Focus(); panel3.Visible = true; lblError.Text = "Enter Expense By."; } else if (txtAmt.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtAmt, "Enter Amount."); txtAmt.Focus(); panel3.Visible = true; lblError.Text = "Enter Amount."; } else { //DateTime date = DateTime.ParseExact(dateToday.Text, "yyyy-MM-dd", null); if (btnCreate.Text == "Save") { tblExpens data = new tblExpens(); data.expName = txtExpName.Text.Trim().ToString(); data.expBy = txtExpBy.Text.Trim().ToString(); data.expDate = dtpExpDate.Value.Date; data.amount = Convert.ToDecimal(txtAmt.Text); data.cdate = DateTime.Now; _entities.tblExpenses.Add(data); _entities.SaveChanges(); MessageBox.Show("Record Created Successfully"); } else { //Update Code _entities = new KBBQEntities(); //var pId = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim()).FirstOrDefault().id; var expData = _entities.tblExpenses.Where(x => x.id == passedId).FirstOrDefault(); expData.expName = txtExpName.Text.Trim().ToString(); expData.expBy = txtExpBy.Text.Trim().ToString(); expData.expDate = dtpExpDate.Value.Date; expData.amount = Convert.ToDecimal(txtAmt.Text); expData.udate = DateTime.Now; _entities.SaveChanges(); Clear(); MessageBox.Show("Record Updated Successfully"); } dataGridViewBind(); } } catch (Exception x) { } }