Exemple #1
0
        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
            {
            }
        }
Exemple #2
0
        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;
            }
        }