private object GetExitOrder(int PageNumber)
{
if (PageNumber <= 0)
{
PageNumber = 1;
}
int PageSkip = (PageNumber - 1) * PageOffSet;
string UserIdcookie = "";
UserIdcookie = Request.Cookies["UserId"].Value;
string _Id = UserIdcookie;
long Id = Convert.ToInt16(CreatHash.Decrypt(_Id));
Users admin = db.Users.FirstOrDefault(p => p.Id == Id);
List <UserRole> usr = db.UserRole.Where(p => p.IdUser == admin.Id).ToList();
UserStoreRole UserStoreRole = db.UserStoreRole.Where(p => p.IdUser == admin.Id).FirstOrDefault();
if (usr.Where(p => p.IdRole == 8).Any())
{
var lists = db.Exitorder.Where(p => p.StateDelete == 0 && p.IdState != 4 && p.IdState != 2)
.ToList()
.Select(p => new listRecordEntryExitOrder
{
Id = p.Id,
CustomerFullName = p.CustomerFullName,
Uploaddate = clsPersianDate.MiladiToShamsi(p.Uploaddate),
StoreName = p.Store.Name,
stateName = p.State.Name,
RecordEntryExitOrderCount = p.RecordEntryExitOrder.Where(q => q.IdExitOrder == p.Id).Count()
}).OrderBy(u => u.Id)
.Skip(PageSkip)
.Take(PageOffSet)
.ToList();
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
_vmReportBargirt.AllPage = (db.Exitorder.Where(p => p.StateDelete == 0).Count() / 10) + 1;
return(_vmReportBargirt);
}
else
{
var lists = db.Exitorder.Where(p => p.StateDelete == 0 && p.IdStore == UserStoreRole.IdStore)
.ToList()
.Select(p => new listRecordEntryExitOrder
{
Id = p.Id,
CustomerFullName = p.CustomerFullName,
Uploaddate = clsPersianDate.MiladiToShamsi(p.Uploaddate),
StoreName = p.Store.Name,
stateName = p.State.Name,
RecordEntryExitOrderCount = p.RecordEntryExitOrder.Where(q => q.IdExitOrder == p.Id).Count()
}).OrderBy(u => u.Id)
.Skip(PageSkip)
.Take(PageOffSet)
.ToList();
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
_vmReportBargirt.AllPage = (db.Exitorder.Where(p => p.StateDelete == 0).Count() / 10) + 1;
return(_vmReportBargirt);
}
}
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));
}
}
private object SGetExitOrder(listRecordEntryExitOrder vmr)
{
string UserIdcookie = "";
UserIdcookie = Request.Cookies["UserId"].Value;
string _Id = UserIdcookie;
long Id = Convert.ToInt16(CreatHash.Decrypt(_Id));
Users admin = db.Users.FirstOrDefault(p => p.Id == Id);
List <UserRole> usr = db.UserRole.Where(p => p.IdUser == admin.Id).ToList();
UserStoreRole UserStoreRole = db.UserStoreRole.Where(p => p.IdUser == admin.Id).FirstOrDefault();
if (usr.Where(p => p.IdRole == 8).Any())
{
var lists = db.Exitorder.Where(p => p.StateDelete == 0 && p.IdState != 4 && p.IdState != 2)
.ToList()
.Select(p => new listRecordEntryExitOrder
{
Id = p.Id,
CustomerFullName = p.CustomerFullName,
Uploaddate = clsPersianDate.MiladiToShamsi(p.Uploaddate),
StoreName = p.Store.Name,
stateName = p.State.Name,
RecordEntryExitOrderCount = p.RecordEntryExitOrder.Where(q => q.IdExitOrder == p.Id).Count()
}).ToList();
if (vmr.Uploaddate != null)
{
lists = lists.Where(p => p.Uploaddate == vmr.Uploaddate).ToList();
}
if (vmr.CustomerFullName != null)
{
lists = lists.Where(p => p.CustomerFullName.Contains(vmr.CustomerFullName)).ToList();
}
if (vmr.StoreName != null)
{
lists = lists.Where(p => p.StoreName.Contains(vmr.StoreName)).ToList();
}
if (vmr.RecordEntryExitOrderCount != 0)
{
lists = lists.Where(p => p.RecordEntryExitOrderCount == vmr.RecordEntryExitOrderCount).ToList();
}
if (vmr.stateName != null)
{
lists = lists.Where(p => p.stateName.Contains(vmr.stateName)).ToList();
}
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
return(_vmReportBargirt);
}
else
{
var lists = db.Exitorder.Where(p => p.StateDelete == 0 && p.IdStore == UserStoreRole.IdStore)
.ToList()
.Select(p => new listRecordEntryExitOrder
{
Id = p.Id,
CustomerFullName = p.CustomerFullName,
Uploaddate = clsPersianDate.MiladiToShamsi(p.Uploaddate),
StoreName = p.Store.Name,
stateName = p.State.Name,
RecordEntryExitOrderCount = p.RecordEntryExitOrder.Where(q => q.IdExitOrder == p.Id).Count()
}).ToList();
if (vmr.Uploaddate != "" || vmr.Uploaddate != null)
{
lists = lists.Where(p => p.Uploaddate == vmr.Uploaddate).ToList();
}
if (vmr.CustomerFullName != null)
{
lists = lists.Where(p => p.CustomerFullName.Contains(vmr.CustomerFullName)).ToList();
}
if (vmr.StoreName != null)
{
lists = lists.Where(p => p.StoreName.Contains(vmr.StoreName)).ToList();
}
if (vmr.RecordEntryExitOrderCount != 0)
{
lists = lists.Where(p => p.RecordEntryExitOrderCount == vmr.RecordEntryExitOrderCount).ToList();
}
if (vmr.stateName != null)
{
lists = lists.Where(p => p.stateName.Contains(vmr.stateName)).ToList();
}
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
return(_vmReportBargirt);
}
}
