private void btnSearch_Click(object sender, EventArgs e) { PurReturnGeneralReport objRet = new PurReturnGeneralReport(); rptViewer objView = new rptViewer(); objRet.SetParameterValue("@MinDate", txtMinDate.Text); objRet.SetParameterValue("@MaxDate", txtmaxdate.Text); PurchaseReturnBL objBl = new PurchaseReturnBL() { minDate = Convert.ToDateTime(txtMinDate.Text), maxDate = Convert.ToDateTime(txtmaxdate.Text) }; var dt = objBl.SearchByDateDiff(); if (dt != null) { objRet.SetDataSource(dt); objView.crptViewer.ReportSource = objRet; objView.WindowState = FormWindowState.Maximized; objView.ShowDialog(); } else { MessageBox.Show("No Record Found"); } //crptViewerPurchaseReturn.ReportSource = objRet; }
private void btnComName_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtComname.Text)) { PurReturnByComReport objRep = new PurReturnByComReport(); rptViewer objView = new rptViewer(); objRep.SetParameterValue("@ComID", txtComname.Text); PurchaseReturnBL objBl = new PurchaseReturnBL() { CompanyID = Convert.ToInt32(txtComname.Text) }; var dt = objBl.SearchByComId(); if (dt != null) { objRep.SetDataSource(dt); objView.crptViewer.ReportSource = objRep; objView.crptViewer.RefreshReport(); objView.WindowState = FormWindowState.Maximized; objView.ShowDialog(); } else { MessageBox.Show("No Record Found"); } //crptViewerPurchaseReturn.ReportSource = objRep; //crptViewerPurchaseReturn.RefreshReport(); } else if (!string.IsNullOrEmpty(txtInvoice.Text)) { PurReturnInvoiceReport objret = new PurReturnInvoiceReport(); rptViewer objView = new rptViewer(); objret.SetParameterValue("@PReturnID", txtInvoice.Text); PurchaseReturnBL objBl = new PurchaseReturnBL() { PReturnID = Convert.ToInt32(txtInvoice.Text) }; var dt = objBl.SearchByInovice(); if (dt != null) { objret.SetDataSource(dt); objView.crptViewer.ReportSource = objret; objView.crptViewer.RefreshReport(); objView.WindowState = FormWindowState.Maximized; objView.ShowDialog(); } else { MessageBox.Show("No Record Found"); } //crptViewerPurchaseReturn.ReportSource = objret; //crptViewerPurchaseReturn.RefreshReport(); } }
private void btnNew_Click(object sender, EventArgs e) { PurchaseReturnBL objAdd = new PurchaseReturnBL(); DataTable dt = objAdd.Addnew(); if (dt.Rows.Count > 0) { txtReturnID.Text = Convert.ToString(dt.Rows[0]["PReturnID"]); FormEnable(); txtInvoiceID.Focus(); LoadGridProd(); btnNew.Enabled = false; } }
//private void SumDetailProduct() //{ // decimal sum = 0; // for (int i = 0; i < dgvProduct.Rows.Count; ++i) // { // sum += Convert.ToDecimal(resultTP); // } // resultGrand = Convert.ToDecimal(sum.ToString()); //} private void btnSave_Click(object sender, EventArgs e) { SaleInvoiceBL objProd = new SaleInvoiceBL(); for (int i = 0; i < dgvProduct.Rows.Count; ++i) { objProd.ProductID = Convert.ToInt32(dgvProduct.Rows[i].Cells[1].Value.ToString()); objProd.Quantity = Convert.ToInt32(dgvProduct.Rows[i].Cells[6].Value.ToString()); objProd.UpdateProd(); } PurchaseReturnBL objCtn = new PurchaseReturnBL(); for (int i = 0; i < dgvProduct.Rows.Count; ++i) { objCtn.ProductID = Convert.ToInt32(dgvProduct.Rows[i].Cells[1].Value.ToString()); objCtn.Ctn = Convert.ToDecimal(dgvProduct.Rows[i].Cells[5].Value.ToString()); objCtn.CtnUpdate(); } SaleInvoiceBL objsale = new SaleInvoiceBL(); decimal Ssum = 0; for (int i = 0; i < dgvProduct.Rows.Count; ++i) { objsale.InvoiceNo = Convert.ToInt32(txtInvoiceID.Text); objsale.ProductID = Convert.ToInt32(dgvProduct.Rows[i].Cells[1].Value.ToString()); objsale.Ctn = Convert.ToDecimal(dgvProduct.Rows[i].Cells[5].Value.ToString()); objsale.Quantity = Convert.ToInt32(dgvProduct.Rows[i].Cells[6].Value.ToString()); objsale.Discount = Convert.ToDecimal(dgvProduct.Rows[i].Cells[7].Value.ToString()); objsale.TotalAmount = Convert.ToDecimal(dgvProduct.Rows[i].Cells[8].Value.ToString()); decimal TP = Convert.ToDecimal(dgvProduct.Rows[i].Cells[3].Value.ToString()); objsale.RP = Convert.ToDecimal(dgvProduct.Rows[i].Cells[4].Value); decimal resultRP = (objsale.RP * objsale.Ctn) - objsale.Discount; decimal resultTP = (TP * objsale.Ctn); decimal detailP = Convert.ToDecimal(resultRP - resultTP); objsale.DetailProfit = detailP; Ssum += resultTP; objsale.SaveDetail(); } decimal grandtotal = Convert.ToDecimal(txtGrandTotal.Text); decimal InvoiceProfit = grandtotal - Ssum; SaleInvoiceBL objmas = new SaleInvoiceBL() { SaleDate = DateTime.Parse(txtInvoiceDate.Text), GrandTotal = Convert.ToDecimal(txtGrandTotal.Text), CustomerID = Convert.ToInt32(txtCusId.Text), Payment = Convert.ToDecimal(txtTotalPay.Text), DuePayment = Convert.ToDecimal(txtDuePay.Text), OrderBy = txtSalesman.Text, MasterProfit = InvoiceProfit }; objmas.SaveMaster(); SaleLedgerBL objLedger = new SaleLedgerBL(); objLedger.Invoiceno = Convert.ToInt32(txtInvoiceID.Text); objLedger.CustomerID = Convert.ToInt32(txtCusId.Text); objLedger.Credit = Convert.ToDecimal(txtDuePay.Text); objLedger.Debit = 0; objLedger.Date = Convert.ToDateTime(txtInvoiceDate.Text); objLedger.Balance = Convert.ToDecimal(txtnewBalance.Text); objLedger.Description = "Credit"; objLedger.Save(); (new SaleLedgerBL()).UpdateBalance(objLedger.Balance, objLedger.CustomerID); saleInvoiceReport objSale = new saleInvoiceReport(); rptViewer objview = new rptViewer(); //objSale.SetDataSource =; objSale.SetParameterValue("@InvoiceNo", txtInvoiceID.Text); SaleInvoiceBL obj = new SaleInvoiceBL() { InvoiceNo = Convert.ToInt32(txtInvoiceID.Text) }; DataTable dt = obj.Search(); if (dt.Rows.Count > 0) { objSale.SetDataSource(dt); } objview.crptViewer.ReportSource = objSale; objview.WindowState = FormWindowState.Normal; objview.ShowDialog(); ClearForm(); dgvProduct.DataSource = null; btnNew.Enabled = true; }
private void btnSave_Click(object sender, EventArgs e) { PurchaseReturnBL objUpdate = new PurchaseReturnBL(); { for (int i = 0; i < dgvReturnItem.Rows.Count; i++) { objUpdate.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[1].Value.ToString()); objUpdate.Quantity = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[5].Value.ToString()); objUpdate.ProdUpdate(); } } PurchaseReturnBL objCtn = new PurchaseReturnBL(); { for (int i = 0; i < dgvReturnItem.Rows.Count; i++) { objCtn.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[1].Value.ToString()); objCtn.Ctn = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[4].Value.ToString()); objCtn.CtnUpdate(); } } PurchaseReturnBL objDetail = new PurchaseReturnBL(); { for (int i = 0; i < dgvReturnItem.Rows.Count; i++) { objDetail.PReturnID = Convert.ToInt32(txtReturnID.Text); objDetail.ProductID = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[1].Value.ToString()); objDetail.TP = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[3].Value.ToString()); objDetail.Ctn = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[4].Value.ToString()); objDetail.Quantity = Convert.ToInt32(dgvReturnItem.Rows[i].Cells[5].Value.ToString()); objDetail.Amount = Convert.ToDecimal(dgvReturnItem.Rows[i].Cells[6].Value.ToString()); objDetail.SaveDetail(); } } if (txtBalance.Text != "0.00") { PurRemainBL objPurc = new PurRemainBL() { CompanyID = Convert.ToInt32(txtComID.Text), ReturnCash = Convert.ToDecimal(txtBalance.Text), Date = Convert.ToDateTime(txtReturnDate.Text), PReturnID = Convert.ToInt32(txtReturnID.Text) }; objPurc.Save(); } PurchaseReturnBL objMas = new PurchaseReturnBL() { PInvoice = Convert.ToInt32(txtInvoiceID.Text), CompanyID = Convert.ToInt32(txtComID.Text), Discount = Convert.ToDecimal(txtBillDiscount.Text), ReturnDate = DateTime.Parse(txtReturnDate.Text), TotalAmount = Convert.ToDecimal(txtGrandTotal.Text), ReturnCash = Convert.ToDecimal(txtReturnCash.Text), DuePayment = Convert.ToDecimal(txtBalance.Text), furDiscount = Convert.ToDecimal(txtfurDiscount.Text), GrandTotal = Convert.ToDecimal(txtGrandTotal.Text) }; objMas.SaveMaster(); PurchaseLedgerBL objLedger = new PurchaseLedgerBL(); objLedger.PReturnID = Convert.ToInt32(txtReturnID.Text); objLedger.CompanyID = Convert.ToInt32(txtComID.Text); objLedger.Credit = 0; objLedger.Debit = Convert.ToDecimal(txtBalance.Text); objLedger.Date = Convert.ToDateTime(txtReturnDate.Text); objLedger.Balance = Convert.ToDecimal(txtNewBalance.Text); objLedger.Description = "Credit"; objLedger.save(); (new PurchaseLedgerBL()).UpdateBalance(objLedger.Balance, objLedger.CompanyID); ClearForm(); btnNew.Enabled = true; // DesignClear(this); }