private object GetExitOrder(int PageNumber)
{
if (PageNumber <= 0)
{
PageNumber = 1;
}
int PageSkip = (PageNumber - 1) * PageOffSet;
var lists = db.Record_the_entry.Where(p => p.StateDelete == 0)
.ToList().Select(p => new listRecordEntryExitOrder
{
Id = p.Id,
Uploaddate = clsPersianDate.MiladiToShamsi(p.Date),
StoreName = p.Store.Name,
copname = p.Cops.Name,
CopCode = p.CopsCod,
minename = p.mine.Name,
Weight = p.Weight,
Dimensions = p.Height.Trim() + "*" + p.width.Trim() + "*" + p.length.Trim(),
Transfernumber = p.Transfernumber,
image = p.Record_the_Entrry_Image.ToList()
}).OrderBy(u => u.Id)
.Skip(PageSkip)
.Take(PageOffSet)
.ToList();
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
_vmReportBargirt.AllPage = (db.Record_the_entry.Where(p => p.StateDelete == 0).Count() / 10) + 1;
return(_vmReportBargirt);
}
private object GetExitOrder(long?id)
{
var lists = (from exo in db.Exitorder
join reo in db.RecordEntryExitOrder
on exo.Id equals reo.IdExitOrder
join re in db.Record_the_entry
on reo.IdRecordEntry equals re.Id
where exo.StateDelete == 0 && exo.Id == id && reo.StateExit == false && exo.IdState == 4
select new { exo, reo, re }).ToList()
.Select(p => new listRecordEntryExitOrder
{
Id = p.reo.Id,
CustomerFullName = p.exo.CustomerFullName,
Uploaddate = clsPersianDate.MiladiToShamsi(p.exo.Uploaddate),
StoreName = p.exo.Store.Name,
minename = p.re.mine.Name,
copname = p.re.Cops.Name,
RecordEntryExitOrderCount = p.exo.RecordEntryExitOrder.Count,
stateName = p.exo.State.Name,
Weight = p.re.Weight,
Dimensions = p.re.length + "*" + p.re.width + "*" + p.re.Height
}).ToList();
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
return(_vmReportBargirt);
}
private object SGetExitOrder(listRecordEntryExitOrder vmr)
{
var lists = db.Exitorder.Where(p => p.StateDelete == 0)
.ToList()
.Select(p => new listRecordEntryExitOrder
{
Id = p.Id,
CustomerFullName = p.CustomerFullName,
Uploaddate = clsPersianDate.MiladiToShamsi(p.Uploaddate),
copname = p.RecordEntryExitOrder.First().Record_the_entry.Cops.Name,
minename = p.RecordEntryExitOrder.First().Record_the_entry.mine.Name,
Weight = p.RecordEntryExitOrder.First().Record_the_entry.Weight,
StoreName = p.Store.Name,
stateName = p.State.Name,
RecordEntryExitOrderCount = p.RecordEntryExitOrder.Where(q => q.IdExitOrder == p.Id).Count(),
}).ToList();
if (vmr.copname != null)
{
lists = lists.Where(p => p.copname.Contains(vmr.copname)).ToList();
}
if (vmr.RecordEntryExitOrderCount != 0)
{
lists = lists.Where(p => p.RecordEntryExitOrderCount == vmr.RecordEntryExitOrderCount).ToList();
}
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
return(_vmReportBargirt);
}
private object GetExitOrder(int PageNumber)
{
if (PageNumber <= 0)
{
PageNumber = 1;
}
int PageSkip = (PageNumber - 1) * PageOffSet;
var lists = db.Exitorder.Where(p => p.StateDelete == 0)
.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;
return(_vmReportBargirt);
}
private object GetExitOrder()
{
long i = 0;
long j = 0;
var lists2 = db.RecordEntryExitOrder.Where(p => p.Exitorder.StateDelete == 0 && p.Exitorder.IdState == 4).ToList();
List <listRecordEntryExitOrder> list = new List <listRecordEntryExitOrder>();
listRecordEntryExitOrder _p = null;
foreach (var item in lists2)
{
i++;
_p = new listRecordEntryExitOrder();
_p.Id = item.Exitorder.Id;
_p.CustomerFullName = item.Exitorder.CustomerFullName;
_p.Uploaddate = clsPersianDate.MiladiToShamsi(item.Exitorder.Uploaddate);
_p.StoreName = item.Exitorder.Store.Name;
_p.RecordEntryExitOrderCount = i;
_p.stateName = item.Exitorder.State.Name;
_p.Weight = item.Record_the_entry.Weight;
if (item.StateExit == false)
{
j++;
}
_p.Countmandeh = j;
}
if (_p != null)
{
list.Add(_p);
}
list = list.Where(p => p.Countmandeh != 0).ToList();
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = list;
return(_vmReportBargirt);
}
private object GetExitOrder(int PageNumber)
{
if (PageNumber <= 0)
{
PageNumber = 1;
}
int PageSkip = (PageNumber - 1) * PageOffSet;
var lists = (from exo in db.Exitorder
join reo in db.RecordEntryExitOrder
on exo.Id equals reo.IdExitOrder
join re in db.Record_the_entry
on reo.IdRecordEntry equals re.Id
where exo.StateDelete == 0
select new { exo, reo, re }).ToList()
.Select(p => new listRecordEntryExitOrder
{
Id = p.exo.Id,
CustomerFullName = p.exo.CustomerFullName,
Uploaddate = clsPersianDate.MiladiToShamsi(p.exo.Uploaddate),
StoreName = p.exo.Store.Name,
copname = p.re.Cops.Name,
minename = p.re.mine.Name,
RecordEntryExitOrderCount = p.exo.RecordEntryExitOrder.Count,
stateName = p.exo.State.Name,
Weight = p.re.Weight
})
.OrderBy(u => u.Id)
.Skip(PageSkip)
.Take(PageOffSet)
.ToList();
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
return(_vmReportBargirt);
}
private object SGetExitOrder(listRecordEntryExitOrder vmr)
{
var lists = db.Record_the_entry.Where(p => p.StateDelete == 0)
.ToList().Select(p => new listRecordEntryExitOrder
{
Id = p.Id,
Uploaddate = clsPersianDate.MiladiToShamsi(p.Date),
StoreName = p.Store.Name,
copname = p.Cops.Name,
CopCode = p.CopsCod,
minename = p.mine.Name,
Weight = p.Weight,
Dimensions = p.length + "*" + p.width + "*" + p.Height,
Transfernumber = p.Transfernumber,
image = p.Record_the_Entrry_Image.ToList()
}).ToList();
if (vmr.Uploaddate != null && vmr.Uploaddate != "")
{
lists = lists.Where(p => p.Uploaddate == vmr.Uploaddate).ToList();
}
if (vmr.minename != null)
{
lists = lists.Where(p => p.minename.Contains(vmr.minename)).ToList();
}
if (vmr.copname != null)
{
lists = lists.Where(p => p.copname.Contains(vmr.copname)).ToList();
}
if (vmr.Weight != null)
{
lists = lists.Where(p => p.Weight == vmr.Weight).ToList();
}
if (vmr.StoreName != null)
{
lists = lists.Where(p => p.StoreName.Contains(vmr.StoreName)).ToList();
}
if (vmr.Transfernumber != null)
{
lists = lists.Where(p => p.Transfernumber.Contains(vmr.Transfernumber)).ToList();
}
if (vmr.Dimensions != null)
{
lists = lists.Where(p => p.Dimensions.Contains(vmr.Dimensions)).ToList();
}
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
return(_vmReportBargirt);
}
private object GetExitOrder(int PageNumber)
{
if (PageNumber <= 0)
{
PageNumber = 1;
}
int PageSkip = (PageNumber - 1) * PageOffSet;
//long i = 0;
long i = 0;
long j = 0;
var lists2 = db.RecordEntryExitOrder.Where(p => p.Exitorder.StateDelete == 0 && p.Exitorder.IdState == 4)
.OrderBy(u => u.Id)
.Skip(PageSkip)
.Take(PageOffSet)
.ToList();
List <listRecordEntryExitOrder> lists = new List <listRecordEntryExitOrder>();
listRecordEntryExitOrder _p = null;
foreach (var item in lists2)
{
i++;
_p = new listRecordEntryExitOrder();
_p.Id = item.Exitorder.Id;
_p.CustomerFullName = item.Exitorder.CustomerFullName;
_p.Uploaddate = clsPersianDate.MiladiToShamsi(item.Exitorder.Uploaddate);
_p.StoreName = item.Exitorder.Store.Name;
_p.RecordEntryExitOrderCount = i;
_p.stateName = item.Exitorder.State.Name;
_p.Weight = item.Record_the_entry.Weight;
_p.DriverName = item.DriverREO.FirstOrDefault().Driver.DriverName;
if (item.StateExit == false)
{
j++;
}
_p.Countmandeh = j;
}
if (_p != null)
{
lists.Add(_p);
}
//var lists = (from exo in db.Exitorder
// join reo in db.RecordEntryExitOrder
// on exo.Id equals reo.IdExitOrder
// join driverREO in db.DriverREO
// on reo.Id equals driverREO.IdREO
// join re in db.Record_the_entry
// on reo.IdRecordEntry equals re.Id
// where exo.StateDelete == 0
// select new { exo, reo, re,driverREO }).ToList()
// .Select(p => new listRecordEntryExitOrder
// {
// Id = p.exo.Id,
// CustomerFullName = p.exo.CustomerFullName,
// Uploaddate = clsPersianDate.MiladiToShamsi(p.exo.Uploaddate),
// StoreName = p.exo.Store.Name,
// RecordEntryExitOrderCount = p.exo.RecordEntryExitOrder.Count,
// stateName = p.exo.State.Name,
// Weight = p.re.Weight,
// Countmandeh = p.reo.StateExit == false ? i++ : 0,
// DriverName=p.driverREO.Driver.DriverName
// }).OrderBy(u => u.Id)
// .Skip(PageSkip)
// .Take(PageOffSet)
// .ToList();
vmReportBargirt _vmReportBargirt = new vmReportBargirt();
_vmReportBargirt.list = lists;
return(_vmReportBargirt);
}
private object SGetExitOrder(listRecordEntryExitOrder vmr)
{
long i = 0;
long j = 0;
var lists2 = db.RecordEntryExitOrder.Where(p => p.Exitorder.StateDelete == 0 && p.Exitorder.IdState == 4).ToList();
List <listRecordEntryExitOrder> lists = new List <listRecordEntryExitOrder>();
listRecordEntryExitOrder _p = null;
foreach (var item in lists2)
{
i++;
_p = new listRecordEntryExitOrder();
_p.Id = item.Exitorder.Id;
_p.CustomerFullName = item.Exitorder.CustomerFullName;
_p.Uploaddate = clsPersianDate.MiladiToShamsi(item.Exitorder.Uploaddate);
_p.StoreName = item.Exitorder.Store.Name;
_p.RecordEntryExitOrderCount = i;
_p.stateName = item.Exitorder.State.Name;
_p.Weight = item.Record_the_entry.Weight;
_p.DriverName = item.DriverREO.FirstOrDefault().Driver.DriverName;
if (item.StateExit == false)
{
j++;
}
_p.Countmandeh = j;
}
if (_p != null)
{
lists.Add(_p);
}
if (vmr.Uploaddate != null && vmr.Uploaddate != "")
{
lists = lists.Where(p => p.Uploaddate.Contains(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);
}
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);
}
}
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);
}
}
