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);
}
}
}
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 void Reset()
{
_inventoryReport = new InventoryReport();
}
public void WhenIGenerateAnInventoryReport()
{
_myReport = _p.InventoryCars();
_carCount = _myReport.NumberOfCars;
}
