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
{
}
}