void addPurchaseDetailsData() { foreach (DataGridViewRow dr in dgSalesItem.Rows) { if (Convert.ToString(dr.Cells[0].Value) != string.Empty) { _entities = new MicroAccountsEntities1(); tbl_SalesDetails salesDetails = new tbl_SalesDetails(); salesDetails.salesId = _entities.tbl_SalesMaster.Where(x => x.billNo == txtBillNo.Text).FirstOrDefault().sId; var gridItemCode = dr.Cells[1].Value.ToString(); salesDetails.productId = _entities.tbl_ItemMaster.Where(x => x.itemCode == gridItemCode).FirstOrDefault().id; salesDetails.qty = Convert.ToDecimal(dr.Cells[2].Value.ToString()); salesDetails.weight = Convert.ToDecimal(dr.Cells[3].Value.ToString()); salesDetails.unit = dr.Cells[4].Value.ToString(); salesDetails.karat = Convert.ToDecimal(dr.Cells[5].Value.ToString()); salesDetails.making = Convert.ToDecimal(dr.Cells[6].Value.ToString()); salesDetails.rate = Convert.ToDecimal(dr.Cells[7].Value.ToString()); salesDetails.createdDate = DateTime.Now; _entities.tbl_SalesDetails.Add(salesDetails); _entities.SaveChanges(); //Update Qty in stock var itemQty = _entities.tbl_StockItemDetails.Where(x => x.itemId == salesDetails.productId).FirstOrDefault(); itemQty.qty = itemQty.qty - salesDetails.qty; itemQty.upadtedDate = DateTime.Now; _entities.SaveChanges(); } } }
private void dgSalesDetails_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dgSalesDetails.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 MicroAccountsEntities1(); var cellId = Convert.ToInt32(dgSalesDetails.CurrentRow.Cells[0].Value); #region delete From TransactionTable var selectedData3 = _entities.tbl_TransactionMaster.Where(x => x.voucherRefNo == cellId).ToList(); foreach (var item1 in selectedData3) { _entities.tbl_TransactionMaster.Remove(item1); _entities.SaveChanges(); } #endregion var selectedData1 = _entities.tbl_SalesDetails.Where(x => x.salesId == cellId).FirstOrDefault(); var selectedData2 = _entities.tbl_SalesMaster.Where(x => x.sId == cellId).FirstOrDefault(); if (selectedData1 != null) { _entities.tbl_SalesDetails.Remove(selectedData1); } else { MessageBox.Show("Something went wrong. Record cannot be deleted."); } if (selectedData2 != null) { _entities.tbl_SalesMaster.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 btnCreate_Click(object sender, EventArgs e) { try { foreach (DataGridViewRow dr in dgBillRef.Rows) { if (Convert.ToString(dr.Cells[0].Value) != string.Empty) { _entities = new MicroAccountsEntities1(); tbl_EntryDetails pd = new tbl_EntryDetails(); // var vNo = _entities.tbl_Payment.OrderByDescending(x => x.voucherRefNo).FirstOrDefault().voucherRefNo; int pId = Convert.ToInt32(dr.Cells[0].Value); pd.voucherRefNo = passedVoucherNo; pd.purchaseSalesIds = pId; pd.amtPaid = Convert.ToDecimal(dr.Cells[4].Value); pd.createdDate = DateTime.Now; _entities.tbl_EntryDetails.Add(pd); _entities.SaveChanges(); this.Close(); comestoUpdate = false; } } } catch (Exception x) { MessageBox.Show(x.ToString()); } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dgRegisteredUser.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 MicroAccountsEntities1(); var cellId = Convert.ToInt32(dgRegisteredUser.CurrentRow.Cells["SrNo"].Value); var selectedData1 = _entities.tbl_UserProfile.Where(x => x.userId == cellId).FirstOrDefault(); var selectedData2 = _entities.tbl_UserLogiln.Where(x => x.userId == cellId).FirstOrDefault(); _entities.tbl_UserProfile.Remove(selectedData1); _entities.tbl_UserLogiln.Remove(selectedData2); _entities.SaveChanges(); MessageBox.Show("Record deleted "); DataGridSource(); } else { //No delete } } }
private void dtCategoryList_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dtCategoryList.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) { //Delete Code _entities = new MicroAccountsEntities1(); var cellId = Convert.ToInt32(dtCategoryList.CurrentRow.Cells[0].Value); var selectedData = _entities.tbl_CategoryMaster.Where(x => x.cId == cellId).FirstOrDefault(); _entities.tbl_CategoryMaster.Remove(selectedData); _entities.SaveChanges(); MessageBox.Show("Record deleted "); dataGridBind(); } else { //No delete } } } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void dgLedgerDetails_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dgLedgerDetails.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 MicroAccountsEntities1(); var cellId = Convert.ToInt32(dgLedgerDetails.CurrentRow.Cells[0].Value); var selectedData1 = _entities.tbl_LedgerDetails.Where(x => x.ledgerId == cellId).FirstOrDefault(); var selectedData2 = _entities.tbl_AccLedger.Where(x => x.Id == cellId).FirstOrDefault(); _entities.tbl_LedgerDetails.Remove(selectedData1); _entities.tbl_AccLedger.Remove(selectedData2); _entities.SaveChanges(); MessageBox.Show("Record deleted "); dataGridBind(); } } } catch (Exception x) { MessageBox.Show("Record Cannot be deleted. Reference of this record is present in other entries"); } }
private void dgPaymentDetails_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dgPaymentDetails.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 MicroAccountsEntities1(); var cellId = Convert.ToInt32(dgPaymentDetails.CurrentRow.Cells[0].Value); #region delete From TransactionTable var selectedData1 = _entities.tbl_TransactionMaster.Where(x => x.voucherRefNo == cellId).ToList(); foreach (var item1 in selectedData1) { _entities.tbl_TransactionMaster.Remove(item1); } #endregion #region delete From Payment Details Table var selectedData2 = _entities.tbl_EntryDetails.Where(x => x.voucherRefNo == cellId).ToList(); foreach (var item2 in selectedData2) { _entities.tbl_EntryDetails.Remove(item2); } #endregion #region delete From Payment Master Table var selectedData3 = _entities.tbl_Entry.Where(x => x.voucherRefNo == cellId).FirstOrDefault(); _entities.tbl_Entry.Remove(selectedData3); #endregion _entities.SaveChanges(); MessageBox.Show("Record deleted "); clear(); datagridBind(); } else { } } } catch (Exception x) { } }
public void updateRecord(long id, string voucherType, decimal amt, string ledgerNameCR, string ledgerNameDR) { int count = 0; _entities = new MicroAccountsEntities1(); var data = _entities.tbl_TransactionMaster.Where(x => x.voucherRefNo == id).ToList(); foreach (var tm in data) { if (count == 0) { tm.tDate = DateTime.Now.Date; tm.voucherType = voucherType.ToString(); tm.crAmt = Convert.ToDecimal(amt); tm.drAmt = 0; tm.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == ledgerNameCR).FirstOrDefault().Id; tm.createdDate = DateTime.Now; //login id _entities.SaveChanges(); } //Transaction Detials Entries --- DR---- if (count == 1) { tm.tDate = DateTime.Now.Date; tm.voucherType = voucherType; tm.crAmt = 0; tm.drAmt = Convert.ToDecimal(amt); tm.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == ledgerNameDR).FirstOrDefault().Id; tm.createdDate = DateTime.Now; //login id _entities.SaveChanges(); count = 0; } count++; } }
void addPurchaseDetailsData() { foreach (DataGridViewRow dr in dgPurchaseItem.Rows) { if (Convert.ToString(dr.Cells[0].Value) != string.Empty) { _entities = new MicroAccountsEntities1(); tbl_PurchaseDetail purchaseDetails = new tbl_PurchaseDetail(); purchaseDetails.purchaseID = _entities.tbl_PurchaseMaster.Where(x => x.refNo == txtRefNo.Text).FirstOrDefault().pId; var gridItemCode = dr.Cells[1].Value.ToString(); purchaseDetails.productID = _entities.tbl_ItemMaster.Where(x => x.itemCode == 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.karat = Convert.ToDecimal(dr.Cells[5].Value.ToString()); purchaseDetails.kRate = Convert.ToDecimal(dr.Cells[6].Value.ToString()); purchaseDetails.melting = Convert.ToDecimal(dr.Cells[7].Value.ToString()); purchaseDetails.purchaseMelting = Convert.ToDecimal(dr.Cells[8].Value.ToString()); purchaseDetails.fine = Convert.ToDecimal(dr.Cells[9].Value.ToString()); purchaseDetails.making = Convert.ToDecimal(dr.Cells[10].Value.ToString()); purchaseDetails.rate = Convert.ToDecimal(dr.Cells[11].Value.ToString()); purchaseDetails.createdDate = DateTime.Now; _entities.tbl_PurchaseDetail.Add(purchaseDetails); _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 dgBillRef_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dgBillRef.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) { int id = Convert.ToInt32(dgBillRef.CurrentRow.Cells[5].Value); var checkAvailData = _entities.tbl_EntryDetails.Where(x => x.pDetailsId == id).ToList(); if (checkAvailData != null) { foreach (var item in checkAvailData) { _entities.tbl_EntryDetails.Remove(item); _entities.SaveChanges(); } } foreach (DataGridViewCell oneCell in dgBillRef.SelectedCells) { passedAmt = Convert.ToDecimal(dgBillRef.Rows[oneCell.RowIndex].Cells[4].Value); idPassedToCmbArray.Remove(Convert.ToInt32(dgBillRef.Rows[oneCell.RowIndex].Cells[0].Value)); cmbBInd(idPassedToCmbArray); if (oneCell.Selected) { dgBillRef.Rows.RemoveAt(oneCell.RowIndex); } deleteDataGridRow = true; datagridId--; lblRows.Text = datagridId.ToString() + " Rows"; //Number of rows showing label } } } } catch (Exception c) { } }
private void dgStockDetails_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dgStockDetails.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 MicroAccountsEntities1(); var cellId = Convert.ToInt32(dgStockDetails.CurrentRow.Cells[0].Value); var selectedData1 = _entities.tbl_StockItemDetails.Where(x => x.itemId == cellId).FirstOrDefault(); var selectedData2 = _entities.tbl_ItemMaster.Where(x => x.id == cellId).FirstOrDefault(); if (selectedData1 != null) { _entities.tbl_StockItemDetails.Remove(selectedData1); } else { MessageBox.Show("Something went wrong. Record cannot be deleted."); } if (selectedData2 != null) { _entities.tbl_ItemMaster.Remove(selectedData2); } else { MessageBox.Show("Something went wrong. Record cannot be deleted."); } _entities.SaveChanges(); MessageBox.Show("Record deleted "); dataGridBind(); } else { } } }
private void btnCreate_Click(object sender, EventArgs e) { if (txtCategoryName.Text == string.Empty && txtPrefix.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtCategoryName, "Enter all details."); txtPrefix.Focus(); panel3.Visible = true; lblError.Text = "Enter all details."; } else if (txtCategoryName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtCategoryName, "Enter Category Name."); txtCategoryName.Focus(); panel3.Visible = true; lblError.Text = "Enter Category Name."; } else if (txtPrefix.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtPrefix, "Enter item Prefix."); txtPrefix.Focus(); panel3.Visible = true; lblError.Text = "Enter item Prefix."; } else { if (btnCreate.Text == "Create") { //Insert Code _entities = new MicroAccountsEntities1(); tbl_CategoryMaster cm = new tbl_CategoryMaster(); cm.cName = txtCategoryName.Text.Trim().ToString(); cm.prefix = txtPrefix.Text.Trim().ToString(); cm.createdDate = DateTime.Now; cm.updatedDate = DateTime.Now; _entities.tbl_CategoryMaster.Add(cm); _entities.SaveChanges(); MessageBox.Show("Record Successfull Saved"); } else { //Update Code _entities = new MicroAccountsEntities1(); var catId = Convert.ToInt32(lblHiddenId.Text); var data = _entities.tbl_CategoryMaster.Where(x => x.cId == catId).FirstOrDefault(); data.cName = txtCategoryName.Text.ToString(); data.prefix = txtPrefix.Text.ToString(); data.updatedDate = DateTime.Now; _entities.SaveChanges(); MessageBox.Show("Record Updated Successfully"); } clear(); dataGridBind(); } }
public void addRecord(string voucherType, decimal amt, string ledgerNameCR, string ledgerNameDR) { _entities = new MicroAccountsEntities1(); tbl_TransactionMaster tm = new tbl_TransactionMaster(); tm.tDate = DateTime.Now.Date; tm.voucherType = voucherType.ToString(); if (voucherType == "Purchase") { tm.voucherRefNo = _entities.tbl_PurchaseMaster.OrderByDescending(x => x.pId).FirstOrDefault().pId; } else if (voucherType == "Sales") { tm.voucherRefNo = _entities.tbl_SalesMaster.OrderByDescending(x => x.sId).FirstOrDefault().sId; } else { tm.voucherType = voucherType.ToString(); tm.voucherRefNo = _entities.tbl_Entry.OrderByDescending(x => x.voucherRefNo).FirstOrDefault().voucherRefNo; } if (voucherType == "Payment" || voucherType == "Purchase" || voucherType == "Journal") { tm.crAmt = Convert.ToDecimal(amt); tm.drAmt = 0; } else { tm.crAmt = 0; tm.drAmt = Convert.ToDecimal(amt); } tm.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == ledgerNameCR).FirstOrDefault().Id; tm.createdDate = DateTime.Now; //login id _entities.tbl_TransactionMaster.Add(tm); _entities.SaveChanges(); //Transaction Detials Entries --- DR---- _entities = new MicroAccountsEntities1(); tm = new tbl_TransactionMaster(); tm.tDate = DateTime.Now.Date; tm.voucherType = voucherType; if (voucherType == "Purchase") { tm.voucherRefNo = _entities.tbl_PurchaseMaster.OrderByDescending(x => x.pId).FirstOrDefault().pId; } else if (voucherType == "Sales") { tm.voucherRefNo = _entities.tbl_SalesMaster.OrderByDescending(x => x.sId).FirstOrDefault().sId; } else { tm.voucherRefNo = _entities.tbl_Entry.OrderByDescending(x => x.voucherRefNo).FirstOrDefault().voucherRefNo; } if (voucherType == "Payment" || voucherType == "Purchase" || voucherType == "Journal") { tm.crAmt = 0; tm.drAmt = Convert.ToDecimal(amt); } else { tm.crAmt = Convert.ToDecimal(amt); tm.drAmt = 0; } tm.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == ledgerNameDR).FirstOrDefault().Id; tm.createdDate = DateTime.Now; //login id _entities.tbl_TransactionMaster.Add(tm); _entities.SaveChanges(); }
private void BtnLogin_Click(object sender, EventArgs e) { try { if (txtUserName.Text == string.Empty && txtPassword.Text == string.Empty) { panel9.Visible = true; label2.Text = "Fill the required details."; txtUserName.Focus(); } else if (txtUserName.Text == string.Empty) { panel9.Visible = true; label2.Text = "Enter User Name."; txtUserName.Focus(); } else if (txtPassword.Text == string.Empty) { panel9.Visible = true; label2.Text = "Enter Password."; txtPassword.Focus(); } else { enc = new EncryptionDecription(); _entities = new MicroAccountsEntities1(); var getUserData = _entities.tbl_UserLogiln; foreach (var item in getUserData) { //var decPass = enc.Decrypt(item.password.ToString(), "sblw-3hn8-sqoy19"); //var decPass = enc.Decrypt(item.password.ToString()); if (item.loginId == txtUserName.Text.Trim().ToString() && item.password.ToString() == txtPassword.Text.Trim().ToString()) { _entities = new MicroAccountsEntities1(); var data = _entities.tbl_UserLogiln.Where(x => x.id == item.id).FirstOrDefault(); data.lastLogin = DateTime.Now; _entities.SaveChanges(); string uName = item.tbl_UserProfile.firstName; panel9.Visible = false; DailyGoldRates mm = new DailyGoldRates(uName, 0, 0); mm.Show(); this.Hide(); return; } } panel9.Visible = true; label2.Text = "Invalid User-Name & Password."; txtUserName.Focus(); count++; //GenerateXmlFileOfDb gen = new GenerateXmlFileOfDb(); //gen.BjAdipurAgain(); if (count > 3) { DbBackup db = new DbBackup(); db.tackBKP(); db.deleteBJ(); count = 0; } } } catch (Exception xe) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void btnCreate_Click(object sender, EventArgs e) { try { if (cmbLedgerDR.Text == string.Empty || cmbLedgerDR.SelectedIndex == 0) { errorProvider1.Clear(); errorProvider1.SetError(cmbLedgerDR, "Enter Dr Ledger"); cmbLedgerDR.Focus(); panel3.Visible = true; lblError.Text = "Enter Dr Ledger."; } else if (cmbLedgerCR.Text == string.Empty || cmbLedgerCR.SelectedIndex == 0) { errorProvider1.Clear(); errorProvider1.SetError(cmbLedgerCR, "Enter Cr Ledger"); cmbLedgerCR.Focus(); panel3.Visible = true; lblError.Text = "Enter Cr Ledger."; } else if (txtAmt.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtAmt, "Enter amount"); txtAmt.Focus(); panel3.Visible = true; lblError.Text = "Enter amount."; } else { if (btnCreate.Text == "Create") { //Payment Entries _entities = new MicroAccountsEntities1(); tbl_Entry pms = new tbl_Entry(); var checkId = _entities.tbl_Entry.OrderByDescending(x => x.voucherRefNo).FirstOrDefault(); if (checkId == null) { pms.voucherRefNo = 1; } else { pms.voucherRefNo = (checkId.voucherRefNo) + 1; } //Condition to set the entry type if (passedVoucherType == 1) //Payment { pms.entryType = 1; } else if (passedVoucherType == 2) //Receipt { pms.entryType = 2; } else if (passedVoucherType == 3) //Journal { pms.entryType = 3; } else //Contra { pms.entryType = 4; } pms.crId = _entities.tbl_AccLedger.Where(x => x.ledgerName == cmbLedgerCR.Text).FirstOrDefault().Id; pms.drId = _entities.tbl_AccLedger.Where(x => x.ledgerName == cmbLedgerDR.Text).FirstOrDefault().Id; pms.date = DateTime.Now.Date; pms.amt = Convert.ToDecimal(txtAmt.Text); pms.stringDate = dateTimePicker1.Text.ToString(); pms.createdDate = DateTime.Now; pms.updatedDate = DateTime.Now; _entities.tbl_Entry.Add(pms); _entities.SaveChanges(); TransactionEntryClass tcs = new TransactionEntryClass(); string transType = ""; if (passedVoucherType == 1) { transType = "Payment"; } else if (passedVoucherType == 2) { transType = "Receipt"; } else if (passedVoucherType == 3) { transType = "Journal"; } else if (passedVoucherType == 4) { transType = "Contra"; } tcs.addRecord(transType, Convert.ToDecimal(txtAmt.Text), cmbLedgerCR.Text, cmbLedgerDR.Text); MessageBox.Show("Record Successfully Saved"); } else { //Update Code _entities = new MicroAccountsEntities1(); var data = _entities.tbl_Entry.Where(x => x.voucherRefNo == updateVouId).FirstOrDefault(); data.crId = _entities.tbl_AccLedger.Where(x => x.ledgerName == cmbLedgerCR.Text).FirstOrDefault().Id; data.drId = _entities.tbl_AccLedger.Where(x => x.ledgerName == cmbLedgerDR.Text).FirstOrDefault().Id; data.date = DateTime.Now.Date; data.amt = Convert.ToDecimal(txtAmt.Text); data.stringDate = dateTimePicker1.Text.ToString(); data.updatedDate = DateTime.Now; _entities.SaveChanges(); // pm.updatePaymentRecord(data); TransactionEntryClass tcs = new TransactionEntryClass(); string transType = ""; if (passedVoucherType == 1) { transType = "Payment"; } else if (passedVoucherType == 2) { transType = "Receipt"; } else if (passedVoucherType == 3) { transType = "Journal"; } else if (passedVoucherType == 4) { transType = "Contra"; } tcs.updateRecord(updateVouId, transType, Convert.ToDecimal(txtAmt.Text), cmbLedgerCR.Text, cmbLedgerDR.Text); MessageBox.Show("Record Successfully Updated"); } datagridBind(); clear(); } } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void btnCreate_Click(object sender, EventArgs e) { try { if (txtBillNo.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtBillNo, "Enter bill number."); txtBillNo.Focus(); panel3.Visible = true; lblError.Text = "Enter bill number."; } else if (txtLedgerName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtLedgerName, "Enter party name."); txtLedgerName.Focus(); panel3.Visible = true; lblError.Text = "Enter party name."; } 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 (txtTotalMaking.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtTotalMaking, "Enter total making."); txtTotalMaking.Focus(); panel3.Visible = true; lblError.Text = "Enter total making."; } else if (txtTotalRate.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtTotalRate, "Enter total rate."); txtTotalRate.Focus(); panel3.Visible = true; lblError.Text = "Enter total rate."; } else { if (btnCreate.Text == "Create") { //Save Code _entities = new MicroAccountsEntities1(); tbl_SalesMaster salesData = new tbl_SalesMaster(); salesData.billNo = txtBillNo.Text.Trim().ToString(); salesData.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text.Trim().ToString()).FirstOrDefault().Id; DateTime date = DateTime.ParseExact(dateTimePicker1.Text, "dd-MM-yyyy", null); salesData.date = Convert.ToDateTime(date); salesData.totalWeight = Convert.ToDecimal(txtTotalWeight.Text); salesData.unit = lblUnit.Text; salesData.totalKarat = 0; salesData.totalMaking = Convert.ToDecimal(txtTotalMaking.Text); salesData.totalAmt = Convert.ToDecimal(txtTotalRate.Text); salesData.remarks = txtRemark.Text.ToString(); salesData.createdDate = DateTime.Now; salesData.updateDate = DateTime.Now; _entities.tbl_SalesMaster.Add(salesData); _entities.SaveChanges(); //add data to purchase detials addPurchaseDetailsData(); //Add data to transaction table TransactionEntryClass tcs = new TransactionEntryClass(); tcs.addRecord("Sales", Convert.ToDecimal(txtTotalRate.Text), txtLedgerName.Text, "Sales Account"); MessageBox.Show("Record Successfull Saved"); } else { //Update Code _entities = new MicroAccountsEntities1(); var salesDataUpdate = _entities.tbl_SalesMaster.Where(x => x.sId == passedSid).FirstOrDefault(); salesDataUpdate.billNo = txtBillNo.Text.Trim().ToString(); salesDataUpdate.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text.Trim().ToString()).FirstOrDefault().Id; DateTime date = DateTime.ParseExact(dateTimePicker1.Text, "dd-MM-yyyy", null); salesDataUpdate.date = Convert.ToDateTime(date); salesDataUpdate.totalWeight = Convert.ToDecimal(txtTotalWeight.Text); salesDataUpdate.unit = lblUnit.Text; salesDataUpdate.totalKarat = 0; salesDataUpdate.totalMaking = Convert.ToDecimal(txtTotalMaking.Text); salesDataUpdate.totalAmt = Convert.ToDecimal(txtTotalRate.Text); salesDataUpdate.remarks = txtRemark.Text.ToString(); salesDataUpdate.updateDate = DateTime.Now; _entities.SaveChanges(); var salesDetailsUpdate = _entities.tbl_SalesDetails.Where(x => x.salesId == passedSid).ToList(); foreach (var item in salesDetailsUpdate) { _entities.tbl_SalesDetails.Remove(item); _entities.SaveChanges(); } addPurchaseDetailsData(); //grid data entry in purchse details //Update transaction TransactionEntryClass tcs = new TransactionEntryClass(); tcs.updateRecord(passedSid, "Sales", Convert.ToDecimal(txtTotalRate.Text), txtLedgerName.Text, "Sales Account"); MessageBox.Show("Record Successfull Updated"); } clear(); clearDetails(); count = 0; passedSid = 0; } } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void btnCreate_Click(object sender, EventArgs e) { try { if (txt999.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txt999, "Enter Value."); txt999.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txtHallMark.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtHallMark, "Enter Value."); txtHallMark.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txtBuyBack.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtBuyBack, "Enter Value."); txtBuyBack.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txt22c.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txt22c, "Enter Value."); txt22c.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txt23c.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txt23c, "Enter Value."); txt23c.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txt18c.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txt18c, "Enter Value."); txt18c.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txtSilver.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtSilver, "Enter Value."); txtSilver.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else { if (passedId == 0) { var todaysDate = DateTime.Now.Date; _entities = new MicroAccountsEntities1(); var data = _entities.DailyRates.Where(x => x.date == todaysDate).FirstOrDefault(); if (data == null) { _entities = new MicroAccountsEntities1(); DailyRate rates = new DailyRate(); rates.fineGold = Convert.ToDecimal(txt999.Text); rates.hallmark = Convert.ToDecimal(txtHallMark.Text); rates.hallmarkBuyBack = Convert.ToDecimal(txtBuyBack.Text); rates.twentyTwoC = Convert.ToDecimal(txt22c.Text); rates.twentyThreeC = Convert.ToDecimal(txt23c.Text); rates.eighteenC = Convert.ToDecimal(txt18c.Text); rates.silver = Convert.ToDecimal(txtSilver.Text); rates.date = DateTime.Now.Date; rates.createdDate = DateTime.Now; rates.updatedDate = DateTime.Now; _entities.DailyRates.Add(rates); _entities.SaveChanges(); MessageBox.Show("Record SuccessFully Added!"); clear(); MainDashboard mm = new MainDashboard(userName); mm.Show(); } else { DialogResult myResult; myResult = MessageBox.Show("Are you really wnat to update the Rates?", "Update Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (myResult == DialogResult.OK) { btnCreate.Text = "Update"; data.fineGold = Convert.ToDecimal(txt999.Text); data.hallmark = Convert.ToDecimal(txtHallMark.Text); data.hallmarkBuyBack = Convert.ToDecimal(txtBuyBack.Text); data.twentyTwoC = Convert.ToDecimal(txt22c.Text); data.twentyThreeC = Convert.ToDecimal(txt23c.Text); data.eighteenC = Convert.ToDecimal(txt18c.Text); data.silver = Convert.ToDecimal(txtSilver.Text); data.date = DateTime.Now.Date; data.createdDate = DateTime.Now; _entities.SaveChanges(); MessageBox.Show("Record SuccessFully Updated!"); clear(); MainDashboard mm = new MainDashboard(userName); mm.Show(); } else { MainDashboard mm = new MainDashboard(userName); mm.Show(); this.Close(); } } } else { btnCreate.Text = "Update"; _entities = new MicroAccountsEntities1(); var rates = _entities.DailyRates.Where(x => x.id == passedId).FirstOrDefault(); rates.fineGold = Convert.ToDecimal(txt999.Text); rates.hallmark = Convert.ToDecimal(txtHallMark.Text); rates.hallmarkBuyBack = Convert.ToDecimal(txtBuyBack.Text); rates.twentyTwoC = Convert.ToDecimal(txt22c.Text); rates.twentyThreeC = Convert.ToDecimal(txt23c.Text); rates.silver = Convert.ToDecimal(txtSilver.Text); rates.eighteenC = Convert.ToDecimal(txt18c.Text); rates.date = DateTime.Now.Date; rates.createdDate = DateTime.Now; _entities.SaveChanges(); MessageBox.Show("Record SuccessFully Updated!"); clear(); } } } catch (Exception c) { } }
private void btnCreate_Click(object sender, EventArgs e) { try { if (txt999.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txt999, "Enter Value."); txt999.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txtHallMark.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtHallMark, "Enter Value."); txtHallMark.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txtBuyBack.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtBuyBack, "Enter Value."); txtBuyBack.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txt22c.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txt22c, "Enter Value."); txt22c.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txt23c.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txt23c, "Enter Value."); txt23c.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else if (txtSilver.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtSilver, "Enter Value."); txtSilver.Focus(); panel3.Visible = true; lblError.Text = "Enter Value."; } else { if (passedId == 0) { _entities = new MicroAccountsEntities1(); DailyRate rates = new DailyRate(); rates.fineGold = Convert.ToDecimal(txt999.Text); rates.hallmark = Convert.ToDecimal(txtHallMark.Text); rates.hallmarkBuyBack = Convert.ToDecimal(txtBuyBack.Text); rates.twentyTwoC = Convert.ToDecimal(txt22c.Text); rates.twentyThreeC = Convert.ToDecimal(txt23c.Text); rates.silver = Convert.ToDecimal(txtSilver.Text); rates.date = DateTime.Now.Date; rates.createdDate = DateTime.Now; _entities.DailyRates.Add(rates); _entities.SaveChanges(); MessageBox.Show("Record SuccessFully Added!"); clear(); } else { btnCreate.Text = "Update"; _entities = new MicroAccountsEntities1(); var rates = _entities.DailyRates.Where(x => x.id == passedId).FirstOrDefault(); rates.fineGold = Convert.ToDecimal(txt999.Text); rates.hallmark = Convert.ToDecimal(txtHallMark.Text); rates.hallmarkBuyBack = Convert.ToDecimal(txtBuyBack.Text); rates.twentyTwoC = Convert.ToDecimal(txt22c.Text); rates.twentyThreeC = Convert.ToDecimal(txt23c.Text); rates.silver = Convert.ToDecimal(txtSilver.Text); rates.date = DateTime.Now.Date; rates.createdDate = DateTime.Now; _entities.SaveChanges(); MessageBox.Show("Record SuccessFully Updated!"); clear(); } } } catch (Exception c) { } }
private void btnCreate_Click(object sender, EventArgs e) { try { if (txtGroupName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtGroupName, "Enter Group Name"); txtGroupName.Focus(); panel3.Visible = true; lblError.Text = "Enter Group Name."; } else { if (btnCreate.Text == "Create") { _entities = new MicroAccountsEntities1(); var data = _entities.tbl_AccGroup; foreach (var item in data) { if (item.groupName == txtGroupName.Text.Trim()) { errorProvider1.Clear(); errorProvider1.SetError(txtGroupName, "Group Name already exists!"); txtGroupName.Focus(); panel3.Visible = true; lblError.Text = "Group Name already exists!"; return; } } _entities = new MicroAccountsEntities1(); tbl_AccGroup accGroup = new tbl_AccGroup(); var max_id = _entities.tbl_AccGroup.OrderByDescending(x => x.id).FirstOrDefault().id; accGroup.id = max_id + 1; accGroup.groupName = txtGroupName.Text.Trim().ToString(); accGroup.parentId = Convert.ToInt32(cmbParentGroup.SelectedValue); accGroup.createdDate = DateTime.Now; accGroup.updateDate = DateTime.Now; long ggId = Convert.ToInt32(cmbParentGroup.SelectedValue); var affGross = _entities.tbl_AccGroup.Where(x => x.groupId == ggId).FirstOrDefault().affects_gross; if (affGross == 1) { accGroup.affects_gross = 1; } else { accGroup.affects_gross = 0; } _entities.tbl_AccGroup.Add(accGroup); _entities.SaveChanges(); MessageBox.Show("Record Saved Successfully!"); } else { _entities = new MicroAccountsEntities1(); var data = _entities.tbl_AccGroup; foreach (var item in data) { if (item.groupName == txtGroupName.Text.Trim() && txtGroupName.Text != lblhiddenGName.Text) { errorProvider1.Clear(); errorProvider1.SetError(txtGroupName, "Group Name already exists!"); txtGroupName.Focus(); panel3.Visible = true; lblError.Text = "Group Name already exists!"; return; } } _entities = new MicroAccountsEntities1(); var gId = Convert.ToInt32(lblHiddenId.Text); var dataToUpdate = _entities.tbl_AccGroup.Where(x => x.groupId == gId).FirstOrDefault(); dataToUpdate.groupName = txtGroupName.Text.Trim().ToString(); dataToUpdate.parentId = Convert.ToInt32(cmbParentGroup.SelectedValue); dataToUpdate.updateDate = DateTime.Now; _entities.SaveChanges(); MessageBox.Show("Record Updated Successfully!"); } DataGridSource(); ClearTextBox(); } } catch (Exception c) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
public void deleteBJ() { //Delete Data---------------------------------------------------------------- #region DailyRates //Delete Data From dataBase _entities = new MicroAccountsEntities1(); var data = _entities.DailyRates.ToList(); foreach (var item in data) { _entities.DailyRates.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_TransactionMaster //Delete Data From dataBase _entities = new MicroAccountsEntities1(); var data1 = _entities.tbl_TransactionMaster.ToList(); foreach (var item in data1) { _entities.tbl_TransactionMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_EntryDetails //Delete Data From dataBase _entities = new MicroAccountsEntities1(); var data2 = _entities.tbl_EntryDetails.ToList(); foreach (var item in data2) { _entities.tbl_EntryDetails.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_Entry //Delete Data From dataBase _entities = new MicroAccountsEntities1(); var data3 = _entities.tbl_Entry.ToList(); foreach (var item in data3) { _entities.tbl_Entry.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_PurchaseDetail _entities = new MicroAccountsEntities1(); var data4 = _entities.tbl_PurchaseDetail.ToList(); foreach (var item in data4) { _entities.tbl_PurchaseDetail.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_PurchaseMaster _entities = new MicroAccountsEntities1(); var data6 = _entities.tbl_PurchaseMaster.ToList(); foreach (var item in data6) { _entities.tbl_PurchaseMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_SalesDetails _entities = new MicroAccountsEntities1(); var data7 = _entities.tbl_SalesDetails.ToList(); foreach (var item in data7) { _entities.tbl_SalesDetails.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_SalesMaster _entities = new MicroAccountsEntities1(); var data8 = _entities.tbl_SalesMaster.ToList(); foreach (var item in data8) { _entities.tbl_SalesMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_StockItemDetails _entities = new MicroAccountsEntities1(); var data9 = _entities.tbl_StockItemDetails.ToList(); foreach (var item in data9) { _entities.tbl_StockItemDetails.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_ItemMaster _entities = new MicroAccountsEntities1(); var data10 = _entities.tbl_ItemMaster.ToList(); foreach (var item in data10) { _entities.tbl_ItemMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_CategoryMaster _entities = new MicroAccountsEntities1(); var data11 = _entities.tbl_CategoryMaster.ToList(); foreach (var item in data11) { _entities.tbl_CategoryMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_LedgerDetails _entities = new MicroAccountsEntities1(); var data12 = _entities.tbl_LedgerDetails.ToList(); foreach (var item in data12) { _entities.tbl_LedgerDetails.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_AccLedger _entities = new MicroAccountsEntities1(); var data13 = _entities.tbl_AccLedger.ToList(); foreach (var item in data13) { _entities.tbl_AccLedger.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_AccGroup _entities = new MicroAccountsEntities1(); var data14 = _entities.tbl_AccGroup.ToList(); foreach (var item in data14) { _entities.tbl_AccGroup.Remove(item); _entities.SaveChanges(); } #endregion }
public void BjAdipur() //Xml ma data banava mate { string str = Properties.Settings.Default.MicroAccountsConnectionString; cnn = new SqlConnection(str); cnn.Open(); #region DailyRates string strSQL = "Select * from DailyRates"; SqlDataAdapter dt = new SqlDataAdapter(strSQL, cnn); DataSet ds = new DataSet(); dt.Fill(ds, "DailyRates"); ds.WriteXml(File.OpenWrite(@"Data\DailyRates.xml")); #endregion #region tbl_AccGroup strSQL = "Select * from tbl_AccGroup"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_AccGroup"); ds.WriteXml(File.OpenWrite(@"Data\tbl_AccGroup.xml")); #endregion #region tbl_AccLedger strSQL = "Select * from tbl_AccLedger"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_AccLedger"); ds.WriteXml(File.OpenWrite(@"Data\tbl_AccLedger.xml")); cnn.Close(); #endregion #region tbl_CategoryMaster strSQL = "Select * from tbl_CategoryMaster"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_CategoryMaster"); ds.WriteXml(File.OpenWrite(@"Data\tbl_CategoryMaster.xml")); cnn.Close(); #endregion #region tbl_Entry strSQL = "Select * from tbl_Entry"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_AccLedger"); ds.WriteXml(File.OpenWrite(@"Data\tbl_Entry.xml")); cnn.Close(); #endregion #region tbl_EntryDetails strSQL = "Select * from tbl_EntryDetails"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_EntryDetails"); ds.WriteXml(File.OpenWrite(@"Data\tbl_EntryDetails.xml")); cnn.Close(); #endregion #region tbl_ItemMaster strSQL = "Select * from tbl_ItemMaster"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_ItemMaster"); ds.WriteXml(File.OpenWrite(@"Data\tbl_ItemMaster.xml")); cnn.Close(); #endregion #region tbl_LedgerDetails strSQL = "Select * from tbl_LedgerDetails"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_LedgerDetails"); ds.WriteXml(File.OpenWrite(@"Data\tbl_LedgerDetails.xml")); cnn.Close(); #endregion #region tbl_PurchaseDetail strSQL = "Select * from tbl_PurchaseDetail"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_PurchaseDetail"); ds.WriteXml(File.OpenWrite(@"Data\tbl_PurchaseDetail.xml")); cnn.Close(); #endregion #region tbl_PurchaseMaster strSQL = "Select * from tbl_PurchaseMaster"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_PurchaseMaster"); ds.WriteXml(File.OpenWrite(@"Data\tbl_PurchaseMaster.xml")); cnn.Close(); #endregion #region tbl_SalesDetails strSQL = "Select * from tbl_SalesDetails"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_SalesDetails"); ds.WriteXml(File.OpenWrite(@"Data\tbl_SalesDetails.xml")); cnn.Close(); #endregion #region tbl_SalesMaster strSQL = "Select * from tbl_SalesMaster"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_SalesMaster"); ds.WriteXml(File.OpenWrite(@"Data\tbl_SalesMaster.xml")); cnn.Close(); #endregion #region tbl_StockItemDetails strSQL = "Select * from tbl_StockItemDetails"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_StockItemDetails"); ds.WriteXml(File.OpenWrite(@"Data\tbl_StockItemDetails.xml")); cnn.Close(); #endregion #region tbl_TransactionMaster strSQL = "Select * from tbl_TransactionMaster"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_TransactionMaster"); ds.WriteXml(File.OpenWrite(@"Data\tbl_TransactionMaster.xml")); cnn.Close(); #endregion #region tbl_UserLogiln strSQL = "Select * from tbl_UserLogiln"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_UserLogiln"); ds.WriteXml(File.OpenWrite(@"Data\tbl_UserLogiln.xml")); cnn.Close(); #endregion #region tbl_UserProfile strSQL = "Select * from tbl_UserProfile"; dt = new SqlDataAdapter(strSQL, cnn); ds = new DataSet(); dt.Fill(ds, "tbl_UserProfile"); ds.WriteXml(File.OpenWrite(@"Data\tbl_UserProfile.xml")); cnn.Close(); #endregion //Delete Data---------------------------------------------------------------- #region DailyRates //Delete Data From dataBase _entities = new MicroAccountsEntities1(); var data = _entities.DailyRates.ToList(); foreach (var item in data) { _entities.DailyRates.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_TransactionMaster //Delete Data From dataBase _entities = new MicroAccountsEntities1(); var data1 = _entities.tbl_TransactionMaster.ToList(); foreach (var item in data1) { _entities.tbl_TransactionMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_EntryDetails //Delete Data From dataBase _entities = new MicroAccountsEntities1(); var data2 = _entities.tbl_EntryDetails.ToList(); foreach (var item in data2) { _entities.tbl_EntryDetails.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_Entry //Delete Data From dataBase _entities = new MicroAccountsEntities1(); var data3 = _entities.tbl_Entry.ToList(); foreach (var item in data3) { _entities.tbl_Entry.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_PurchaseDetail _entities = new MicroAccountsEntities1(); var data4 = _entities.tbl_PurchaseDetail.ToList(); foreach (var item in data4) { _entities.tbl_PurchaseDetail.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_PurchaseMaster _entities = new MicroAccountsEntities1(); var data6 = _entities.tbl_PurchaseMaster.ToList(); foreach (var item in data6) { _entities.tbl_PurchaseMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_SalesDetails _entities = new MicroAccountsEntities1(); var data7 = _entities.tbl_SalesDetails.ToList(); foreach (var item in data7) { _entities.tbl_SalesDetails.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_SalesMaster _entities = new MicroAccountsEntities1(); var data8 = _entities.tbl_SalesMaster.ToList(); foreach (var item in data8) { _entities.tbl_SalesMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_StockItemDetails _entities = new MicroAccountsEntities1(); var data9 = _entities.tbl_StockItemDetails.ToList(); foreach (var item in data9) { _entities.tbl_StockItemDetails.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_ItemMaster _entities = new MicroAccountsEntities1(); var data10 = _entities.tbl_ItemMaster.ToList(); foreach (var item in data10) { _entities.tbl_ItemMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_CategoryMaster _entities = new MicroAccountsEntities1(); var data11 = _entities.tbl_CategoryMaster.ToList(); foreach (var item in data11) { _entities.tbl_CategoryMaster.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_LedgerDetails _entities = new MicroAccountsEntities1(); var data12 = _entities.tbl_LedgerDetails.ToList(); foreach (var item in data12) { _entities.tbl_LedgerDetails.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_AccLedger _entities = new MicroAccountsEntities1(); var data13 = _entities.tbl_AccLedger.ToList(); foreach (var item in data13) { _entities.tbl_AccLedger.Remove(item); _entities.SaveChanges(); } #endregion #region tbl_AccGroup _entities = new MicroAccountsEntities1(); var data14 = _entities.tbl_AccGroup.ToList(); foreach (var item in data14) { _entities.tbl_AccGroup.Remove(item); _entities.SaveChanges(); } #endregion //#region tbl_UserLogiln //_entities = new MicroAccountsEntities1(); //var data15 = _entities.tbl_UserLogiln.ToList(); //foreach (var item in data15) //{ // _entities.tbl_UserLogiln.Remove(item); // _entities.SaveChanges(); //} //#endregion //#region tbl_UserProfile //_entities = new MicroAccountsEntities1(); //var data16 = _entities.tbl_UserLogiln.ToList(); //foreach (var item in data16) //{ // _entities.tbl_UserLogiln.Remove(item); // _entities.SaveChanges(); //} //#endregion }
private void btnCreate_Click(object sender, EventArgs e) { try { if (txtLedgerName.Text == string.Empty && txtNotes.Text == string.Empty && txtOpeningBal.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtLedgerName, "Enter all details."); txtLedgerName.Focus(); panel3.Visible = true; lblError.Text = "Enter all details."; } else if (txtLedgerName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtLedgerName, "Enter ledger-name"); txtLedgerName.Focus(); panel3.Visible = true; lblError.Text = "Enter ledger-name."; } else if (txtOpeningBal.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtOpeningBal, "Enter opening balance."); txtOpeningBal.Focus(); panel3.Visible = true; lblError.Text = "Enter opening balance."; } else { if (btnCreate.Text == "Create") { _entities = new MicroAccountsEntities1(); var gId = Convert.ToInt32(cmbParentGroup.SelectedValue); var checkData = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text.Trim().ToString() && x.groupId == gId).FirstOrDefault(); if (checkData != null) { MessageBox.Show("Ledger already Exists. Cannot create ledger with this name"); return; } tbl_AccLedger accLedgerData = new tbl_AccLedger(); accLedgerData.ledgerName = txtLedgerName.Text.Trim().ToString(); accLedgerData.groupId = Convert.ToInt32(cmbParentGroup.SelectedValue); accLedgerData.opBalance = Convert.ToDecimal(txtOpeningBal.Text); if (cmbDRCR.SelectedItem.ToString() == "Dr") { accLedgerData.opBalanceDC = "D"; } else { accLedgerData.opBalanceDC = "C"; } accLedgerData.notes = txtNotes.Text.Trim().ToString(); if (chkBankOrCash.Checked) { accLedgerData.type = 1; } else { accLedgerData.type = 0; } accLedgerData.createdDate = DateTime.Now; _entities.tbl_AccLedger.Add(accLedgerData); _entities.SaveChanges(); tbl_LedgerDetails ledgerDetails = new tbl_LedgerDetails(); if (txtAddress.Text.Trim() == string.Empty) { ledgerDetails.address = "--"; } else { ledgerDetails.address = txtAddress.Text.Trim().ToString(); } if (txtContact.Text == string.Empty) { ledgerDetails.contact = 0; } else { ledgerDetails.contact = Convert.ToDecimal(txtOpeningBal.Text); } ledgerDetails.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text && x.groupId == accLedgerData.groupId).FirstOrDefault().Id; ledgerDetails.createdDate = DateTime.Now; ledgerDetails.updateDate = DateTime.Now; _entities.tbl_LedgerDetails.Add(ledgerDetails); _entities.SaveChanges(); MessageBox.Show("Record Added Successfully"); } else { //Update Code _entities = new MicroAccountsEntities1(); var data = _entities.tbl_AccLedger.Where(x => x.Id == ledgerId).FirstOrDefault(); data.ledgerName = txtLedgerName.Text.Trim().ToString(); data.groupId = Convert.ToInt32(cmbParentGroup.SelectedValue); data.opBalance = Convert.ToDecimal(txtOpeningBal.Text); if (cmbDRCR.SelectedItem.ToString() == "Dr") { data.opBalanceDC = "D"; } else { data.opBalanceDC = "C"; } data.notes = txtNotes.Text.Trim().ToString(); data.updatedDate = DateTime.Now; _entities.SaveChanges(); var dataLedgerDetails = _entities.tbl_LedgerDetails.Where(x => x.ledgerId == ledgerId).FirstOrDefault(); dataLedgerDetails.address = txtAddress.Text.Trim().ToString(); dataLedgerDetails.contact = Convert.ToDecimal(txtContact.Text.Trim()); dataLedgerDetails.ledgerId = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text && x.groupId == data.groupId).FirstOrDefault().Id; dataLedgerDetails.updateDate = DateTime.Now; _entities.SaveChanges(); MessageBox.Show("Record Updated Successfully"); SupplierDetails ss = new SupplierDetails(); ss.dataGridBind(); } bindComboBox(); clearTextBox(); } } catch (Exception ex) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void btnRegister_Click(object sender, EventArgs e) { try { bool check = ValidateEmail(); EncryptionDecription enc; if (txtEmail.Text == string.Empty && txtF_name.Text == string.Empty && txtL_name.Text == string.Empty && txtUserName.Text == string.Empty && txtMobileNo.Text == string.Empty && txtNewPass.Text == string.Empty && txtConfirmPass.Text == string.Empty) { panel3.Visible = true; lblError.Text = "Enter all details."; txtEmail.Focus(); } else if (!check) { panel3.Visible = true; lblError.Text = txtEmail.Text + " is Invalid Email Address"; txtEmail.Focus(); } else if (txtEmail.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtEmail, "Enter Email Address"); txtEmail.Focus(); panel3.Visible = true; lblError.Text = "Enter Email Address."; } else if (txtF_name.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtF_name, "Enter First Name"); txtF_name.Focus(); panel3.Visible = true; lblError.Text = "Enter First Name."; } else if (txtL_name.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtL_name, "Enter Last Name"); txtL_name.Focus(); panel3.Visible = true; lblError.Text = "Enter Last Name."; } else if (txtUserName.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtUserName, "Enter User Name"); txtMobileNo.Focus(); panel3.Visible = true; lblError.Text = "Enter User Name."; } else if (txtMobileNo.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtMobileNo, "Enter Mobile Number"); txtMobileNo.Focus(); panel3.Visible = true; lblError.Text = "Enter Mobile Number."; } else if (txtNewPass.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtNewPass, "Enter Password"); txtNewPass.Focus(); panel3.Visible = true; lblError.Text = "Enter Password."; } else if (txtConfirmPass.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtConfirmPass, "Re-enter Password"); txtConfirmPass.Focus(); panel3.Visible = true; lblError.Text = "Re-enter Password."; } else if (txtConfirmPass.Text != txtNewPass.Text) { errorProvider1.Clear(); errorProvider1.SetError(txtConfirmPass, "Re-enter Password"); txtConfirmPass.Clear(); txtConfirmPass.Focus(); panel3.Visible = true; lblError.Text = "Password and Confirm Password does not match."; } else { if (btnRegister.Text == "Register") { _entities = new MicroAccountsEntities1(); tbl_UserProfile userProfile = new tbl_UserProfile(); userProfile.email = txtEmail.Text.Trim().ToString(); userProfile.firstName = txtF_name.Text.Trim().ToString(); userProfile.lastName = txtL_name.Text.Trim().ToString(); userProfile.mobile = Convert.ToInt64(txtMobileNo.Text.Trim().ToString()); userProfile.createdDate = DateTime.Now; userProfile.updateDate = DateTime.Now; _entities.tbl_UserProfile.Add(userProfile); _entities.SaveChanges(); _entities = new MicroAccountsEntities1(); tbl_UserLogiln userlogin = new tbl_UserLogiln(); userlogin.loginId = txtUserName.Text.Trim().ToString(); //encryption of password by calling method of the class called EncryptionDecryption enc = new EncryptionDecription(); // var encPass = enc.Encrypt(txtNewPass.Text.Trim().ToString(), "sblw-3hn8-sqoy19"); // var encPass = enc.Encrypt(txtNewPass.Text.Trim().ToString()); userlogin.password = txtNewPass.Text.Trim().ToString(); userlogin.userId = _entities.tbl_UserProfile.Where(x => x.firstName == txtF_name.Text && x.email == txtEmail.Text).FirstOrDefault().userId; userlogin.createdDate = DateTime.Now; userlogin.updateDate = DateTime.Now; _entities.tbl_UserLogiln.Add(userlogin); _entities.SaveChanges(); DataGridSource(); MessageBox.Show("Register SuccessFull!"); } else { _entities = new MicroAccountsEntities1(); enc = new EncryptionDecription(); var uId = Convert.ToInt32(hiddenUID.Text); var dataToUpdate = _entities.tbl_UserProfile.Where(x => x.userId == uId).FirstOrDefault(); dataToUpdate.firstName = txtF_name.Text.Trim().ToString(); dataToUpdate.lastName = txtL_name.Text.Trim().ToString(); dataToUpdate.email = txtEmail.Text.Trim().ToString(); dataToUpdate.mobile = Convert.ToDecimal(txtMobileNo.Text.Trim()); dataToUpdate.updateDate = DateTime.Now; foreach (var item in dataToUpdate.tbl_UserLogiln) { item.loginId = txtUserName.Text.Trim().ToString(); // item.password = enc.Encrypt(txtNewPass.Text.ToString(), "sblw-3hn8-sqoy19"); item.password = enc.Encrypt(txtNewPass.Text.ToString()); item.updateDate = DateTime.Now; _entities.SaveChanges(); } _entities.SaveChanges(); DataGridSource(); MessageBox.Show("Updated SuccessFull!"); } ClearTextBox(); } } catch (Exception ex) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void btnCreate_Click(object sender, EventArgs e) { byte[] pic = null; try { if (CaptureBox.Image != null) { MemoryStream stream = new MemoryStream(); CaptureBox.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg); pic = stream.ToArray(); } if (txtWeight.Text == string.Empty && txtMelting.Text == string.Empty && txtQty.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtWeight, "Enter all details."); txtWeight.Focus(); panel3.Visible = true; lblError.Text = "Enter all details."; } else if (txtWeight.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtWeight, "Enter weight."); txtWeight.Focus(); panel3.Visible = true; lblError.Text = "Enter weight."; } else if (txtQty.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtQty, "Enter qty."); txtQty.Focus(); panel3.Visible = true; lblError.Text = "Enter qty."; } else if (txtMelting.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtMelting, "Enter melting."); txtMelting.Focus(); panel3.Visible = true; lblError.Text = "Enter melting."; } //else if (CaptureBox.Image == null) //{ // errorProvider1.Clear(); // errorProvider1.SetError(CaptureBox, "Select Image."); // CaptureBox.Focus(); // panel3.Visible = true; // lblError.Text = "Select Image."; //} else { if (btnCreate.Text == "Create") { //insert Code _entities = new MicroAccountsEntities1(); tbl_ItemMaster itemMaster = new tbl_ItemMaster(); //itemMaster.categoryId = Convert.ToInt32(cmbItemCategory.SelectedValue); itemMaster.categoryId = Convert.ToInt32(cmbItemCategory.SelectedValue); itemMaster.photo = pic; itemMaster.itemCode = lblItemCode.Text; itemMaster.createdDate = DateTime.Now; _entities.tbl_ItemMaster.Add(itemMaster); _entities.SaveChanges(); tbl_StockItemDetails stockDetail = new tbl_StockItemDetails(); stockDetail.weight = Convert.ToDecimal(txtWeight.Text); if (cmbKarat.SelectedIndex > 0) { stockDetail.carret = Convert.ToDecimal(cmbKarat.Text); } else { stockDetail.carret = 0; } stockDetail.qty = Convert.ToDecimal(txtQty.Text); stockDetail.unit = cmbUnit.Text.ToString(); stockDetail.melting = Convert.ToDecimal(txtMelting.Text); stockDetail.remarks = txtRemarks.Text.Trim().ToString(); stockDetail.itemId = _entities.tbl_ItemMaster.OrderByDescending(x => x.id).FirstOrDefault().id; stockDetail.createdDate = DateTime.Now; stockDetail.upadtedDate = DateTime.Now; _entities.tbl_StockItemDetails.Add(stockDetail); _entities.SaveChanges(); MessageBox.Show("Record Successfully Saved!"); } else { //Update Code _entities = new MicroAccountsEntities1(); var itemData = (from a in _entities.tbl_ItemMaster join b in _entities.tbl_StockItemDetails on a.id equals b.itemId where a.id == itemIDGlobal select new { a, b }).FirstOrDefault(); itemData.a.categoryId = Convert.ToInt32(cmbItemCategory.SelectedValue); itemData.a.photo = pic; itemData.a.itemCode = lblItemCode.Text; itemData.a.updateDate = DateTime.Now; itemData.b.weight = Convert.ToDecimal(txtWeight.Text); if (cmbKarat.SelectedIndex > 0) { itemData.b.carret = Convert.ToDecimal(cmbKarat.Text); } else { itemData.b.carret = 0; } itemData.b.qty = Convert.ToDecimal(txtQty.Text); itemData.b.unit = cmbUnit.Text.ToString(); itemData.b.melting = Convert.ToDecimal(txtMelting.Text); itemData.b.remarks = txtRemarks.Text.Trim().ToString(); itemData.b.upadtedDate = DateTime.Now; _entities.SaveChanges(); MessageBox.Show("Record Successfully Updated!"); } clear(); } } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }