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); } }