public async Task <IHttpActionResult> GetNewParameter()
{
var unitCode = _serviceKK.GetCurrentUnitCode();
var currentDate = DateTime.Now.Date;
var datelock = CurrentSetting.GetNgayKhoaSo(unitCode);
var result = new ParameterKiemKe()
{
ToDate = datelock,
FromDate = datelock,
MaxDate = currentDate,
UnitCode = unitCode,
GroupBy = TypeGroupKiemKe.WAREHOUSE,
ReportType = TypeReportKiemKe.BAOCAODAYDU
};
return(Ok(result));
}
public async Task <IHttpActionResult> GetExternalCode(ParameterKiemKe para)
{
string unitCode = _service.GetCurrentUnitCode();
MdPeriod curentDate = CurrentSetting.GetKhoaSo(unitCode);
if (para.WareHouseCodes == null)
{
para.WareHouseCodes = unitCode + "-K2";
}
string tableName = curentDate.GetTableName();
List <NvKiemKeVm.ExternalCodeInInventory> result = new List <NvKiemKeVm.ExternalCodeInInventory>();
result = ProcedureCollection.GetExternalCodeInventory(unitCode, tableName, para);
if (result != null)
{
return(Ok(result));
}
else
{
return(NotFound());
}
}
public HttpResponseMessage PostExportExcelChiTiet(ParameterKiemKe para)
{
HttpResponseMessage response = Request.CreateResponse();
try
{
MemoryStream streamData = new MemoryStream();
streamData = _serviceKK.ExportExcelDetail(para);
response.StatusCode = HttpStatusCode.OK;
streamData.Seek(0, SeekOrigin.Begin);
response.Content = new StreamContent(streamData);
switch (para.GroupBy)
{
case TypeGroupKiemKe.GROUP:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BCChiTiet_TheoNhomVatTu.xlsx"
};
break;
case TypeGroupKiemKe.TYPE:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BCChiTiet_TheoLoaiVatTu.xlsx"
};
break;
case TypeGroupKiemKe.NHACUNGCAP:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BCChiTiet_TheoNhaCungCap.xlsx"
};
break;
case TypeGroupKiemKe.MERCHANDISE:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BCChiTiet_TheoVatTu.xlsx"
};
break;
case TypeGroupKiemKe.WAREHOUSE:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BCChiTiet_TheoKho.xlsx"
};
break;
case TypeGroupKiemKe.KEHANG:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BCChiTiet_TheoKe.xlsx"
};
break;
default:
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("inline")
{
FileName = "BCChiTiet.xlsx"
};
break;
}
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
return(response);
}
catch (Exception ex)
{
response.StatusCode = HttpStatusCode.InternalServerError;
return(response);
}
}
public async Task <IHttpActionResult> PostReportTongHop(ParameterKiemKe para)
{
NvKiemKeVm.ReportTongHop reporter = new NvKiemKeVm.ReportTongHop();
List <NvKiemKeVm.ObjectReport> result = new List <NvKiemKeVm.ObjectReport>();
try
{
var unitCode = _serviceKK.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.ToDate = para.ToDate;
reporter.FromDate = para.FromDate;
reporter.TenDonVi = CurrentSetting.GetUnitName(unitCode);
reporter.DiaChiDonVi = CurrentSetting.GetUnitAddress(unitCode);
switch (para.GroupBy)
{
case TypeGroupKiemKe.WAREHOUSE:
reporter.NameGroupBy = "Kho hàng";
break;
case TypeGroupKiemKe.TYPE:
reporter.NameGroupBy = "Loại vật tư";
break;
case TypeGroupKiemKe.GROUP:
reporter.NameGroupBy = "Nhóm vật tư";
break;
case TypeGroupKiemKe.MERCHANDISE:
reporter.NameGroupBy = "Vật tư";
break;
case TypeGroupKiemKe.NHACUNGCAP:
reporter.NameGroupBy = "Nhà cung cấp";
break;
case TypeGroupKiemKe.KEHANG:
reporter.NameGroupBy = "Kệ hàng";
break;
default:
reporter.NameGroupBy = "Vật tư";
break;
}
//GetNhanVien
if (HttpContext.Current != null && HttpContext.Current.User is ClaimsPrincipal)
{
var currentUser = (HttpContext.Current.User as ClaimsPrincipal);
var name = currentUser.Identity.Name;
var nhanVien = _serviceKK.UnitOfWork.Repository <AU_NGUOIDUNG>().DbSet.Where(x => x.Username == name).FirstOrDefault();
if (nhanVien != null)
{
reporter.Username = nhanVien.TenNhanVien;
}
else
{
reporter.Username = "******";
}
}
reporter.DataDetails.AddRange(_serviceKK.ReportKiemKe(para));
}
catch (Exception ex)
{
}
return(Ok(reporter));
}
