public ActionResult TargerEditbyDb(List <TargetDetailsVm> targetDetailsVm)
{
var firstOrDefault = targetDetailsVm.FirstOrDefault();
if (firstOrDefault != null)
{
int targetid = firstOrDefault.TargetId;
int dbId = firstOrDefault.DbId;
Db.tbld_Target_Details.RemoveRange(
Db.tbld_Target_Details.Where(x => x.target_id == targetid && x.db_id == dbId));
Db.SaveChanges();
foreach (var targetDetailsVmitem in targetDetailsVm)
{
int total = (int)((targetDetailsVmitem.QtyinCs * targetDetailsVmitem.PackSize) + targetDetailsVmitem.QtyinPs);
if (total > 0)
{
tbld_Target_Details tbldTargetDetails = new tbld_Target_Details
{
target_id = targetDetailsVmitem.TargetId,
db_id = targetDetailsVmitem.DbId,
sku_id = targetDetailsVmitem.SkuId,
Pack_size = targetDetailsVmitem.PackSize,
qtyinCS = targetDetailsVmitem.QtyinCs,
qtyinPS = targetDetailsVmitem.QtyinPs,
total_Qty = total
};
Db.tbld_Target_Details.Add(tbldTargetDetails);
Db.SaveChanges();
}
}
Db.tbld_Target_PSR_Details.RemoveRange(Db.tbld_Target_PSR_Details.Where(x => x.target_id == targetid && x.db_id == dbId));
Db.SaveChanges();
return(RedirectToAction("Edit", "Target", new { id = targetid }));
}
return(null);
}
public ActionResult UploadTargetbyDb(HttpPostedFileBase fileUpload)
{
int targetid = 0;
List <tbld_Target_Details> tbldTargetDetails = new List <tbld_Target_Details>();
if (fileUpload == null)
{
return(View("UploadTarget"));
}
if (fileUpload.ContentType == "application/vnd.ms-excel" || fileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
string filename = fileUpload.FileName;
if (filename.EndsWith(".xlsx"))
{
string targetpath = Server.MapPath("~/Upload/");
fileUpload.SaveAs(targetpath + filename);
var pathToExcelFile = targetpath + filename;
var excelFile = new ExcelQueryFactory(pathToExcelFile);
var worksheetNames = excelFile.GetWorksheetNames();
string sheetName = worksheetNames.First();
var tgtList = from a in excelFile.Worksheet <TargetDetailsVm>(sheetName) select a;
foreach (var tgtListitem in tgtList)
{
tbld_Target_Details targetitem = new tbld_Target_Details()
{
target_id = tgtListitem.TargetId,
db_id = tgtListitem.DbId,
sku_id = tgtListitem.SkuId,
Pack_size = tgtListitem.PackSize,
qtyinCS = tgtListitem.QtyinCs,
qtyinPS = tgtListitem.QtyinPs,
total_Qty = (tgtListitem.QtyinCs * tgtListitem.PackSize) + tgtListitem.QtyinPs
};
targetid = tgtListitem.TargetId;
tbldTargetDetails.Add(targetitem);
Db.tbld_Target_Details.Add(targetitem);
}
int tergetCount = Db.tbld_Target_Details.Count(x => x.target_id == targetid);
if (tergetCount <= 0)
{
if (tgtList.Count() == tbldTargetDetails.Count())
{
Db.SaveChanges();
TempData["alertbox"] = "success";
TempData["alertboxMsg"] = " Target Upload Successfully";
return(RedirectToAction("Index"));
}
}
else
{
TempData["alertbox"] = "error";
TempData["alertboxMsg"] = " Target Already uploaded";
return(RedirectToAction("Index"));
}
}
}
return(RedirectToAction("Index"));
}
