public async Task <ActionResult> DeleteCopeReserve(long id) { CopsBooking cb = db.CopsBooking.Find(id); cb.StateDelete = 1; await db.SaveChangesAsync(); RecordEntryCopsBooking recb = db.RecordEntryCopsBooking.Where(p => p.IdCopsBooking == id).FirstOrDefault(); db.RecordEntryCopsBooking.Remove(recb); await db.SaveChangesAsync(); return(Json("Ok", JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ExitOrder(Exitorder exo, string date, ItemPropSelect prop) { if (exo.Id == 0) { foreach (var item in prop.ListProps) { RecordEntryCopsBooking recb = db.RecordEntryCopsBooking.Where(p => p.IdRecordEntry == item.Id).FirstOrDefault(); if (recb != null && exo.CustomerFullName != recb.CopsBooking.CustomerFullName) { return(new HttpStatusCodeResult(514)); } } exo.StateDelete = 0; if (date != null && date != "") { DateTime tempdate = clsPersianDate.ShamsiToMiladi(date).Value; exo.Uploaddate = tempdate; } exo.IdState = 1; db.Exitorder.Add(exo); await db.SaveChangesAsync(); List <RecordEntryExitOrder> _listprops = new List <RecordEntryExitOrder>(); RecordEntryExitOrder _p = null; foreach (var item in prop.ListProps) { _p = new RecordEntryExitOrder(); _p.IdExitOrder = exo.Id; _p.IdRecordEntry = item.Id; _p.StateExit = false; if (_listprops.Where(p => p.IdRecordEntry == item.Id).Any()) { continue; } _listprops.Add(_p); Record_the_entry re = db.Record_the_entry.Find(item.Id); re.ExitState = true; await db.SaveChangesAsync(); } db.RecordEntryExitOrder.AddRange(_listprops); await db.SaveChangesAsync(); return(Json("Ok", JsonRequestBehavior.AllowGet)); } else { foreach (var item in prop.ListProps) { RecordEntryCopsBooking recb = db.RecordEntryCopsBooking.Where(p => p.IdRecordEntry == item.Id).FirstOrDefault(); if (recb != null && exo.CustomerFullName != recb.CopsBooking.CustomerFullName) { return(new HttpStatusCodeResult(514)); } } var deleteprops = db.RecordEntryExitOrder.Where(p => p.IdExitOrder == exo.Id); db.RecordEntryExitOrder.RemoveRange(deleteprops); await db.SaveChangesAsync(); Exitorder ecb = db.Exitorder.Find(exo.Id); ecb.IdState = 1; ecb.StateDelete = 0; if (date != null && date != "") { DateTime tempdate = clsPersianDate.ShamsiToMiladi(date).Value; ecb.Uploaddate = tempdate; } ecb.IdStore = exo.IdStore; ecb.CustomerFullName = exo.CustomerFullName; await db.SaveChangesAsync(); List <RecordEntryExitOrder> _listprops = new List <RecordEntryExitOrder>(); RecordEntryExitOrder _p = null; foreach (var item in prop.ListProps) { Record_the_entry re = db.Record_the_entry.Find(item.Id); re.ExitState = true; await db.SaveChangesAsync(); _p = new RecordEntryExitOrder(); _p.IdExitOrder = exo.Id; _p.IdRecordEntry = item.Id; _p.StateExit = false; _listprops.Add(_p); } db.RecordEntryExitOrder.AddRange(_listprops); await db.SaveChangesAsync(); return(Json("Ok", JsonRequestBehavior.AllowGet)); } }
public async Task <ActionResult> RegisterCopeReserve(CopsBooking cb, string date, ItemPropSelect prop) { if (cb.Id == 0) { cb.StateDelete = 0; if (date != null && date != "") { DateTime tempdate = clsPersianDate.ShamsiToMiladi(date).Value; cb.DateExpired = tempdate; } cb.IdState = 1; db.CopsBooking.Add(cb); await db.SaveChangesAsync(); List <RecordEntryCopsBooking> _listprops = new List <RecordEntryCopsBooking>(); RecordEntryCopsBooking _p = null; foreach (var item in prop.ListProps) { _p = new RecordEntryCopsBooking(); _p.IdCopsBooking = cb.Id; _p.IdRecordEntry = item.Id; _p.StateExit = false; if (_listprops.Where(p => p.IdRecordEntry == item.Id).Any()) { continue; } _listprops.Add(_p); Record_the_entry re = db.Record_the_entry.Find(item.Id); re.StateCopReserve = true; await db.SaveChangesAsync(); } db.RecordEntryCopsBooking.AddRange(_listprops); await db.SaveChangesAsync(); return(Json("Ok", JsonRequestBehavior.AllowGet)); } else { var deleteprops = db.RecordEntryCopsBooking.Where(p => p.IdCopsBooking == cb.Id); db.RecordEntryCopsBooking.RemoveRange(deleteprops); await db.SaveChangesAsync(); CopsBooking ecb = db.CopsBooking.Find(cb.Id); ecb.StateDelete = 0; if (date != null && date != "") { DateTime tempdate = clsPersianDate.ShamsiToMiladi(date).Value; ecb.DateExpired = tempdate; } ecb.IdState = 1; ecb.IdStore = cb.IdStore; ecb.CustomerFullName = cb.CustomerFullName; await db.SaveChangesAsync(); List <RecordEntryCopsBooking> _listprops = new List <RecordEntryCopsBooking>(); RecordEntryCopsBooking _p = null; foreach (var item in prop.ListProps) { Record_the_entry re = db.Record_the_entry.Find(item.Id); re.StateCopReserve = true; await db.SaveChangesAsync(); _p = new RecordEntryCopsBooking(); _p.IdCopsBooking = cb.Id; _p.IdRecordEntry = item.Id; _p.StateExit = false; _listprops.Add(_p); } db.RecordEntryCopsBooking.AddRange(_listprops); await db.SaveChangesAsync(); return(Json("Ok", JsonRequestBehavior.AllowGet)); } }