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"));
}
}
}
