private void SetControlvalue() { BillDL _BillDL = new BillDL(); BillEL ObjBillEL = _BillDL.GetBillById(_BillEL.Bill_Id); datePkrBilldate.Value = ObjBillEL.Bill_Date; cmbBillType.SelectedValue = ObjBillEL.Bill_Type_Id; txtTaxAnount.Text = ObjBillEL.Tax_Percentage.ToString(); chkTaxInclusive.Checked = ObjBillEL.Is_Tax_Inclusive == (int)enumTaxinclusive.Yes ? true : false; }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == 9) // for print { BillEL objBillEL = new BillEL(); objBillEL.Bill_Id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["Bill_Id"].Value); BillReportViewer objBillReportViewer = new BillReportViewer(companyEL, objBillEL); objBillReportViewer.ShowDialog(); objBillReportViewer.Dispose(); } if (e.ColumnIndex == 10) //For Delete { if (Common.MessageConfim("Are You Want To Delete This ")) { SQLHelper objSQLHelper = new SQLHelper(); SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans(); BillDL objBillDL = new BillDL(); BillEL objBillEL = new BillEL(); objBillEL.Bill_Id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["Bill_Id"].Value); BillDetailDL objBillDetailDL = new BillDetailDL(); List <BillDetailEL> lstBillDetail = objBillDetailDL.GetBillDetailByBillId(objBillEL.Bill_Id); BillItemDL objBillItemDL = new BillItemDL(); List <BillItemEL> lstBillItemEL = objBillItemDL.GetBillItemByBillId(objBillEL.Bill_Id); BillItemNarrationDL _BillItemNarrationDL = new BillItemNarrationDL(); List <BillItemNarrationEL> lstBillItemNarration = new List <BillItemNarrationEL>(); try { lstBillItemEL.ForEach(r => lstBillItemNarration.AddRange(_BillItemNarrationDL.GetBillItemNarrationBy_BillItemId(r.Bill_Item_Id))); lstBillItemNarration.ForEach(n => _BillItemNarrationDL.Delete(objSqlTransaction, n)); lstBillDetail.ForEach(r => objBillDetailDL.Delete(objSqlTransaction, r)); lstBillItemEL.ForEach(r => objBillItemDL.Delete(objSqlTransaction, r)); objBillDL.Delete(objSqlTransaction, objBillEL); objSqlTransaction.Commit(); Common.MessageDelete(); GridBind(); } catch (Exception) { objSqlTransaction.Rollback(); } } } if (e.ColumnIndex == 11)//For bill Edit { BillDL _BillDL = new BillDL(); BillEL objBillEL = _BillDL.GetBillById(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["Bill_Id"].Value)); CreateBill objCreateBill = new CreateBill(companyEL, objBillEL); objCreateBill.ControlBox = true; objCreateBill.MinimizeBox = false; objCreateBill.ShowDialog(); GridBind(); } } catch { } }