public async Task <ActionResult> RegisterExitPaper(Driver _driver, ItemPropSelect prop)
{
db.Driver.Add(_driver);
await db.SaveChangesAsync();
List <DriverREO> _listprops = new List <DriverREO>();
DriverREO _p = null;
foreach (var item in prop.ListProps)
{
RecordEntryExitOrder reo = db.RecordEntryExitOrder.Find(item.Id);
reo.StateExit = true;
await db.SaveChangesAsync();
_p = new DriverREO();
_p.IdDriver = _driver.Id;
_p.IdREO = item.Id;
_listprops.Add(_p);
}
db.DriverREO.AddRange(_listprops);
await db.SaveChangesAsync();
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> mgnUser(Users user, ItemPropSelect prop, long?idstore)
{
var pass = CreatHash.HashPass(user.Password);
if (user.Id == 0)
{
user.StateDelete = 0;
user.StateAdmin = false;
user.Password = pass;
db.Users.Add(user);
await db.SaveChangesAsync();
List <UserRole> _listprops = new List <UserRole>();
UserRole _p = null;
if (idstore != null && idstore != 0)
{
UserStoreRole usst = new UserStoreRole();
Store store = db.Store.Find(idstore);
usst.IdStore = store.Id;
usst.IdUser = user.Id;
db.UserStoreRole.Add(usst);
await db.SaveChangesAsync();
}
foreach (var item in prop.ListProps)
{
_p = new UserRole();
_p.IdUser = user.Id;
_p.IdRole = item.Id;
_listprops.Add(_p);
}
db.UserRole.AddRange(_listprops);
await db.SaveChangesAsync();
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
else
{
var deleteprops = db.UserRole.Where(p => p.IdUser == user.Id);
db.UserRole.RemoveRange(deleteprops);
await db.SaveChangesAsync();
Users eUser = db.Users.Find(user.Id);
eUser.StateDelete = 0;
eUser.Password = pass;
eUser.Email = eUser.Email;
eUser.FullName = eUser.FullName;
eUser.UserName = eUser.UserName;
await db.SaveChangesAsync();
List <UserRole> _listprops = new List <UserRole>();
UserRole _p = null;
foreach (var item in prop.ListProps)
{
_p = new UserRole();
_p.IdUser = eUser.Id;
_p.IdRole = item.Id;
_listprops.Add(_p);
}
db.UserRole.AddRange(_listprops);
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));
}
}
