private void sellProductToolStripMenuItem_Click(object sender, EventArgs e) { SalesRegister go = new SalesRegister(); go.MdiParent = this; go.Show(); }
private void button1_Click(object sender, EventArgs e) { SalesRegister sr = new SalesRegister(); Console.WriteLine(); }
private void salesRegistertoolStripStatus_Click(object sender, EventArgs e) { SalesRegister go = new SalesRegister(); go.MdiParent = this; go.Show(); }
private void saleRegisterBarcodeScannerToolStripMenuItem_Click(object sender, EventArgs e) { SalesRegister go = new SalesRegister(); go.MdiParent = this; go.Show(); // statusStrip1.Dock = System.Windows.Forms.DockStyle.Bottom; }
public OrderProcessorTest() { priceList = new PriceList(); salesData = new SalesData(); salesRegister = new SalesRegister(salesData, priceList); mockNotifier = new Mock <EmailNotifier>(); mockChecker = new Mock <BeverageQuantityChecker>(); orderProcessor = new OrderProcessor(priceList, salesRegister, mockNotifier.Object, mockChecker.Object); }
public void ShouldPrintSalesReportCapturingAllValidSales() { var priceList = new PriceList(); var salesData = new SalesData(); var salesRegister = new SalesRegister(salesData, priceList); var mockNotifier = new Mock <EmailNotifier>(); var mockChecker = new Mock <BeverageQuantityChecker>(); var orderProcessor = new OrderProcessor(priceList, salesRegister, mockNotifier.Object, mockChecker.Object); var customerOrder = new CustomerOrder(Drink.OrangeJuice); var customerOrder1 = new CustomerOrder(Drink.Coffee, temputure: (int)DrinkTemputure.Hot); var customerOrder2 = new CustomerOrder(Drink.Chocolate, 2); var customerOrder3 = new CustomerOrder(Drink.Tea, 2); orderProcessor.HandleOrder(customerOrder, (decimal)0.60); orderProcessor.HandleOrder(customerOrder1, (decimal)0.60); orderProcessor.HandleOrder(customerOrder2, (decimal)0.20); orderProcessor.HandleOrder(customerOrder3, (decimal)0.60); var salesReporter = new SalesReporter(salesData); var result = salesReporter.GenerateReport(); Assert.Equal("Coffee: 1\nTea: 1\nHot Chocolate: 0\nOrange Juice: 1\n\nTotal Sales: $1.60", result); }
public ActionResult Print(DateTime?from, DateTime?to) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "SalesAnalysisProductWise.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("From"); ds.Tables["Head"].Columns.Add("To"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("SO.NO"); ds.Tables["Items"].Columns.Add("WorkDescr"); ds.Tables["Items"].Columns.Add("Qty"); ds.Tables["Items"].Columns.Add("Amount"); ds.Tables["Items"].Columns.Add("per"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = from.Value.ToShortDateString(); dr["To"] = to.Value.ToShortDateString(); dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); SalesRegisterRepository repo1 = new SalesRegisterRepository(); //var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName); var Items = repo1.GetSalesAnalysisProductWiseDTPrint(from, to, OrganizationId); foreach (var item in Items) { var SupplyOrderRegItem = new SalesRegister { SaleOrderRefNo = item.SaleOrderRefNo, WorkDescrShortName = item.WorkDescrShortName, Quantity = item.Quantity, Amount = item.Amount, Perc = item.Perc, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["SO.NO"] = SupplyOrderRegItem.SaleOrderRefNo; dri["WorkDescr"] = SupplyOrderRegItem.WorkDescrShortName; dri["Qty"] = SupplyOrderRegItem.Quantity; dri["Amount"] = SupplyOrderRegItem.Amount; dri["per"] = SupplyOrderRegItem.Perc; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "SalesAnalysisProductWise.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", String.Format("SalesAnalysisProductWise.pdf"))); } catch (Exception ex) { throw; } }
public ActionResult Print(int?project, DateTime?from, DateTime?to, int id = 0, string name = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "SalesRegister.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("From"); ds.Tables["Head"].Columns.Add("To"); ds.Tables["Head"].Columns.Add("Customer"); ds.Tables["Head"].Columns.Add("type"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("SalesInvoiceRefNo"); ds.Tables["Items"].Columns.Add("Date"); ds.Tables["Items"].Columns.Add("CustomerName"); ds.Tables["Items"].Columns.Add("WorkDescr"); ds.Tables["Items"].Columns.Add("Quantity"); ds.Tables["Items"].Columns.Add("Rate"); ds.Tables["Items"].Columns.Add("Amount"); ds.Tables["Items"].Columns.Add("Discount"); ds.Tables["Items"].Columns.Add("Unit"); ds.Tables["Items"].Columns.Add("TotalAmount"); SupplyOrderRegisterRepository repo = new SupplyOrderRegisterRepository(); var Head = repo.GetSupplyOrderRegisterHD(from, to, OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = from.Value.ToShortDateString(); dr["To"] = to.Value.ToShortDateString(); dr["Customer"] = name; dr["type"] = project == null ? "All" : project == 1 ? "Project" : "Transport"; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); SalesRegisterRepository repo1 = new SalesRegisterRepository(); //var Items = repo1.GetSalesRegisterDTPrint(from, to, id, OrganizationId); var Items = repo1.GetSalesRegister(from, to, id, OrganizationId, project); foreach (var item in Items) { var SupplyOrderRegItem = new SalesRegister { SalesInvoiceRefNo = item.SalesInvoiceRefNo, SalesInvoiceDate = item.SalesInvoiceDate, CustomerName = item.CustomerName, WorkDescr = item.WorkDescr, Quantity = item.Quantity, Rate = item.Rate, Amount = item.Amount, Discount = item.Discount, TotalAmount = item.TotalAmount, UnitName = item.UnitName }; DataRow dri = ds.Tables["Items"].NewRow(); dri["SalesInvoiceRefNo"] = SupplyOrderRegItem.SalesInvoiceRefNo; dri["Date"] = SupplyOrderRegItem.SalesInvoiceDate.ToString("dd-MMM-yyyy"); dri["CustomerName"] = SupplyOrderRegItem.CustomerName; dri["WorkDescr"] = SupplyOrderRegItem.WorkDescr; dri["Quantity"] = SupplyOrderRegItem.Quantity; dri["Discount"] = SupplyOrderRegItem.Discount; dri["Unit"] = SupplyOrderRegItem.UnitName; dri["rate"] = SupplyOrderRegItem.Rate; dri["Amount"] = SupplyOrderRegItem.Amount; dri["TotalAmount"] = SupplyOrderRegItem.TotalAmount; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "SalesRegister.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf"));//, String.Format("SalesRegister.pdf")); } catch (Exception ex) { throw; } }
public ActionResult Print(string name = "", int id = 0) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "ProductWiseSalesRegister.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("Customer"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("Workdes"); ds.Tables["Items"].Columns.Add("Jan"); ds.Tables["Items"].Columns.Add("Feb"); ds.Tables["Items"].Columns.Add("Mar"); ds.Tables["Items"].Columns.Add("Apr"); ds.Tables["Items"].Columns.Add("May"); ds.Tables["Items"].Columns.Add("Jun"); ds.Tables["Items"].Columns.Add("Jul"); ds.Tables["Items"].Columns.Add("Aug"); ds.Tables["Items"].Columns.Add("Sep"); ds.Tables["Items"].Columns.Add("Oct"); ds.Tables["Items"].Columns.Add("Nov"); ds.Tables["Items"].Columns.Add("Dec"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["Customer"] = name; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); SalesRegisterRepository repo1 = new SalesRegisterRepository(); //var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName); var Items = repo1.GetProductWiseSalesRegisterDTPrint(id: id, OrganizationId: OrganizationId, FYStartdate: FYStartdate, FYEnddate: FYEnddate); foreach (var item in Items) { var SupplyOrderRegItem = new SalesRegister { WorkDescr = item.WorkDescr, Jan = item.Jan, Feb = item.Feb, Mar = item.Mar, Apr = item.Apr, May = item.May, Jun = item.Jun, Jul = item.Jul, Aug = item.Aug, Sep = item.Sep, Oct = item.Oct, Nov = item.Nov, Dece = item.Dece }; DataRow dri = ds.Tables["Items"].NewRow(); dri["Workdes"] = SupplyOrderRegItem.WorkDescr; dri["Jan"] = SupplyOrderRegItem.Jan; dri["Feb"] = SupplyOrderRegItem.Feb; dri["Mar"] = SupplyOrderRegItem.Mar; dri["Apr"] = SupplyOrderRegItem.Apr; dri["May"] = SupplyOrderRegItem.May; dri["Jun"] = SupplyOrderRegItem.Jun; dri["Jul"] = SupplyOrderRegItem.Jul; dri["Aug"] = SupplyOrderRegItem.Aug; dri["Sep"] = SupplyOrderRegItem.Sep; dri["Oct"] = SupplyOrderRegItem.Oct; dri["Aug"] = SupplyOrderRegItem.Aug; dri["Sep"] = SupplyOrderRegItem.Sep; dri["Oct"] = SupplyOrderRegItem.Oct; dri["Nov"] = SupplyOrderRegItem.Nov; dri["Dec"] = SupplyOrderRegItem.Dece; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "ProductWiseSalesRegister.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", String.Format("ProductWiseSalesRegister.pdf"))); } catch (Exception ex) { throw; } }
public ActionResult Print(DateTime?from, DateTime?to, int id = 0, string name = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "PendingSaleOrderRegister.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("From"); ds.Tables["Head"].Columns.Add("To"); ds.Tables["Head"].Columns.Add("CusHead"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("Customer"); ds.Tables["Items"].Columns.Add("SO.NO"); ds.Tables["Items"].Columns.Add("Date"); ds.Tables["Items"].Columns.Add("WorkDescr"); ds.Tables["Items"].Columns.Add("QtyAsPerSO"); ds.Tables["Items"].Columns.Add("QtySold"); ds.Tables["Items"].Columns.Add("Balance"); ds.Tables["Items"].Columns.Add("Status"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = from.Value.ToShortDateString(); dr["To"] = to.Value.ToShortDateString(); dr["CusHead"] = name; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); SalesRegisterRepository repo1 = new SalesRegisterRepository(); //var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName); var Items = repo1.GetPendingSODTPrint(from, to, id, OrganizationId); foreach (var item in Items) { var SupplyOrderRegItem = new SalesRegister { CustomerName = item.CustomerName, SaleOrderRefNo = item.SaleOrderRefNo, SaleOrderDate = item.SaleOrderDate, WorkDescr = item.WorkDescr, Quantity = item.Quantity, INVQTY = item.INVQTY, BALQTY = item.BALQTY, Status = item.Status, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["Customer"] = SupplyOrderRegItem.CustomerName; dri["SO.NO"] = SupplyOrderRegItem.SaleOrderRefNo; dri["Date"] = SupplyOrderRegItem.SaleOrderDate.ToString("dd-MMM-yyyy"); dri["WorkDescr"] = SupplyOrderRegItem.WorkDescr; dri["QtyAsPerSO"] = SupplyOrderRegItem.Quantity; dri["QtySold"] = SupplyOrderRegItem.INVQTY; dri["Balance"] = SupplyOrderRegItem.BALQTY; dri["Status"] = SupplyOrderRegItem.Status; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "PendingSaleOrderRegister.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", String.Format("PendingSaleOrderRegister.pdf"))); } catch (Exception ex) { throw; } }
public ActionResult Print(string name = "", int id = 0) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "TargetVsAchieved.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("Month"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("MonthName"); ds.Tables["Items"].Columns.Add("WorkDescr"); ds.Tables["Items"].Columns.Add("Target"); ds.Tables["Items"].Columns.Add("Achieved"); ds.Tables["Items"].Columns.Add("Varience"); ds.Tables["Items"].Columns.Add("Varperc"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["Month"] = name; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); SalesRegisterRepository repo1 = new SalesRegisterRepository(); //var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName); var Items = repo1.GetTargetVsAchievedDTPrint(id: id, OrganizationId: OrganizationId, FYStartdate: FYStartdate, FYEnddate: FYEnddate); foreach (var item in Items) { var SupplyOrderRegItem = new SalesRegister { MonthName = item.MonthName, WorkDescr = item.WorkDescr, Target = item.Target, Achieved = item.Achieved, Varience = item.Varience, Varperc = item.Varperc }; DataRow dri = ds.Tables["Items"].NewRow(); dri["MonthName"] = SupplyOrderRegItem.MonthName; dri["WorkDescr"] = SupplyOrderRegItem.WorkDescr; dri["Target"] = SupplyOrderRegItem.Target; dri["Achieved"] = SupplyOrderRegItem.Achieved; dri["Varience"] = SupplyOrderRegItem.Varience; dri["Varperc"] = SupplyOrderRegItem.Varperc; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "TargetVsAchieved.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", String.Format("TargetVsAchieved.pdf"))); } catch (Exception ex) { throw; } }