public ActionResult AddItems(TenderItem tenderitem, string tenderid, string name) { if (Session["clientid"] == null) { return(RedirectToAction("Login", "Account")); } try { db.save_item(null, Convert.ToInt32(securityUtil.Decode(tenderid)), tenderitem.ItemType, tenderitem.ItemName, tenderitem.ItemDesc, tenderitem.ItemCategory, tenderitem.Location, tenderitem.Quantity, tenderitem.UOM, tenderitem.Price, tenderitem.Currency, tenderitem.BidMethod, tenderitem.ReducePerBid, tenderitem.Remarks); } catch { } ViewBag.BidMethodbag = new SelectList(db.BidMethodMasters, "Methodid", "MethodName", tenderitem.BidMethod); ViewBag.ItemCategorybag = new SelectList(db.CategoryMasters, "CategoryID", "CategoryName", tenderitem.ItemCategory); ViewBag.Currencybag = new SelectList(db.CurrencyMasters, "currencyid", "currency", tenderitem.Currency); ViewBag.ItemTypebag = new SelectList(db.ItemTypeMasters, "Typeid", "typename", tenderitem.ItemType); ViewBag.Tenderidbag = new SelectList(db.Tenders, "TenderId", "Attachment", tenderitem.Tenderid); ViewBag.UOMbag = new SelectList(db.UOMMasters, "UOMid", "UOM", tenderitem.UOM); ViewBag.itemlistbag = db.getitemslist(Convert.ToInt32(securityUtil.Decode(tenderid))).ToList(); ViewBag.Menu = db.get_role(Convert.ToInt32(Session["clientid"])); return(RedirectToAction("AddItems", "TenderItem", new { @tenderid = tenderid })); }
private string getModelError(TenderItem item) { string error = null; if (string.IsNullOrWhiteSpace(item.RelatedFile.DisplayName)) { error = "Ви не вказали назву"; return(error); } return(error); }
// GET: /TenderItem/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TenderItem tenderitem = db.TenderItems.Find(id); if (tenderitem == null) { return(HttpNotFound()); } return(View(tenderitem)); }
public ActionResult EditTenderItem(TenderItem tenderItem) { var newItem = context.TenderItems.Find(tenderItem.Id); newItem.NominalWeightPerMeter = tenderItem.NominalWeightPerMeter; newItem.HDPEPrice = tenderItem.HDPEPrice; newItem.PricePerUnit = tenderItem.PricePerUnit; newItem.TotalWeight = tenderItem.TotalWeight; newItem.WasherPrice = tenderItem.WasherPrice; newItem.TotalPrice = tenderItem.TotalPrice; newItem.Amount = tenderItem.Amount; newItem.Comments = tenderItem.Comments; context.Entry(newItem).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return(RedirectToAction("Edit", new { area = "commerce", controller = "Tenders", id = tenderItem.TenderId })); }
public ActionResult Edit(TenderItem tenderitem, string itemid) { if (Session["clientid"] == null) { return(RedirectToAction("Login", "Account")); } int tenderid = db.TenderItems.ToList().Where(m => m.itemid == Convert.ToInt32(securityUtil.Decode(itemid))).FirstOrDefault().Tenderid.Value; var item = int.Parse(securityUtil.Decode(itemid)); tenderitem = db.TenderItems.Single(m => m.itemid == item); ViewBag.itemid = itemid; ViewBag.BidMethodbag = new SelectList(db.BidMethodMasters.ToList(), "Methodid", "MethodName", tenderitem.BidMethod); ViewBag.ItemCategorybag = new SelectList(db.CategoryMasters.ToList(), "CategoryID", "CategoryName", tenderitem.ItemCategory); ViewBag.Currencybag = new SelectList(db.CurrencyMasters.ToList(), "currencyid", "currency", tenderitem.Currency); ViewBag.ItemTypebag = new SelectList(db.ItemTypeMasters.ToList(), "Typeid", "typename", tenderitem.ItemType); ViewBag.Tenderidbag = new SelectList(db.Tenders.ToList(), "TenderId", "Attachment", tenderitem.Tenderid); ViewBag.UOMbag = new SelectList(db.UOMMasters.ToList(), "UOMid", "UOM", tenderitem.UOM); ViewBag.itemlist = db.getitemslist(Convert.ToInt32(tenderid)).ToList(); ViewBag.Menu = db.get_role(Convert.ToInt32(Session["clientid"])); return(View(tenderitem)); }
public ActionResult AddTenderItem(TenderItem item, HttpPostedFileBase attachedFile) { using (zcrlDbContext = new ZcrlContext()) { string error = getModelError(item); if (!string.IsNullOrWhiteSpace(error)) { TempData["Error"] = error; ViewBag.Mode = CrudMode.Add; ViewBag.GroupsList = (from tg in zcrlDbContext.PortalDataGroups where (tg.RelatedGroup == DataGroupType.TenderGroup) select new ZcrlPortal.ViewModels.SelectListItem() { DisplayName = tg.Name, Value = tg.Id }).ToList(); ViewBag.YearsList = (from y in zcrlDbContext.TenderYears select new ZcrlPortal.ViewModels.SelectListItem() { DisplayName = y.Value.ToString(), Value = y.Id }).ToList(); return(View("AddEditItem", item)); } if (!attachedFile.isValidFile()) { TempData["Error"] = "Невірний формат файлу"; ViewBag.Mode = CrudMode.Add; ViewBag.GroupsList = (from tg in zcrlDbContext.PortalDataGroups where (tg.RelatedGroup == DataGroupType.TenderGroup) select new ZcrlPortal.ViewModels.SelectListItem() { DisplayName = tg.Name, Value = tg.Id }).ToList(); ViewBag.YearsList = (from y in zcrlDbContext.TenderYears select new ZcrlPortal.ViewModels.SelectListItem() { DisplayName = y.Value.ToString(), Value = y.Id }).ToList(); return(View("AddEditItem", item)); } try { string newFileName = Guid.NewGuid().ToString() + Path.GetExtension(attachedFile.FileName); string newFileNamePath = Path.Combine(Server.MapPath(UPLOADFILE_DIR), newFileName); attachedFile.SaveAs(newFileNamePath); UploadFile newFile = new UploadFile() { FileName = newFileName, DisplayName = item.RelatedFile.DisplayName, UserProfileId = item.RelatedFile.UserProfileId, FileType = UploadFileType.TenderUpload }; zcrlDbContext.UploadFiles.Add(newFile); zcrlDbContext.SaveChanges(); } catch { TempData["Error"] = "Помилка завантаження файлу, повторіть спробу пізніше"; return(RedirectToAction("AddEditItem", item)); } item.UploadFileId = (from f in zcrlDbContext.UploadFiles where (f.UserProfileId == item.RelatedFile.UserProfileId) orderby f.Id ascending select f).ToList().Last().Id; item.PublicationDate = DateTime.Now; item.RelatedFile = null; zcrlDbContext.TenderItems.Add(item); zcrlDbContext.SaveChanges(); zcrlDbContext.LogJournal.Add(new ZcrlPortal.Models.LogRecord() { СreatedDate = DateTime.Now, RecordType = Models.LogRecordType.TendersAddEdit, Content = string.Format("Користувач <b>{0} {1}.{2}.</b> додав файл <b>{3}</b>", (string)Profile["LastName"], ((string)Profile["FirstName"]).First(), ((string)Profile["MiddleName"]).First(), item.RelatedFile.DisplayName) }); zcrlDbContext.SaveChanges(); ViewBag.Mode = CrudMode.Add; TempData["SuccessMessage"] = "Файл успішно доданий!"; int redirectTenderYear = (from y in zcrlDbContext.TenderYears where (y.Id == item.TenderYearId) select y).First().Value; return(RedirectToAction("Tender", "Home", new { year = redirectTenderYear })); } }
public ActionResult EditTenderItem(TenderItem item, HttpPostedFileBase attachedFile) { string error = getModelError(item); if (!string.IsNullOrWhiteSpace(error)) { TempData["Error"] = error; ViewBag.Mode = CrudMode.Edit; return(View("AddEditItem", item)); } using (zcrlDbContext = new ZcrlContext()) { var editableTenderItem = (from t in zcrlDbContext.TenderItems where (t.Id == item.Id) select t).FirstOrDefault(); if (editableTenderItem != null) { ViewBag.Mode = CrudMode.Edit; // Если обновляют загружаемый файл try { if ((attachedFile != null) && (attachedFile.ContentLength > 0)) { // Удаляем старый if (System.IO.File.Exists(Path.Combine(Server.MapPath(UPLOADFILE_DIR), editableTenderItem.RelatedFile.FileName))) { System.IO.File.Delete(Path.Combine(Server.MapPath(UPLOADFILE_DIR), editableTenderItem.RelatedFile.FileName)); } string newFileName = Guid.NewGuid().ToString() + Path.GetExtension(attachedFile.FileName); string newFileNamePath = Path.Combine(Server.MapPath(UPLOADFILE_DIR), newFileName); attachedFile.SaveAs(newFileNamePath); editableTenderItem.RelatedFile.FileName = newFileName; zcrlDbContext.SaveChanges(); zcrlDbContext.LogJournal.Add(new ZcrlPortal.Models.LogRecord() { СreatedDate = DateTime.Now, RecordType = Models.LogRecordType.TendersAddEdit, Content = string.Format("Користувач <b>{0} {1}.{2}.</b> змінив файл <b>{3}</b>", (string)Profile["LastName"], ((string)Profile["FirstName"]).First(), ((string)Profile["MiddleName"]).First(), editableTenderItem.RelatedFile.DisplayName) }); zcrlDbContext.SaveChanges(); } } catch { TempData["Error"] = "Помилка завантаження файлу, повторіть спробу пізніше"; return(RedirectToAction("AddEditItem", item)); } if (editableTenderItem.RelatedFile.DisplayName != item.RelatedFile.DisplayName) { zcrlDbContext.LogJournal.Add(new ZcrlPortal.Models.LogRecord() { СreatedDate = DateTime.Now, RecordType = Models.LogRecordType.TendersAddEdit, Content = string.Format("Користувач <b>{0} {1}.{2}.</b> змінив назву файлу <b>{3}</b> на <b>{4}</b>", (string)Profile["LastName"], ((string)Profile["FirstName"]).First(), ((string)Profile["MiddleName"]).First(), editableTenderItem.RelatedFile.DisplayName, item.RelatedFile.DisplayName) }); editableTenderItem.RelatedFile.DisplayName = item.RelatedFile.DisplayName; } //editableTenderItem.PublicationDate = DateTime.Now; editableTenderItem.DataGroupId = item.DataGroupId; editableTenderItem.TenderYearId = item.TenderYearId; zcrlDbContext.SaveChanges(); ViewBag.Mode = CrudMode.Edit; TempData["SuccessMessage"] = "Файл успішно змінений!"; return(RedirectToAction("Tender", "Home", new { year = editableTenderItem.Year.Value })); } else { return(RedirectToAction("Tender", "Home")); } } }