private void showAvailableData() { try { clear(); clearDetails(); btnSubmit.Text = "Update"; _entities = new TSEntities(); var data = _entities.tbl_SheetMaster.Where(x => x.sheetId == passedId).FirstOrDefault(); txtSheetName.Text = data.sheetName; txtTotalRate.Text = data.totalRate.ToString(); txtTotalAmount.Text = data.totalAmt.ToString(); txtProfitMargin.Text = data.profitMargin.ToString(); txtTaxRate.Text = data.gstAmt.ToString(); if (data.gstPer == 18) { cmbGst.SelectedIndex = 1; } if (data.gstPer == 28) { cmbGst.SelectedIndex = 2; } else { cmbGst.SelectedIndex = 0; } ttlRate = Convert.ToDecimal(data.totalRate); //Sheet Details _entities = new TSEntities(); var sheetDetailsData = _entities.tbl_SheetDetails.Where(x => x.sheetId == passedId).ToList(); datagridId = 1; foreach (var item in sheetDetailsData) { var itemName = _entities.tbl_ProductMaster.Where(x => x.id == item.pId).FirstOrDefault().p_Name; dgSheetDetails.Rows.Add( datagridId.ToString(), itemName, item.qty, item.weight, item.rate, item.amt); datagridId = datagridId + 1; } } catch (Exception x) { } }
private void SheetgridBind() { ppMsg = new PopupMessage(); try { int rowNo = 1; dgSheetMaster.AutoGenerateColumns = false; _entities = new TSEntities(); List <SheetMasterVM> modelList = new List <SheetMasterVM>(); var data = _entities.tbl_SheetMaster.OrderBy(x => x.sheetName); foreach (var item in data) { SheetMasterVM model = new SheetMasterVM(); model.rowNo = rowNo; model.sheetId = item.sheetId; model.sheetName = item.sheetName; modelList.Add(model); rowNo++; } dgSheetMaster.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString() + " Rows"; } catch (Exception x) { ppMsg.infoMessage("Something went wrong. Contact your system administrator!"); } }
private void dgProductMaster_DoubleClick(object sender, EventArgs e) { ppMsg = new PopupMessage(); try { //ProductId = 0; if (dgProductMaster.CurrentRow.Index != -1 && dgProductMaster.CurrentRow.Cells[1].Value != null) { var lID = Convert.ToInt32(dgProductMaster.CurrentRow.Cells[0].Value); _entities = new TSEntities(); var data = _entities.tbl_ProductMaster.Where(x => x.id == lID).FirstOrDefault(); //clear(); txtpName.Text = data.p_Name; txtRate.Text = data.rate.ToString(); // ProductId = data.id; //btnSubmit.Text = "Update"; } } catch (Exception x) { ppMsg.infoMessage("Something went wrong. Contact your system administrator!"); } }
private void gridBind() { try { int rowNo = 1; dgProductMaster.AutoGenerateColumns = false; _entities = new TSEntities(); List <ProductMasterVM> modelList = new List <ProductMasterVM>(); var data = _entities.tbl_ProductMaster.OrderBy(x => x.p_Name); foreach (var item in data) { ProductMasterVM model = new ProductMasterVM(); model.rowNo = rowNo; model.id = item.id; model.p_Name = item.p_Name; model.rate = item.rate + " /-"; modelList.Add(model); rowNo++; } dgProductMaster.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString() + " Rows"; } catch (Exception x) { ppMessage.infoMessage("Something went wrong. Contact your system administrator!"); } }
void addSheetDetailsData() { foreach (DataGridViewRow dr in dgSheetDetails.Rows) { if (Convert.ToString(dr.Cells[0].Value) != string.Empty) { _entities = new TSEntities(); tbl_SheetDetails sheetDetails = new tbl_SheetDetails(); sheetDetails.sheetId = _entities.tbl_SheetMaster.Where(x => x.sheetName == txtSheetName.Text.Trim().ToString()).FirstOrDefault().sheetId; var gridProductName = dr.Cells[1].Value.ToString(); sheetDetails.pId = _entities.tbl_ProductMaster.Where(x => x.p_Name == gridProductName).FirstOrDefault().id; sheetDetails.qty = Convert.ToDecimal(dr.Cells[2].Value.ToString()); sheetDetails.weight = Convert.ToDecimal(dr.Cells[3].Value.ToString()); sheetDetails.rate = Convert.ToDecimal(dr.Cells[4].Value.ToString()); sheetDetails.amt = Convert.ToDecimal(dr.Cells[5].Value.ToString()); sheetDetails.cDate = DateTime.Now; _entities.tbl_SheetDetails.Add(sheetDetails); _entities.SaveChanges(); //Update Qty in stock //var itemQty = _entities.tbl_StockItemDetails.Where(x => x.itemId == purchaseDetails.productID).FirstOrDefault(); //itemQty.qty = itemQty.qty + purchaseDetails.qty; //itemQty.upadtedDate = DateTime.Now; //_entities.SaveChanges(); } } }
private void productNameNameAutoComplete() { _entities = new TSEntities(); var productNameAutoComplete = _entities.tbl_ProductMaster; txtpName.AutoCompleteCustomSource.Clear(); foreach (var item in productNameAutoComplete) { txtpName.AutoCompleteCustomSource.Add(item.p_Name.ToString()); } }
private void txtpName_KeyPress(object sender, KeyPressEventArgs e) { ppMsg = new PopupMessage(); try { int rowNo = 1; dgProductMaster.AutoGenerateColumns = false; _entities = new TSEntities(); List <ProductMasterVM> productMasterListVM = new List <ProductMasterVM>(); List <tbl_ProductMaster> data; if (txtpName.Text == "") { data = _entities.tbl_ProductMaster.ToList(); } else { data = _entities.tbl_ProductMaster.Where(x => x.p_Name.Contains(txtpName.Text.Trim().ToString())).ToList(); } foreach (var item in data) { ProductMasterVM list = new ProductMasterVM(); list.rowNo = rowNo; list.id = item.id; list.p_Name = item.p_Name; list.rate = item.rate.ToString() + " /-"; productMasterListVM.Add(list); rowNo++; } dgProductMaster.DataSource = productMasterListVM; lblTotalRows.Text = productMasterListVM.Count.ToString() + " Rows"; } catch (Exception x) { ppMsg.infoMessage("Something went wrong. Contact your system administrator!"); } }
private void txtpName_Leave(object sender, EventArgs e) { try { _entities = new TSEntities(); if (txtpName.Text != string.Empty) { var rates = _entities.tbl_ProductMaster.Where(x => x.p_Name == txtpName.Text.Trim().ToString()).FirstOrDefault(); txtRate.Text = rates.rate.ToString(); ProductgridBind(); } } catch (Exception x) { MessageBox.Show(x.ToString()); } }
private void dgProductMaster_CellContentClick(object sender, DataGridViewCellEventArgs e) { ppMsg = new PopupMessage(); try { if (dgProductMaster.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 TSEntities(); var cellId = Convert.ToInt32(dgProductMaster.CurrentRow.Cells[0].Value); var selectedData1 = _entities.tbl_ProductMaster.Where(x => x.id == cellId).OrderBy(x => x.p_Name).FirstOrDefault(); if (selectedData1 != null) { _entities.tbl_ProductMaster.Remove(selectedData1); } else { // MessageBox.Show("Something went wrong. Record cannot be deleted."); ppMsg.infoMessage("Something went wrong. Record cannot be deleted."); } _entities.SaveChanges(); ppMsg.deleteMessage(); //MessageBox.Show("Record deleted "); ProductgridBind(); } } } catch (Exception x) { ppMsg.infoMessage("Something went wrong. Contact your system administrator!"); } }
private void txtRate_Leave(object sender, EventArgs e) { ppMsg = new PopupMessage(); try { if (txtQtyWeight.Text != string.Empty) { if (txtRate.Text == string.Empty) { txtRate.Text = "0.00"; } _entities = new TSEntities(); var rates = _entities.tbl_ProductMaster.Where(x => x.p_Name == txtpName.Text.Trim().ToString()).FirstOrDefault(); if (Convert.ToDecimal(txtRate.Text.Trim()) != rates.rate) { DialogResult myResult; myResult = MessageBox.Show("Are you really wanna change rate of the item?", "Update Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (myResult == DialogResult.OK) { rates.rate = Convert.ToDecimal(txtRate.Text.Trim()); _entities.SaveChanges(); ppMsg.updateMessage(); ProductgridBind(); } else { } txtAmt.Text = Convert.ToDecimal((Convert.ToDecimal(txtQtyWeight.Text.Trim()) * Convert.ToDecimal(txtRate.Text.Trim()))).ToString(); } } } catch (Exception x) { MessageBox.Show(x.ToString()); } }
private void txtpName_Leave(object sender, EventArgs e) { ppMessage = new PopupMessage(); try { if (txtpName.Text != string.Empty) { _entities = new TSEntities(); var p_nameExists = _entities.tbl_ProductMaster.Where(x => x.p_Name == txtpName.Text.Trim()).FirstOrDefault(); if (p_nameExists.id > 0) { ppMessage.infoMessage("Product Name already exists!"); txtpName.Focus(); } } } catch (Exception x) { // ppMessage.infoMessage("Something went wrong. Contact your system administrator!"); } }
private void btnSubmit_Click(object sender, EventArgs e) { ppMsg = new PopupMessage(); try { if (txtSheetName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtSheetName, "Enter Sheet Name."); txtSheetName.Focus(); panel9.Visible = true; lblError.Text = "Enter Sheet Name."; } else if (txtProfitMargin.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtProfitMargin, "Profit margin cannot be blank."); txtProfitMargin.Focus(); panel9.Visible = true; lblError.Text = "Profit margin cannot be blank."; } else if (txtProfitMargin.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtProfitMargin, "Enter Profit Margin."); txtProfitMargin.Focus(); panel9.Visible = true; lblError.Text = "Enter Profit Margin."; } //else if (txtTaxRate.Text == string.Empty) //{ // errorProvider1.Clear(); // errorProvider1.SetError(txtTaxRate, "Enter Tax Amt."); // txtTaxRate.Focus(); // panel9.Visible = true; // lblError.Text = "Enter Tax Amt."; //} //else if (txtTotalAmount.Text == string.Empty) //{ // errorProvider1.Clear(); // errorProvider1.SetError(txtTotalAmount, "Enter Total Amount."); // txtTotalAmount.Focus(); // panel9.Visible = true; // lblError.Text = "Enter Total Amount."; //} else { if (btnSubmit.Text == "Submit") { // Save Code _entities = new TSEntities(); tbl_SheetMaster sm = new tbl_SheetMaster(); sm.sheetName = txtSheetName.Text.Trim().ToString(); sm.date = Convert.ToDateTime(dateTimePicker1.Text.ToString()).Date; sm.totalRate = Convert.ToDecimal(txtTotalRate.Text.Trim()); sm.totalAmt = Convert.ToDecimal(txtTotalAmount.Text.Trim()); sm.profitMargin = Convert.ToDecimal(txtProfitMargin.Text.Trim()); if (cmbGst.SelectedIndex == 1) { sm.gstPer = 18; } else if (cmbGst.SelectedIndex == 2) { sm.gstPer = 28; } else { sm.gstPer = 0; } sm.gstAmt = Convert.ToDecimal(txtTaxRate.Text.Trim()); sm.remarks = txtRemark.Text.Trim().ToString(); sm.cDate = DateTime.Now; _entities.tbl_SheetMaster.Add(sm); _entities.SaveChanges(); ppMsg.successMessage(); addSheetDetailsData(); } else { //Update Code } clear(); clearDetails(); } } catch (Exception x) { MessageBox.Show(x.ToString()); } }
private void btnSubmit_Click(object sender, EventArgs e) { ppMessage = new PopupMessage(); try { if (txtpName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtpName, "Enter Product Name."); txtpName.Focus(); panel4.Visible = true; lblError.Text = "Enter Product Name."; } else if (txtRate.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtRate, "Enter Rate."); txtRate.Focus(); panel4.Visible = true; lblError.Text = "Enter Rate."; } else { if (btnSubmit.Text == "Submit") { //Save No Code _entities = new TSEntities(); tbl_ProductMaster pm = new tbl_ProductMaster(); pm.p_Name = txtpName.Text.Trim().ToString(); pm.rate = Convert.ToDecimal(txtRate.Text.Trim()); _entities.tbl_ProductMaster.Add(pm); _entities.SaveChanges(); //Notification ppMessage.successMessage(); } else { // Update No Code _entities = new TSEntities(); var data = _entities.tbl_ProductMaster.Where(x => x.id == ProductId).FirstOrDefault(); data.p_Name = txtpName.Text.Trim().ToString(); data.rate = Convert.ToDecimal(txtRate.Text.Trim()); _entities.SaveChanges(); ppMessage.updateMessage(); } // Clear Function Call clear(); } } catch (Exception x) { ppMessage.infoMessage("Something went wrong. Contact your system administrator!"); } }