public IEnumerable <InventoryReport> CreateUsedInventoryReport() { List <InventoryReport> usedInventory = new List <InventoryReport>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("InventoryReportUsed", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReport currentRow = new InventoryReport(); currentRow.VehicleYear = (int)dr["VehicleYear"]; currentRow.MakeDescription = dr["MakeDescription"].ToString(); currentRow.ModelDescription = dr["ModelDescription"].ToString(); currentRow.Count = (int)dr["Count"]; currentRow.StockValue = (decimal)dr["StockValue"]; usedInventory.Add(currentRow); } } } return(usedInventory); }
public List <InventoryReport> GetUsedInventoryList() { List <InventoryReport> list = new List <InventoryReport>(); using (_ctx = new GuildCarsEntities()) { try { var newList = _ctx.UsedInventoryReport(); foreach (var car in newList) { InventoryReport report = new InventoryReport(); report.Year = car.Year; report.CarMake = car.MakeName; report.CarModel = car.ModelName; report.Count = car.TotalVehicles; report.StockValue = car.TotalValue; list.Add(report); } } catch (Exception ex) { throw ex; } return(list); } }
public IEnumerable <InventoryReport> GetUsed() { List <InventoryReport> usedInventory = new List <InventoryReport>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("UsedInventoryReport", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Connection = cn; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReport row = new InventoryReport(); row.Year = (int)dr["Year"]; row.Make = dr["Make"].ToString(); row.Model = dr["Model"].ToString(); row.Count = (int)dr["Count"]; row.StockValue = (decimal)dr["StockValue"]; usedInventory.Add(row); } } } return(usedInventory); }
private void CreateReport(int inventoryId) { var report = new InventoryReport(); var inventory = Inventory.FromDto(_inventoryDao.GetInventoryById(inventoryId)); report.Inventory = inventory; var inventoryProducts = _inventoryDao.GetAllInventoryProductsByInventoryId(inventoryId); var zones = _zoneService.GetAllChildZones(inventory.ZoneId); var productsTiedToZone = _productDao.GetAllActiveProductsForZones(zones.Select(x => x.ToDto()).ToList()); foreach (var product in productsTiedToZone) { if (inventoryProducts.Any(x => x.ZoneId == product.ZoneId && x.ProductId == product.Id)) { report.ScannedItems.Add($"Product with id {product.Id} and description {product.Description} scanned correctly"); } else if (inventoryProducts.Any(x => x.ZoneId != product.ZoneId && x.ProductId == product.Id)) { report.MovedItems.Add($"Product with id {product.Id} and description {product.Description} scanned in wrong zone. Scanned zone id {inventoryProducts.Where(x => x.ProductId == product.Id).First().ZoneId} but should be {product.ZoneId}"); } else { report.MissingItems.Add($"Product with id {product.Id} and description {product.Description} is missing"); } } report.Info = $"Raport creaded : {DateTime.Now}, Inventory started {inventory.StartDate} ended {DateTime.Now},\n Items scanned: {report.ScannedItems.Count}, \n Items missing: {report.MissingItems.Count}, \n Items moved {report.MovedItems.Count}"; _inventoryDao.InsertReport(report.ToDto()); }
public VehicleInventoryViewModel GetVehicleInventoryReport() { VehicleInventoryViewModel report = new VehicleInventoryViewModel(); report.NewInventory = new List <InventoryReport>(); report.UsedInventory = new List <InventoryReport>(); MakeRepoMock makeRepo = new MakeRepoMock(); var makes = makeRepo.GetAll(); ModelRepoMock modelRepo = new ModelRepoMock(); var models = modelRepo.GetAll(); foreach (var v in _vehicles) { InventoryReport r = new InventoryReport() { Count = 1, MakeName = makes.FirstOrDefault(x => x.MakeId == v.MakeId).Name, ModelName = models.FirstOrDefault(x => x.ModelId == v.ModelId).ModelName, TotalStock = v.SalePrice, Year = v.Year }; if (v.Type == "New") { report.NewInventory.Add(r); } else { report.UsedInventory.Add(r); } } return(report); }
public IEnumerable <InventoryReport> Reports(string vehicleType) { List <InventoryReport> vehicles = new List <InventoryReport>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetVehiclesReport", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@prm_vehicleType", SqlDbType.NVarChar).Value = vehicleType; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReport row = new InventoryReport(); row.Year = dr["Year"].ToString(); row.MakeName = dr["MakeName"].ToString(); row.StockValue = (decimal)dr["StockValue"]; row.ModelName = dr["ModelName"].ToString(); row.Count = (int)dr["Count"]; vehicles.Add(row); } } } return(vehicles); }
public VehicleInventoryViewModel GetVehicleInventoryReport() { VehicleInventoryViewModel report = new VehicleInventoryViewModel(); report.UsedInventory = new List <InventoryReport>(); report.NewInventory = new List <InventoryReport>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _connection; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "GetUsedInventoryReport"; cmd.CommandType = CommandType.StoredProcedure; conn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReport current = new InventoryReport(); current.Count = (int)dr["Count"]; current.Year = (int)dr["Year"]; current.MakeName = dr["MakeName"].ToString(); current.ModelName = dr["ModelName"].ToString(); current.TotalStock = (decimal)dr["Stock"]; report.UsedInventory.Add(current); } } } using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _connection; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "GetNewInventoryReport"; cmd.CommandType = CommandType.StoredProcedure; conn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReport current = new InventoryReport(); current.Count = (int)dr["Count"]; current.Year = (int)dr["Year"]; current.MakeName = dr["MakeName"].ToString(); current.ModelName = dr["ModelName"].ToString(); current.TotalStock = (decimal)dr["Stock"]; report.NewInventory.Add(current); } } } return(report); }
private void test() { ICSM_Orders ios = new ICSM_Orders(); // first order ICSM_ShipData sd = new ICSM_ShipData("name", "delivertoname", "123-456-7890", "company", "address", "city", "st", "zipcode", "0"); ICSM_LineItems lis = new ICSM_LineItems(); ICSM_LineItem li1 = new ICSM_LineItem("AB605-981605-MI", 5); lis.AddNewItem(li1); ICSM_LineItem li2 = new ICSM_LineItem("AB605-982701-MI", 10); lis.AddNewItem(li2); ICSM_Order io1 = new ICSM_Order(lis, sd, "P000002", "MZ4Y3124", "111", "102426", "1", "prospectid", "fedexid"); //second order ICSM_ShipData sd2 = new ICSM_ShipData("name2", "delivertoname2", "987-654-3210", "company2", "address2", "city2", "st2", "zipcode2", "0"); ICSM_LineItems lis2 = new ICSM_LineItems(); ICSM_LineItem li21 = new ICSM_LineItem("AB605-895554", 1); ICSM_LineItem li22 = new ICSM_LineItem("AB605-895553", 2); lis2.AddNewItem(li21); lis2.AddNewItem(li22); ICSM_LineItem li23 = new ICSM_LineItem("AB605-894048", 3); lis2.AddNewItem(li23); ICSM_Order io2 = new ICSM_Order(lis2, sd2, "P000002", "MZ4Y3124", "222", "102426", "1", "prospectid", "fedexid"); ios.Add(io1); ios.Add(io2); SchedLib.InventoryReport ir = new InventoryReport(); ir.ProcessOrdersToICSM(ios, @"E:\test1.xml"); }
public async Task <InventoryReport> AddInventoryReport(InventoryReport report) { _reportContext.InventoryReport.Add(report); await _reportContext.SaveChangesAsync(); return(report); }
public HttpResponseMessage PostExportExcelInventoryTongHop(InventoryReport para) { HttpResponseMessage response = Request.CreateResponse(); try { MemoryStream streamData = new MemoryStream(); streamData = _service.ExportExcelTonTongHop(para); response.StatusCode = HttpStatusCode.OK; streamData.Seek(0, SeekOrigin.Begin); response.Content = new StreamContent(streamData); response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline") { FileName = "BaoCaoXuatNhapTonTongHop.xlsx" }; response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); return(response); } catch (Exception ex) { response.StatusCode = HttpStatusCode.InternalServerError; return(response); } }
public InventoryReportWithItemsViewModel(InventoryReport inventory) { Id = inventory.Id; OrganizationId = inventory.OrganizationId; StartInventory = inventory.StartInventory; EndInventory = inventory.EndInventory; }
public List <InventoryReport> GetInventoryReportUsed() { List <InventoryReport> invUsed = new List <InventoryReport>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetInventoryReportUsed"; conn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReport currentRow = new InventoryReport(); currentRow.year = (int)dr["year"]; currentRow.make = dr["make"].ToString(); currentRow.model = dr["model"].ToString(); currentRow.inventoryCount = (int)dr["InventoryCount"]; currentRow.stockValue = (decimal)dr["Stock Value"]; invUsed.Add(currentRow); } } } return(invUsed); }
public InventoryReport GetDailyReport() { InventoryReport inventoryReport = _inventoryReport; Reset(); return(inventoryReport); }
public override global::System.Data.DataSet Clone() { InventoryReport cln = ((InventoryReport)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public void PrintInventoryReport(InventoryReport inventoryReport) { using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet worksheet = workbook.Worksheets[0]; // Copy StyleExcel_Inventory(workbook, worksheet); // này tự m tạo 1 cái hàm khác như trên worksheet["B2"].Text = inventoryReport.IdReport.ToString(); worksheet["B3"].Text = inventoryReport.ReportDate.ToString(); worksheet["B4"].Text = inventoryReport.UserName; //gán dữ liệu vô mấy cái ô trên int i = 6; foreach (var item in inventoryReport.ListInventory) { Object[] list = new object[] { item.STT.ToString(), item.Supplies_Name, item.TonDau, item.PhatSinh , item.TonCuoi }; worksheet.InsertRow(i, 1, ExcelInsertOptions.FormatDefault); worksheet.ImportArray(list, i, 1, false); i++; } // tạo từng dòng rồi load cái list vô worksheet.Columns[1].ColumnWidth = 30; worksheet.Columns[2].ColumnWidth = 20; worksheet.Columns[3].ColumnWidth = 20; worksheet.Columns[4].ColumnWidth = 20; // này là set chiều rộng column SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Filter = "excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; saveFileDialog1.FilterIndex = 2; saveFileDialog1.RestoreDirectory = true; saveFileDialog1.ShowDialog(); if (!string.IsNullOrEmpty(saveFileDialog1.FileName)) { Stream excelStream; application.Application.IgnoreSheetNameException = false; if (File.Exists(Path.GetFullPath(saveFileDialog1.FileName))) { excelStream = File.Create(Path.GetFullPath(saveFileDialog1.FileName)); } else { excelStream = File.Create(Path.GetFullPath(saveFileDialog1.FileName + ".xlsx")); } workbook.SaveAs(excelStream); excelStream.Dispose(); } // này là save. copy y chang vô } }
public async Task <ActionResult <InventoryReport> > AddDeliveryReport([FromBody] InventoryReport report) { if (!ModelState.IsValid) { Console.WriteLine("Invalid state..."); return(BadRequest(ModelState)); } var newReport = await _inventoryRepository.AddInventoryReport(report); return(CreatedAtAction(nameof(GetAllInventoryReport), new { id = newReport.Id }, newReport)); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { InventoryReport ds = new InventoryReport(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public void Print(string count, List <InventoryModel> data) { InventoryReport pb = new InventoryReport(); foreach (DevExpress.XtraReports.Parameters.Parameter p in pb.Parameters) { p.Visible = false; } pb.InitData(count, data); documentViewer1.DocumentSource = pb; pb.CreateDocument(); }
public ActionResult Inventory() { var repo = VehicleRepositoryFactory.GetVehicleRepository(); var model = new InventoryReport() { NewVehicles = repo.GetVehicleInventoryList("New"), UsedVehicles = repo.GetVehicleInventoryList("Used") }; return(View(model)); }
public List <InventoryReport> InventoryReport(string report) { List <InventoryReport> reportItems = new List <InventoryReport>(); using (var cn = new SqlConnection(ConnectionStrings.GetConnectionString())) { string query = "SELECT l.ModelYear, ma.MakeName, ModelName, COUNT(*) as [Count], SUM(l.SalePrice) AS 'StockValue' " + "FROM Listings l " + "INNER JOIN Models mo on mo.ModelId = l.ModelId " + "INNER JOIN Makes ma on ma.MakeId = mo.MakeId "; SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; switch (report) { case "New": query += "WHERE l.Condition = 1 AND IsSold = 0 "; break; case "Used": query += "WHERE l.Condition = 2 AND IsSold = 0"; break; default: break; } query += "GROUP BY l.ModelYear, mo.ModelName, ma.MakeName, l.SalePrice"; cmd.CommandText = query; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { InventoryReport row = new InventoryReport(); row.ModelYear = (int)dr["ModelYear"]; row.MakeName = dr["MakeName"].ToString(); row.ModelName = dr["ModelName"].ToString(); row.Count = (int)dr["Count"]; row.StockValue = (decimal)dr["StockValue"]; reportItems.Add(row); } } } return(reportItems); }
public async Task <ActionResult <InventoryReportWithItems> > StartInventory() { User user = await database.Users.FirstOrDefaultAsync(r => r.Username == User.Identity.Name); if (user == null) { return(NotFound()); } var inventoryReport = new InventoryReport { OrganizationId = user.OrganizationId, StartInventory = DateTime.Now, EndInventory = false }; database.InventoryReports.Add(inventoryReport); await database.SaveChangesAsync(); var inventoryReportWithItems = new InventoryReportWithItems(inventoryReport); var items = database.Items.Where(r => r.OrganizationId == inventoryReport.OrganizationId && r.Status != "Списан"); var checkitems = new List <ItemCheck>(); foreach (var item in items) { var checkItem = new ItemCheck { InventoryNumber = item.InventoryNumber, Description = item.Description, InventoryReportId = inventoryReport.Id, RoomId = item.RoomId, UserId = item.UserId, Name = item.Name, Status = item.Status, Cost = item.Cost, Check = false }; database.ItemsCheck.Add(checkItem); checkitems.Add(checkItem); } await database.SaveChangesAsync(); inventoryReportWithItems.Items = checkitems; return(inventoryReportWithItems); }
public ContentResult Get() { var query = Request.QueryString.Value; if (query.IndexOf("?") == 0) { query = query.Substring(1); } var db = Database.GetTimeSeriesDatabase(); var w = new InventoryReport(db, query); var x = w.Run(); return(Content(x, "text/html")); }
public JsonResult InventoryReport() { var newReport = new InventoryReport(); var status = new ReportStatus(); status.ReportLocation = newReport.RunReport(); if (string.IsNullOrWhiteSpace(status.ReportLocation)) { status.success = false; } else { status.success = true; } return(Json(status, JsonRequestBehavior.DenyGet)); }
public ActionResult Generate() { StatusMonContext db = new StatusMonContext(); DateTime MostRecent = db.SalesOrders.Max(s => s.OrderDate).Date; MostRecent = MostRecent.AddDays(-1 * (MostRecent.Day - 1)); List <int> Skus = db.SalesOrderDetails.GroupBy(o => o.ProductID).ToList().Select(p => p.Key).ToList(); foreach (int Sku in Skus) { double stdDev = StandardDeviation(Sku, MostRecent); int[] Sales12Month = MonthlySales(Sku, MostRecent.AddMonths(-11), MostRecent).ToArray(); int totalSales = Sales12Month.Sum(); double[] forcastVals = Forcast(Sku, MostRecent); InventoryReport IR = new InventoryReport(Sku, stdDev, forcastVals, totalSales, Sales12Month, MostRecent); db.InventoryReports.AddOrUpdate(IR); db.SaveChanges(); } return(RedirectToAction("Index")); }
private List <InventoryReport> ConvertReport(List <InventoryPurchase> aList) { List <InventoryReport> aReports = new List <InventoryReport>(); foreach (InventoryPurchase purchase in aList) { InventoryReport aReport = new InventoryReport(); aReport.AdvanceAmount = purchase.Supplier.AdvanceAmount; aReport.CategoryName = purchase.Category.CategoryName; aReport.Date = purchase.Date; aReport.DueAmount = purchase.Supplier.DueAmount; aReport.ItemName = purchase.Item.ItemName; aReport.PaidAmount = purchase.Supplier.PaidAmount; aReport.PaymentType = purchase.PaymentType; aReport.Quantity = purchase.Quantity; aReport.SupplierName = purchase.Supplier.Name; aReport.TotalAmount = purchase.Price; aReport.Unit = purchase.Unit.UnitName; aReport.UserName = purchase.CUserInfo.UserName; aReports.Add(aReport); } return(aReports); }
// Send an inventory event (containing a full status on the inventory // TODO: Add an inventory report class: containing fall status of inventory in a dict void sendInventoryEvent (string eventName, InventoryReport inventoryReport) { Mixpanel.SendEvent ( eventName, inventoryReport.Get() ); }
public async Task <IHttpActionResult> ReportTheoNCCByMerChandise(ParameterInventory para) { var result = new TransferObj <InventoryReport>(); try { var reporter = new InventoryReport(); var data = new List <InventoryExpImp>(); reporter.UnitCode = _servicePeriod.GetCurrentUnitCode(); reporter.Year = para.ToDate.Year; var period = _service.UnitOfWork.Repository <MdPeriod>().DbSet.Where(x => x.ToDate == para.ToDate).FirstOrDefault(); if (period != null) { reporter.Period = period.Period; } var unitCode = _servicePeriod.GetCurrentUnitCode(); reporter.CreateDateNow(); reporter.FromDay = para.FromDate.Day; reporter.FromMonth = para.FromDate.Month; reporter.FromYear = para.FromDate.Year; reporter.ToDay = para.ToDate.Day; reporter.ToMonth = para.ToDate.Month; reporter.ToYear = para.ToDate.Year; reporter.TenDonVi = CurrentSetting.GetUnitName(unitCode); reporter.DiaChiDonVi = CurrentSetting.GetUnitAddress(unitCode); //GetNhanVien if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal) { var currentUser = (HttpContext.Current.User as ClaimsPrincipal); var name = currentUser.Identity.Name; var nhanVien = _service.UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault(); if (nhanVien != null) { reporter.Username = nhanVien.TenNhanVien; } else { reporter.Username = "******"; } } //switch (para.GroupBy) //{ // case TypeGroupInventory.WAREHOUSE: // data = _service.CreateReportInventoryByWareHouse(para.FromDate, para.ToDate, para.UnitCode, para.WareHouseCodes, para.MerchandiseTypeCodes, para.MerchandiseGroupCodes, para.MerchandiseCodes); // reporter.DetailData = data.ToList(); // reporter.DetailData.ForEach(x => x.MapWareHouseName(_service.UnitOfWork)); // reporter.MapUnitUserName(_service.UnitOfWork); // reporter.GroupType = "Kho hàng"; // break; // case TypeGroupInventory.TYPE: // data = _service.CreateReportInventoryByType(para.FromDate, para.ToDate, para.UnitCode, para.WareHouseCodes, para.MerchandiseTypeCodes, para.MerchandiseGroupCodes, para.MerchandiseCodes); // reporter.DetailData = data.ToList(); // reporter.DetailData.ForEach(x => x.MapTypeName(_service.UnitOfWork)); // reporter.MapUnitUserName(_service.UnitOfWork); // reporter.GroupType = "Loại hàng hóa"; // break; // case TypeGroupInventory.GROUP: // data = _service.CreateReportInventoryByGroup(para.FromDate, para.ToDate, para.UnitCode, para.WareHouseCodes, para.MerchandiseTypeCodes, para.MerchandiseGroupCodes, para.MerchandiseCodes); // reporter.DetailData = data.ToList(); // reporter.DetailData.ForEach(x => x.MapGroupName(_service.UnitOfWork)); // reporter.MapUnitUserName(_service.UnitOfWork); // reporter.GroupType = "Nhóm hàng hóa"; // break; // case TypeGroupInventory.MERCHANDISE: // data = _service.CreateReportInventoryByMerchandise(para.FromDate, para.ToDate, para.UnitCode, para.WareHouseCodes, para.MerchandiseTypeCodes, para.MerchandiseGroupCodes, para.MerchandiseCodes); // reporter.DetailData = data.ToList(); // reporter.DetailData.ForEach(x => x.MapMerchandiseName(_service.UnitOfWork)); // reporter.MapUnitUserName(_service.UnitOfWork); // reporter.GroupType = "Hàng hóa"; // break; // default: // //data = _service.CreateReportInventoryByDay(para.FromDate, para.ToDate, para.UnitCode, para.WareHouseCodes, para.MerchandiseTypeCodes, para.MerchandiseGroupCodes, para.MerchandiseCodes); // break; //} //result.Data = reporter; result.Status = true; result.Message = "Xuất báo cáo thành công"; return(Ok(result)); } catch (Exception e) { return(InternalServerError()); } }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); InventoryReport ds = new InventoryReport(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "Inventory_ReportsDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public void GetInventoryReportOfDate(DateTime date) { using (_connection = new SqlConnection(Config.ConnectionString)) { try { _connection.Open(); SqlCommand cmdGetInvetoryReportThisMonth = new SqlCommand("getInventoryReport", _connection) { CommandType = CommandType.StoredProcedure }; cmdGetInvetoryReportThisMonth.Parameters.Add(new SqlParameter("@date", date)); List <InventoryReport> listReports = new List <InventoryReport>(); using (SqlDataReader reader = cmdGetInvetoryReportThisMonth.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { InventoryReport inventoryReport = new InventoryReport { BookID = (int)reader["MaDinhDanh"], BookName = reader["TenSach"] as string, InEarly = (int)reader["TonDau"], OnArise = (int)reader["TonPhatSinh"], InLast = (int)reader["TonCuoi"] }; listReports.Add(inventoryReport); } } } SqlCommand cmdInventoryReportLastest = new SqlCommand("getInventoryReportLastest", _connection) { CommandType = CommandType.StoredProcedure }; cmdInventoryReportLastest.Parameters.Add(new SqlParameter("@date", date)); using (SqlDataReader reader = cmdInventoryReportLastest.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { InventoryReport inventoryReport = new InventoryReport { BookID = (int)reader["MaDinhDanh"], BookName = reader["TenSach"] as string, InEarly = (int)reader["TonDau"], OnArise = (int)reader["TonPhatSinh"], InLast = (int)reader["TonCuoi"] }; if (listReports.Count(r => r.BookID == inventoryReport.BookID) == 0) { listReports.Add(inventoryReport); } } } } if (listReports.Count != 0) { _listener.OnGetInventoryReportSuccessful(listReports); } else { _listener.OnGetInventoryReportFailure("Chưa có báo cáo cho tháng này!"); } } catch (Exception exception) { Trace.AutoFlush = true; Trace.TraceInformation("Error Occur"); Trace.TraceError(exception.Message); Trace.TraceWarning("Careful!"); Trace.Listeners.Add(new TextWriterTraceListener("log.txt")); _listener.OnGetInventoryReportFailure(exception.Message); } } }
public void Reset() { _inventoryReport = new InventoryReport(); }
public void WhenIGenerateAnInventoryReport() { _myReport = _p.InventoryCars(); _carCount = _myReport.NumberOfCars; }