// GET: OfficialMagazine/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OfficialMagazine officialMagazine = db.OfficialMagazines.Find(id);
if (officialMagazine == null)
{
return(HttpNotFound());
}
return(View(officialMagazine));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OfficialMagazine officialMagazine = db.OfficialMagazines.Find(id);
if (officialMagazine == null)
{
return(Json(new { success = false, responseText = "این ریکارد در سیستم موجود نیست" }, JsonRequestBehavior.AllowGet));
}
officialMagazine.IsActive = false;
db.SaveChanges();
return(Json(new { success = true, responseText = "ریکارد موافقانه حذب شد" }, JsonRequestBehavior.AllowGet));
}
public ActionResult BorrowOfficialMagazine(int?id, int?employeeId)
{
if (id == null && employeeId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var alreadyBorrowed = db.Borrows.Where(b => b.ItemTypeId == officialMagazineTypeId && b.ItemId == id &&
b.EmployeeId == employeeId && b.IsReturned == false).FirstOrDefault();
if (alreadyBorrowed != null)
{
return(Json(new { success = false, responseText = "کارمند این جریده را با خود دارد" }, JsonRequestBehavior.AllowGet));
}
OfficialMagazine OMagazine = db.OfficialMagazines.Where(b => b.Id == id).FirstOrDefault();
Employee employee = db.Employees.Where(e => e.Id == employeeId).FirstOrDefault();
if (OMagazine == null && employee == null && officialMagazineTypeId == 0)
{
return(Json(new { success = false, responseText = "چریده و یا کارمند در سیستم موجود نیست" }, JsonRequestBehavior.AllowGet));
}
if (OMagazine.AvailableQuantity <= 0)
{
return(Json(new { success = false, responseText = "این جریده فعلاً در کتابخانه موجودنیست" }, JsonRequestBehavior.AllowGet));
}
Borrow borrowObj = new Borrow()
{
EmployeeId = employee.Id,
ItemTypeId = officialMagazineTypeId,
ItemId = OMagazine.Id,
BorrowingDate = DateHelper.PersionDateNow(),
IsReturned = false
};
db.Borrows.Add(borrowObj);
db.SaveChanges();
//Reduce the availability number
int availibleyQuantity = OMagazine.AvailableQuantity - 1;
OMagazine.AvailableQuantity = availibleyQuantity;
db.SaveChanges();
return(Json(new { success = true, responseText = "جریده موافقانه به کارمند تسلیم شود" }, JsonRequestBehavior.AllowGet));
}
//Return book, by passing borrow record id
public ActionResult ReturnOfficialMagazine(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Borrow borrow = db.Borrows.Where(b => b.Id == id).FirstOrDefault();
if (borrow == null)
{
return(Json(new { success = false, responseText = "این ریکارد در سیستم موجود نیست" }, JsonRequestBehavior.AllowGet));
}
borrow.IsReturned = true;
borrow.RetrunDate = DateHelper.PersionDateNow();
//Add official Magazine back to availablity
OfficialMagazine oMagazine = db.OfficialMagazines.Where(b => b.Id == borrow.ItemId).FirstOrDefault();
int availibleyQuantity = oMagazine.AvailableQuantity + 1;
oMagazine.AvailableQuantity = availibleyQuantity;
db.SaveChanges();
return(Json(new { success = true, responseText = "جریده موافقانه به کتابخانه تحویل داده شود" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit([Bind(Include = "Id,Name,Publisher,DateEntered,CabinetNumber,ShelfNumber,CodeNumber,PublicationDate,Quantity,AvailableQuantity,SerialNumber,IsActive")] OfficialMagazine officialMagazine)
{
if (ModelState.IsValid)
{
try
{
db.Entry(officialMagazine).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (DbUpdateException ex)
{
if (ExceptionHelper.IsUniqueConstraintViolation(ex))
{
ModelState.AddModelError("CodeNumber", $"جریده به این کود نمبر در سیستم موجود است");
ModelState.AddModelError("SerialNumber", $"جریده به این سریال نمبر در سیستم موجود است");
return(View(officialMagazine));
}
}
}
return(View(officialMagazine));
}
public ActionResult Create([Bind(Include = "Id,Name,Publisher,DateEntered,CabinetNumber,ShelfNumber,CodeNumber,PublicationDate,Quantity,SerialNumber,SerialNumber,IsActiv")] OfficialMagazine officialMagazine)
{
//var persianDateTime = new PersianDateTime();
//if(officialMagazine.PublicationDate)
if (ModelState.IsValid)
{
try
{
OfficialMagazine obj = new OfficialMagazine();
obj.Publisher = officialMagazine.Publisher;
obj.Name = officialMagazine.Name;
obj.DateEntered = officialMagazine.DateEntered;
obj.CabinetNumber = officialMagazine.CabinetNumber;
obj.ShelfNumber = officialMagazine.ShelfNumber;
obj.CodeNumber = officialMagazine.CodeNumber;
obj.PublicationDate = officialMagazine.PublicationDate;
obj.Quantity = officialMagazine.Quantity;
obj.AvailableQuantity = officialMagazine.Quantity;
obj.SerialNumber = officialMagazine.SerialNumber;
obj.IsActive = true;
db.OfficialMagazines.Add(obj);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (DbUpdateException ex)
{
if (ExceptionHelper.IsUniqueConstraintViolation(ex))
{
ModelState.AddModelError("CodeNumber", $"جریده به این کود نمبر در سیستم موجود است");
ModelState.AddModelError("SerialNumber", $"جریده به این سریال نمبر در سیستم موجود است");
return(View(officialMagazine));
}
}
}
return(View(officialMagazine));
}
