public async Task <IHttpActionResult> GetNewParameter()
{
var unitCode = _servicePeriod.GetCurrentUnitCode();
var currentDate = DateTime.Now.Date;
var result = new ParameterSinhNhatKh()
{
ToDay = currentDate.Day,
FromDay = currentDate.Day,
MonthOfBirth = currentDate.Month,
MinDay = currentDate.Day,
MaxDay = currentDate.Day,
ToDate = currentDate,
FromDate = currentDate,
MinDate = currentDate,
MaxDate = currentDate,
UnitCode = unitCode
};
var periodCollection = _servicePeriod.Repository.DbSet.Where(x => x.UnitCode == unitCode && x.TrangThai == (int)ApprovalState.IsComplete);
if (periodCollection != null && periodCollection.Count() > 0)
{
var lastPeriod = periodCollection.OrderByDescending(x => x.Year).OrderByDescending(x => x.Period).FirstOrDefault();
var originalPeriod = periodCollection.OrderBy(x => x.Period).FirstOrDefault();
result.MaxDate = lastPeriod.ToDate;
result.MinDate = originalPeriod.FromDate;
result.ToDate = lastPeriod.ToDate;
if (lastPeriod.ToDate.AddMonths(-1) >= originalPeriod.FromDate)
{
result.FromDate = lastPeriod.ToDate.AddMonths(-1);
}
else
{
result.FromDate = originalPeriod.FromDate;
}
result.MaxDay = lastPeriod.ToDate.Day;
result.MinDay = originalPeriod.FromDate.Day;
result.ToDay = lastPeriod.ToDate.Day;
result.FromDay = originalPeriod.ToDate.Day;
result.MonthOfBirth = lastPeriod.ToDate.Month;
}
return(Ok(result));
}
public async Task <IHttpActionResult> GetNewParameter()
{
var unitCode = _servicePeriod.GetCurrentUnitCode();
var currentDate = DateTime.Now.Date;
var result = new ParameterInventory()
{
ToDate = currentDate,
FromDate = currentDate,
MinDate = currentDate,
MaxDate = currentDate,
UnitCode = unitCode,
//IsOnlyInventory = 2,
TypeValue = TypeValueInventory.ALL,
GroupBy = TypeGroupInventory.WAREHOUSE
};
//var periodCollection = _servicePeriod.Repository.DbSet.Where(x => x.UnitCode == unitCode && x.TrangThai == (int)ApprovalState.IsComplete);
//if (periodCollection != null && periodCollection.Count() > 0)
//{
// var lastPeriod = periodCollection.OrderByDescending(x => x.Year).OrderByDescending(x => x.Period).FirstOrDefault();
// var originalPeriod = periodCollection.OrderBy(x => x.Period).FirstOrDefault();
// result.MaxDate = lastPeriod.ToDate;
// result.MinDate = originalPeriod.FromDate;
// result.ToDate = lastPeriod.ToDate;
// if (lastPeriod.ToDate.AddMonths(-1) >= originalPeriod.FromDate)
// {
// result.FromDate = lastPeriod.ToDate.AddMonths(-1);
// }
// else
// {
// result.FromDate = originalPeriod.FromDate;
// }
//}
return(Ok(result));
}
public MdPeriod GetPeriodDate()
{
var unitCode = _servicePeriod.GetCurrentUnitCode();
var period = new MdPeriod();
period = CurrentSetting.GetKhoaSo(unitCode);
if (period != null)
{
return(period);
}
else
{
return(null);
}
}
public async Task <IHttpActionResult> UpdateGiaVon(ParameterInventory para)
{
var unitCode = _servicePeriod.GetCurrentUnitCode();
var period = _service.UnitOfWork.Repository <MdPeriod>().DbSet.Where(x => x.ToDate.Date == para.ToDate.Date).FirstOrDefault();
if (period != null)
{
try
{
_servicePeriod.UpDateGiaVon(period);
return(Ok(true));
}
catch (Exception)
{
return(InternalServerError());
}
}
return(Ok(false));
}
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 IList <ChoiceObj> GetSelectData()
{
var data = _service.Repository.DbSet;
var unitCode = _service.GetCurrentUnitCode();
return(data.Where(x => x.UnitCode == unitCode).Select(x => new ChoiceObj {
Value = x.Id, Text = x.Name, Id = x.Id
}).ToList());
}
public async Task <IHttpActionResult> ReportXNTNewTongHop(ParameterInventory para)
{
var result = new TransferObj <InventoryDetailReport>();
try
{
var reporter = new InventoryDetailReport();
var data = new List <InventoryDetailItem>();
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.CreateReportXNTNewTongHop(para);
reporter.DataDetails = data.ToList();
reporter.MapUnitUserName(_service.UnitOfWork);
reporter.GroupType = "Kho hàng";
break;
case TypeGroupInventory.TYPE:
data = _service.CreateReportXNTNewTongHop(para);
reporter.DataDetails = data.ToList();
reporter.MapUnitUserName(_service.UnitOfWork);
reporter.GroupType = "Loại hàng hóa";
break;
case TypeGroupInventory.GROUP:
data = _service.CreateReportXNTNewTongHop(para);
reporter.DataDetails = data.ToList();
reporter.MapUnitUserName(_service.UnitOfWork);
reporter.GroupType = "Nhóm hàng hóa";
break;
case TypeGroupInventory.MERCHANDISE:
data = _service.CreateReportXNTNewTongHop(para);
reporter.DataDetails = data.ToList();
reporter.MapUnitUserName(_service.UnitOfWork);
reporter.GroupType = "Hàng hóa";
break;
case TypeGroupInventory.NHACUNGCAP:
data = _service.CreateReportXNTNewTongHop(para);
reporter.DataDetails = data.ToList();
reporter.MapUnitUserName(_service.UnitOfWork);
reporter.GroupType = "Nhà cung cấp";
break;
default:
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());
}
}
