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; }
void GridBind() { BillDL objBillDL = new BillDL(); List <BillEL> lstBill = objBillDL.GetBillByCompanyId(companyEL.Company_id); dataGridView1.Rows.Clear(); try { for (int i = 0; i < lstBill.Count; i++) { int index = dataGridView1.Rows.Add(); dataGridView1.Rows[index].Cells["Bill_Date"].Value = lstBill[i].Bill_Date.ToString("dd-MM-yyyy"); dataGridView1.Rows[index].Cells["Bill_Id"].Value = lstBill[i].Bill_Id; dataGridView1.Rows[index].Cells["Bill_No"].Value = lstBill[i].Bill_No; dataGridView1.Rows[index].Cells["Is_Tax_Inclusive"].Value = lstBill[i].Is_Tax_Inclusive == (int)enumTaxinclusive.Yes ? "yes" : "No"; dataGridView1.Rows[index].Cells["Tax_Name"].Value = lstBill[i].Tax_Name; dataGridView1.Rows[index].Cells["Tax_Percentage"].Value = lstBill[i].Tax_Percentage; dataGridView1.Rows[index].Cells["Cartage"].Value = lstBill[i].Cartage; dataGridView1.Rows[index].Cells["Discount"].Value = lstBill[i].Discount; switch (lstBill[i].Bill_Type_Id) { case (int)enumBillType.RetailInvoice_Jobwork: { dataGridView1.Rows[index].Cells["Bill_Type_Id"].Value = "Retail Invoice Jobwork"; break; } case (int)enumBillType.RetailInvoice_Sale: { dataGridView1.Rows[index].Cells["Bill_Type_Id"].Value = "Retail Invoice Sale"; break; } case (int)enumBillType.TaxInvoice_Jobwork: { dataGridView1.Rows[index].Cells["Bill_Type_Id"].Value = "Tax Invoice Jobwork"; break; } case (int)enumBillType.TaxInvoice_Sale: { dataGridView1.Rows[index].Cells["Bill_Type_Id"].Value = "Tax Invoice Sale"; break; } } } } catch { } }
private void btnUpdate_Click(object sender, EventArgs e) { BillEL objBillEL = new BillEL(); BillDL _BillDL = new BillDL(); try { objBillEL.Bill_Id = _BillEL.Bill_Id; objBillEL.Bill_Date = datePkrBilldate.Value; objBillEL.Bill_Type_Id = Convert.ToInt32(cmbBillType.SelectedValue); objBillEL.Is_Tax_Inclusive = chkTaxInclusive.Checked == true ? (int)enumTaxinclusive.Yes : (int)enumTaxinclusive.No; objBillEL.Tax_Percentage = Convert.ToDecimal(txtTaxAnount.Text); if (_BillDL.Update(objBillEL)) { Common.MessageUpdate(); } } catch (Exception) { } }
public BillBL() { billDL = new BillDL(); }
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 { } }
void CreateReport(string billType) { DisposeReport(); string PurchasesOrderNo = ""; string PurchasesOrderDate = ""; string DeliveryNo = ""; string DeliveryDate = ""; BillDetailDL objBillDetailDL = new BillDetailDL(); List <BillDetailEL> lstBillDetail = objBillDetailDL.GetBillDetailByBillId(billEL.Bill_Id); var qurPurchases = from b in lstBillingDelivertDetail join bd in lstBillDetail on b.Delivery_Detail_Id equals bd.Delivery_Detail_Id select new { b.Purchases_Order_Id, b.PURCHASES_ORDER_Date, b.Purchases_Order_No }; var qurDelivary = from b in lstBillingDelivertDetail join bd in lstBillDetail on b.Delivery_Detail_Id equals bd.Delivery_Detail_Id select new { b.Delivery_Id, b.Delivery_Date, b.Delivery_No }; foreach (var item in qurDelivary.Distinct()) { DeliveryNo += ", " + item.Delivery_No.Trim(); DeliveryDate += ", " + item.Delivery_Date.ToString("dd/MM/yyyy").Trim(); } foreach (var item in qurPurchases.Distinct()) { PurchasesOrderNo += ", " + item.Purchases_Order_No.Trim(); PurchasesOrderDate += ", " + item.PURCHASES_ORDER_Date.ToString("dd/MM/yyyy").Trim(); } if (qurDelivary.Distinct().Count() > 10) { DeliveryNo = ",As per attach challan copy"; DeliveryDate = ",As per attach challan copy"; } try { BillDL objBillDL = new BillDL(); DataSet ds = objBillDL.GetBillReportData(companyEL, billEL); //if ((int)ds.Tables["GetBillReportHeader"].Rows[0]["Bill_Type_Id"] == (int)enumBillType.RetailInvoice_Jobwork // || (int)ds.Tables["GetBillReportHeader"].Rows[0]["Bill_Type_Id"] == (int)enumBillType.TaxInvoice_Jobwork) //{ // objRpt = new CR_Bill(); // objRpt.SetDataSource(ds); // objRpt.SetParameterValue("Order_No", PurchasesOrderNo.Substring(1)); // objRpt.SetParameterValue("Order_Date", PurchasesOrderDate.Substring(1)); // objRpt.SetParameterValue("Challan_NO", DeliveryNo.Substring(1)); // objRpt.SetParameterValue("Challan_Date", DeliveryDate.Substring(1)); // objRpt.SetParameterValue("Bill_Type", billType); // if (companyEL.Company_Type_Id == (int)enumCompanyType.Delhi) // { // objRpt.SetParameterValue("Tin_No", " 07050294694"); // } // else if (companyEL.Company_Type_Id == (int)enumCompanyType.Noida) // { // objRpt.SetParameterValue("Tin_No", " 09165703716"); // } // crystalReportViewer1.ReportSource = objRpt; //} //else //{ objRptSale = new CR_Bill_Sale(); objRptSale.SetDataSource(ds); objRptSale.SetParameterValue("Order_No", PurchasesOrderNo.Substring(1)); objRptSale.SetParameterValue("Order_Date", PurchasesOrderDate.Substring(1)); objRptSale.SetParameterValue("Challan_NO", DeliveryNo.Substring(1)); objRptSale.SetParameterValue("Challan_Date", DeliveryDate.Substring(1)); objRptSale.SetParameterValue("Bill_Type", billType); if (companyEL.Company_Type_Id == (int)enumCompanyType.Delhi) { objRptSale.SetParameterValue("Tin_No", " 07050294694"); } else if (companyEL.Company_Type_Id == (int)enumCompanyType.Noida) { objRptSale.SetParameterValue("Tin_No", " 09165703716"); } crystalReportViewer1.ReportSource = objRptSale; //} } catch (Exception ex) { string dt = ex.Message; } }