private void GenerateItemWiseReport() { List <CSOMaster> oListSOMaster = LoadItemWiseSales(); POS posdateset = new POS(); DataTable dtDailySale = posdateset.DailySales; foreach (CSOMaster oSOMaster in oListSOMaster) { foreach (CSODetails oSODetails in oSOMaster.SOMstr_DetailsList) { DataRow drDailySale = dtDailySale.NewRow(); //drDailySale["InvoiceNo"] = dr1["InvoiceNo"]; drDailySale["BranchName"] = oSOMaster.SOMstr_Branch; drDailySale["Address"] = currentBranch.CompBrn_Street; drDailySale["Road"] = currentBranch.CompBrn_Road; drDailySale["City"] = currentBranch.CompBrn_City; drDailySale["Phone"] = currentBranch.CompBrn_Phone; drDailySale["Mobile"] = currentBranch.CompBrn_Mobile; drDailySale["ItemName"] = oSODetails.SODet_ItemName; drDailySale["Qty"] = oSODetails.SODet_QTY; drDailySale["Rate"] = oSODetails.SODet_Price; drDailySale["Amount"] = oSODetails.SODet_Amount; drDailySale["TotalAmount"] = oSOMaster.SOMstr_TotalAmt; drDailySale["DiscAmount"] = oSOMaster.SOMstr_DiscAmt; drDailySale["NetAmount"] = oSOMaster.SOMstr_NetAmt; dtDailySale.Rows.Add(drDailySale); } } rptItemWiseSales orpt = new rptItemWiseSales(); orpt.SetDataSource(posdateset); orpt.SetParameterValue(0, currentBranch.CompBrn_Name.Trim()); orpt.SetParameterValue(1, dtpDateFrom2.Value.Date); orpt.SetParameterValue(2, dtpDateTo2.Value.Date); // orpt.SetParameterValue(3, cmbItemName.SelectedText.ToString()); // orpt.SetParameterValue(1, currentUser.User_UserName.Trim()); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = orpt; // orptviewer.AutoSize = false; orptviewer.Show(); ofrmReportView.Show(); //crystalReportViewer1.ReportSource = orpt; //crystalReportViewer1.Show(); }
private void ShowReport() { POS posdataset = new POS(); DataTable stickertbl = (DataTable)posdataset.StickerPrint; for (int i = 0; i < lvItem.Items.Count; i++) { for (int j = 0; j < Convert.ToInt32(lvItem.Items[i].SubItems[2].Text); j++) { DataRow row = stickertbl.NewRow(); row["ItemCode"] = "*" + lvItem.Items[i].SubItems[0].Text + "*"; row["ItemName"] = lvItem.Items[i].SubItems[1].Text; row["Price"] = lvItem.Items[i].SubItems[3].Text; stickertbl.Rows.Add(row); } //POS posdataset = new POS(); //DataTable stickertbl = (DataTable)posdataset.StickerPrint; //for (int i = 0; i < lvItem.Items.Count; i++) //{ // for (int j = 0; j < Convert.ToInt32(lvItem.Items[i].SubItems[2].Text); j++) // { // DataRow row = stickertbl.NewRow(); // row["ItemCode"] = "*" + lvItem.Items[i].SubItems[0].Text + "*"; // string[] itemarray = lvItem.Items[i].SubItems[1].Text.Split('-'); // try // { // row["ItemName"] = itemarray[0].ToString(); // row["Code"] = itemarray[1].ToString(); // row["Size"] = itemarray[3].ToString(); // } // catch (Exception ex) // { // } // row["Price"] = lvItem.Items[i].SubItems[3].Text; // stickertbl.Rows.Add(row); // } } rptSticker objrpt = new rptSticker(); objrpt.SetDataSource(stickertbl); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = objrpt; orptviewer.AutoSize = false; orptviewer.Show(); ofrmReportView.Show(); }
private void GenerateInvoiceReport(CSOMaster oSOMaster) { POS posdateset = new POS(); DataTable dtInv = posdateset.Invoice; foreach (CSODetails oSODetails in oSOMaster.SOMstr_DetailsList) { DataRow drInv = dtInv.NewRow(); drInv["BranchName"] = currentBranch.CompBrn_Name; drInv["Address"] = currentBranch.CompBrn_Street; drInv["RoadNo"] = currentBranch.CompBrn_Road; drInv["City"] = currentBranch.CompBrn_City; drInv["Phone"] = currentBranch.CompBrn_Phone; drInv["InvoiceNo"] = oSOMaster.SOMstr_Code; drInv["VatClnNo"] = oSOMaster.SOMstr_VatClnNo; drInv["ItemName"] = oSODetails.SODet_ItemName; drInv["Qty"] = oSODetails.SODet_QTY; drInv["Price"] = oSODetails.SODet_Price; drInv["Amount"] = oSODetails.SODet_Amount; drInv["Discount"] = oSODetails.SODet_Discount; drInv["VATValue"] = oSODetails.SODet_VATValue; dtInv.Rows.Add(drInv); } rptInvoice objrptInvoice = new rptInvoice(); objrptInvoice.SetDataSource(dtInv); objrptInvoice.SetParameterValue(0, float.Parse(txtDiscountAmount.Text.Trim())); objrptInvoice.SetParameterValue(1, currentUser.User_UserName.Trim()); objrptInvoice.SetParameterValue(2, txtCustomerPaid.Text.Trim()); objrptInvoice.SetParameterValue(3, txtChange.Text.Trim()); if (InvoiceRawKind == 0) { PrintDocument pd = new PrintDocument(); pd.DefaultPageSettings.PaperSize = new System.Drawing.Printing.PaperSize("POS", 4, 4); InvoiceRawKind = (int)pd.PrinterSettings.DefaultPageSettings.PaperSize.RawKind; } objrptInvoice.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)InvoiceRawKind; objrptInvoice.PrintToPrinter(1, true, 1, 1); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = objrptInvoice; orptviewer.AutoSize = false; orptviewer.Show(); ofrmReportView.Show(); }
private void btnPreview_Click(object sender, EventArgs e) { // ShowReport(); rptProfitAndLoss obj = new rptProfitAndLoss(); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = obj; orptviewer.Show(); ofrmReportView.Show(); }
private void ShowImportedDataasRpt(List <CSOMaster> oListSOMaster) { POS posdateset = new POS(); DataTable dtDailySale = posdateset.DailySales; foreach (CSOMaster oSOMaster in oListSOMaster) { foreach (CSODetails oSODetails in oSOMaster.SOMstr_DetailsList) { DataRow drDailySale = dtDailySale.NewRow(); drDailySale["BranchName"] = oSOMaster.SOMstr_Branch; drDailySale["Address"] = currentBranch.CompBrn_Street; drDailySale["Road"] = currentBranch.CompBrn_Road; drDailySale["City"] = currentBranch.CompBrn_City; drDailySale["Phone"] = currentBranch.CompBrn_Phone; drDailySale["Mobile"] = currentBranch.CompBrn_Mobile; drDailySale["ItemName"] = oSODetails.SODet_ItemName; drDailySale["Qty"] = oSODetails.SODet_QTY; drDailySale["Rate"] = oSODetails.SODet_Price; drDailySale["Amount"] = oSODetails.SODet_Amount; drDailySale["TotalAmount"] = oSOMaster.SOMstr_TotalAmt; drDailySale["DiscAmount"] = oSOMaster.SOMstr_DiscAmt; drDailySale["NetAmount"] = oSOMaster.SOMstr_NetAmt; dtDailySale.Rows.Add(drDailySale); } } rptDailySales orpt = new rptDailySales(); orpt.SetDataSource(posdateset); orpt.SetParameterValue(0, currentBranch.CompBrn_Name.Trim()); orpt.SetParameterValue(1, oListSOMaster[0].SOMstr_Date.Date); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = orpt; // orptviewer.AutoSize = false; orptviewer.Show(); ofrmReportView.Show(); //crystalReportViewer1.ReportSource = orpt; //crystalReportViewer1.Show(); }
private void ShowReport() { List <CReturnItem> oListCReturnItem = new List <CReturnItem>(); //List<CSOMaster> oListSOMasterretu = new List<CSOMaster>(); CSOBO oCSOBO = new CSOBO(); CResult oResult = new CResult(); DateTime date = dtpDate.Value.Date; oListCReturnItem = oCSOBO.ReadSalesReturn(dtpDate.Value.Date, ddlRptBranch.SelectedItem.ToString());// currentBranch.CompBrn_Code); //oListCReturnItem.Add(oListSOMasterretu); New oPosDataSet11 = new New(); DataTable dtReturn = oPosDataSet11.ReturnItems; //foreach (CSOMaster oSoMaster in oListSOMasterretu) //{ //oListCReturnItem.Add(oSoMaster); //} foreach (CReturnItem oSoDetail in oListCReturnItem) { DataRow odr = dtReturn.NewRow(); odr["ItemName"] = oSoDetail.ItemName; odr["Ret_QTY"] = oSoDetail.Ret_QTY; odr["ItemPrice"] = float.Parse(oSoDetail.ItemPrice.ToString()); odr["BranchName"] = oSoDetail.Ret_BranchOID; odr["Ret_DiscountAmount"] = oSoDetail.Ret_DiscountAmount; odr["ReturnDate"] = oSoDetail.date; dtReturn.Rows.Add(odr); } ETLPOS.Reports.ReturnReport orpt = new ETLPOS.Reports.ReturnReport(); orpt.SetDataSource(oPosDataSet11); //orpt.SetParameterValue(0, currentBranch.CompBrn_OId.Trim()); orpt.SetParameterValue(0, dtpDate.Value.Date); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = orpt; // orptviewer.AutoSize = false; orptviewer.Show(); ofrmReportView.Show(); //crystalReportViewer1.ReportSource = orpt; //crystalReportViewer1.Show(); }
//Report Stock Details----------- private void ReportStockDetails() { CSOBO oCSOBO = new CSOBO(); CResult oResult = new CResult(); oResult = oCSOBO.ReportStockDatials(currentBranch.CompBrn_OId.Trim()); if (oResult.IsSuccess) { DataSet ds = (DataSet)oResult.Data; POS posdateset = new POS(); DataTable dtStockDetail = posdateset.StockDetail; foreach (DataRow dr1 in ds.Tables[0].Rows) { DataRow drStockDetail = dtStockDetail.NewRow(); drStockDetail["ItemName"] = dr1["Item_ItemName"]; drStockDetail["Qty"] = dr1["QTY"]; drStockDetail["Pprice"] = dr1["Pprice"]; drStockDetail["Sprice"] = dr1["Price"]; drStockDetail["ItemGroupCode"] = dr1["Item_GroupID"]; drStockDetail["ItemGroupName"] = dr1["CatCode"]; drStockDetail["ItemCode"] = dr1["Item_Code"]; dtStockDetail.Rows.Add(drStockDetail); } rptStockDetails oStockrpt = new rptStockDetails(); oStockrpt.SetDataSource(dtStockDetail); oStockrpt.SetParameterValue(0, currentBranch.CompBrn_Branch.Trim()); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = oStockrpt; orptviewer.Show(); ofrmReportView.Show(); } else { MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void PopulateReport() { CSOBO oCSOBO = new CSOBO(); CResult oResult = new CResult(); oResult = oCSOBO.DailyCurrentStockReport(currentBranch.CompBrn_OId.Trim()); if (oResult.IsSuccess) { DataSet ds = (DataSet)oResult.Data; POS posdateset = new POS(); DataTable dtDailySale = posdateset.Stock; foreach (DataRow dr1 in ds.Tables[0].Rows) { DataRow drDailySale = dtDailySale.NewRow(); drDailySale["Qty"] = dr1["Qty"]; drDailySale["ItemName"] = dr1["ItemName"]; drDailySale["Invtype"] = Enum.GetName(typeof(EInvType), dr1["Invt_InvType"]); dtDailySale.Rows.Add(drDailySale); } rptCurrStock oStockrpt = new rptCurrStock(); oStockrpt.SetDataSource(dtDailySale); oStockrpt.SetParameterValue(0, currentUser.User_UserName.Trim()); oStockrpt.SetParameterValue(1, currentBranch.CompBrn_Branch.Trim()); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = oStockrpt; orptviewer.Show(); ofrmReportView.Show(); } else { MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button2_Click(object sender, EventArgs e) { if (txtMenoNo.Text != "") { CSOBO oSoBo = new CSOBO(); List <CSOMaster> oSoMasterList = oSoBo.GetMemoData((txtMenoNo.Tag as CSOMaster).SOMstr_Code, (txtMenoNo.Tag as CSOMaster).SOMstr_Date, currentBranch.CompBrn_Branch); POS oPosDataSet = new POS(); DataTable oDt = oPosDataSet.Tables["MemoReprint"]; foreach (CSOMaster oSoMaster in oSoMasterList) { DataRow odr = oDt.NewRow(); odr["BranchName"] = oSoMaster.SOMstr_Branch; odr["MemoNo"] = oSoMaster.SOMstr_Code; odr["MemoDate"] = oSoMaster.SOMstr_Date; odr["Discount"] = int.Parse(oSoMaster.SOMstr_DiscAmt.ToString()); foreach (CSODetails oSoDetail in oSoMaster.SOMstr_DetailsList) { odr["ItemName"] = oSoDetail.SODet_ItemName; odr["Qty"] = oSoDetail.SODet_QTY; odr["Price"] = float.Parse(oSoDetail.SODet_Price.ToString()); odr["Amount"] = float.Parse(oSoDetail.SODet_SDAmount.ToString()); } oDt.Rows.Add(odr); } txtMenoNo.Text = ""; rptMemoReprint orptMemoReprint = new rptMemoReprint(); orptMemoReprint.SetDataSource(oPosDataSet); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer oCristalReportViewer = (CrystalReportViewer)ofrmReportView.Controls["rptViewer"]; oCristalReportViewer.ReportSource = orptMemoReprint; oCristalReportViewer.Show(); ofrmReportView.Show(); } }
private void ShowReport() { #region 1 List <CSOMaster> oListSOMaster = LoadSOData(); POS posdateset = new POS(); DataTable dtDailySale = posdateset.DailySales; foreach (CSOMaster oSOMaster in oListSOMaster) { int i = 0; foreach (CSODetails oSODetails in oSOMaster.SOMstr_DetailsList) { DataRow drDailySale = dtDailySale.NewRow(); //drDailySale["InvoiceNo"] = dr1["InvoiceNo"]; drDailySale["BranchName"] = oSOMaster.SOMstr_Branch; drDailySale["Address"] = currentBranch.CompBrn_Street; drDailySale["Road"] = currentBranch.CompBrn_Road; drDailySale["City"] = currentBranch.CompBrn_City; drDailySale["Phone"] = currentBranch.CompBrn_Phone; drDailySale["Mobile"] = currentBranch.CompBrn_Mobile; drDailySale["ItemName"] = oSODetails.SODet_ItemName; drDailySale["Qty"] = oSODetails.SODet_QTY; drDailySale["Rate"] = oSODetails.SODet_Price; drDailySale["Amount"] = oSODetails.SODet_Amount; drDailySale["TotalAmount"] = oSOMaster.SOMstr_TotalAmt; if (i == 0) { drDailySale["DiscAmount"] = oSOMaster.SOMstr_DiscAmt; } if (i != 0) { drDailySale["DiscAmount"] = 0; } drDailySale["NetAmount"] = oSOMaster.SOMstr_NetAmt; drDailySale["PPrice"] = oSODetails.SODet_PPrice; dtDailySale.Rows.Add(drDailySale); i++; } } #endregion List <CReturnItem> oListCReturnItem = new List <CReturnItem>(); //List<CSOMaster> oListSOMasterretu = new List<CSOMaster>(); CSOBO oCSOBO = new CSOBO(); CResult oResult = new CResult(); DateTime date = dtpDate.Value.Date; oListCReturnItem = oCSOBO.ReadSalesReturn(dtpDate.Value.Date, currentBranch.CompBrn_Code); //oListCReturnItem.Add(oListSOMasterretu); New PosDataSet11 = new New(); DataTable dtReturn = PosDataSet11.ReturnItems; //foreach (CSOMaster oSoMaster in oListSOMasterretu) //{ //oListCReturnItem.Add(oSoMaster); //} foreach (CReturnItem oSoDetail in oListCReturnItem) { DataRow odr = dtReturn.NewRow(); odr["ItemName"] = oSoDetail.ItemName; odr["Ret_QTY"] = oSoDetail.Ret_QTY; odr["ItemPrice"] = float.Parse(oSoDetail.ItemPrice.ToString()); odr["BranchName"] = oSoDetail.Ret_BranchOID; odr["Ret_DiscountAmount"] = oSoDetail.Ret_DiscountAmount; //odr["ReturnDate"] = oSoDetail.date; dtReturn.Rows.Add(odr); } //ReturnReport re = new ReturnReport(); //re.SetDataSource(PosDataSet11); rptDailySales orpt = new rptDailySales(); orpt.SetDataSource(posdateset); //orpt.Load("ReturnReport.rpt"); orpt.OpenSubreport("ReturnReport.rpt").SetDataSource(PosDataSet11); orpt.SetParameterValue(0, currentBranch.CompBrn_Name.Trim()); orpt.SetParameterValue(1, dtpDate.Value.Date); frmReportView ofrmReportView = new frmReportView(); CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"]; orptviewer.ReportSource = orpt; // orptviewer.AutoSize = false; orptviewer.Show(); ofrmReportView.Show(); //crystalReportViewer1.ReportSource = orpt; //crystalReportViewer1.Show(); }