Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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"));
        }