public ActionResult ShippingList(String sortDirection)
{
PackageListViewModel model = new PackageListViewModel();
List <Package> packages = PackageDataAccess.GetPackageList();
if (string.IsNullOrEmpty(sortDirection) == false)
{
if (sortDirection == "asc")
{
packages.Sort();
}
else
{
packages = packages.OrderByDescending(x => x.Sender.LastName).ToList();
}
//put the sorted list back in session
FileHelper.savePackageListToJsonFile(packages);
}
model.Packages.AddRange(packages);
return(View(model));
}
public IActionResult Admin(string filter, int pageNumber = 1)
{
TempData["filter"] = filter;
ViewBag.Updated = TempData["updated"];
//Setting up the messages passed through temp data from closure request
ViewBag.IsClosureProcessed = TempData["IsClosureProcessed"];
ViewBag.ClosureRequestMessage = TempData["ClosureRequestMessage"];
Func <Package, bool> filterFunction = package => String.IsNullOrEmpty(filter) || package.Name.CaseInsensitiveContains(filter) ||
package.Client.Name.CaseInsensitiveContains(filter);
PackageListViewModel vm = new PackageListViewModel
{
CurrentFilter = filter,
Packages = _packagesRepo.Packages
.Include(p => p.Client)
.Where(filterFunction)
.OrderBy(r => r.Name)
.Skip((pageNumber - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = pageNumber,
ItemsPerPage = PageSize,
TotalItems = _packagesRepo.Packages.Count(filterFunction)
}
};
TempData["filter"] = filter;
return(View(vm));
}
public ActionResult Category6()
{
DistributionCentre centre = db.Users.FirstOrDefault(a => a.Login == User.Identity.Name).AccountReferences.FirstOrDefault()?.DistributionCentre;
List <Package> suitablePackages = GetSuitablePackages(Statuses[4], centre);
PackageListViewModel list = new PackageListViewModel(suitablePackages, "В пункте выдачи", centre);
return(View("Index", list));
}
public ActionResult Category10()
{
DistributionCentre centre = db.Users.FirstOrDefault(a => a.Login == User.Identity.Name).AccountReferences.FirstOrDefault()?.DistributionCentre;
List <Package> suitablePackages = GetSuitablePackages(null, centre);
PackageListViewModel list = new PackageListViewModel(suitablePackages, "Без статуса", centre);
return(View("Index", list));
}
// GET: User
public ActionResult Index()
{
IEnumerable <Package> packages = db.UserPackages.Where(a => a.User.Login == User.Identity.Name).Select(a => a.Package);
PackageListViewModel list = new PackageListViewModel(packages, null, null);
ViewBag.suitedPackages = null;
ViewBag.wasSearch = false;
return(View(list));
}
public ActionResult Category8()
{
DistributionCentre centre = db.Users.FirstOrDefault(a => a.Login == User.Identity.Name).AccountReferences.FirstOrDefault()?.DistributionCentre;
List <Package> suitablePackages = GetSuitablePackages(Statuses[7], centre);
suitablePackages.AddRange(GetSuitablePackages(Statuses[8], centre));
suitablePackages.AddRange(GetSuitablePackages(Statuses[9], centre));
PackageListViewModel list = new PackageListViewModel(suitablePackages, "Возвраты", centre);
return(View("Index", list));
}
/// <summary>
/// List the specified page.
/// </summary>
/// <param name="page">The page.</param>
/// <returns></returns>
public ActionResult Index(int?page)
{
var viewModel = new PackageListViewModel();
var pageNumber = (page ?? 1) - 1;
long totalCount;
IEnumerable <IPackage> packages = PackageService.GetAll(pageNumber, PageSize, out totalCount);
viewModel.Packages = new StaticPagedList <IPackage>(packages, pageNumber + 1, PageSize, (int)totalCount);
return(View(viewModel));
}
public async Task <_ListViewModel <PackageListViewModel> > GetPackagesByRSIOrgIdAsync(int rsiOrgId)
{
_ListViewModel <PackageListViewModel> model = new _ListViewModel <PackageListViewModel>();
try
{
using (var conn = new SqlConnection(SqlHelper.GetConnectionString()))
{
var parameters = new[]
{
new SqlParameter("@RSIOrgId", rsiOrgId)
};
var rdr = await SqlHelper.ExecuteReaderAsync(
conn,
CommandType.StoredProcedure,
"[dbo].[GetPackagesByRSIOrgId]",
parameters);
if (rdr.HasRows)
{
while (rdr.Read())
{
PackageListViewModel tmp = new PackageListViewModel()
{
PackageId = !rdr.IsDBNull(0) ? Decimal.ToInt32(rdr.GetDecimal(0)) : 0,
Name = !rdr.IsDBNull(1) ? rdr.GetString(1) : "",
CondoWeeks = !rdr.IsDBNull(2) ? rdr.GetInt32(2) : 0,
RCIWeeks = !rdr.IsDBNull(3) ? rdr.GetInt32(3) : 0,
Points = !rdr.IsDBNull(4) ? int.Parse(rdr.GetString(4)) : 0,
IsUnlimitedPoints = !rdr.IsDBNull(5) ? Decimal.ToInt16(rdr.GetDecimal(5)) == 1 ? true : false : false
};
model.Rows.Add(tmp);
}
model.TotalCount = model.Rows.Count;
model.Message = "Success";
}
}
}
catch (Exception ex)
{
if (model == null)
{
model = new _ListViewModel <PackageListViewModel>();
}
model.Message = $"Error: {ex.Message}";
}
return(model);
}
// GET: admin/Package
public ActionResult list(int page = 1, int pageSize = 20)
{
int totalCount = 0;
PagedList <Package> InfoPager = packageBll.FindPageList(page, pageSize, out totalCount, "Id", true).AsQueryable().ToPagedList(page, pageSize);
InfoPager.TotalItemCount = totalCount;
InfoPager.CurrentPageIndex = page;
//数据组装到viewModel
PackageListViewModel index = new PackageListViewModel();
index.Infos = InfoPager;
return(View(index));
}
public ActionResult Index(PackageListViewModel model)
{
var new_model = model;
if (ModelState.IsValid)
{
//сохраняем настройки фильтра
Session[PackageControllerIndexKey] = new Dictionary <string, object>();
var settings = Session[PackageControllerIndexKey] as IDictionary <string, object>;
if (!settings.ContainsKey(DateBeginKey))
{
settings.Add(DateBeginKey, model.BeginDate);
}
else
{
settings[DateBeginKey] = model.BeginDate;
}
if (!settings.ContainsKey(DateEndKey))
{
settings.Add(DateEndKey, model.EndDate);
}
else
{
settings[DateEndKey] = model.EndDate;
}
if (!settings.ContainsKey(ControllerKey))
{
settings.Add(ControllerKey, model.SelectedControllerId);
}
else
{
settings[ControllerKey] = model.SelectedControllerId;
}
if (!settings.ContainsKey(OrgKey))
{
settings.Add(OrgKey, model.SelectedOgvId);
}
else
{
settings[OrgKey] = model.SelectedOgvId;
}
model = CreateModel(model.BeginDate, model.EndDate, model.SelectedControllerId, model.SelectedOgvId);
}
return(View(model));
}
/*
* 0 <string>Зарегистрировано</string>
* 1 <string>Ожидается отправка</string>
* 2 <string>Отправлено в пункт назначения</string>
* 3 <string>Прибыло в пункт назначения</string>
* 4 <string>Доставлено в пункт выдачи</string>
* 5 <string>Передано курьеру</string>
* 6 <string>Доставлено</string>
* 7 <string>Будет возвращено отправителю</string>
* 8 <string>Прибыло для возврата отправителю</string>
* 9 <string>Возвращено отправителю</string>
* 10 <string>Отменено</string>
*/
#region categories
// GET: Admin
public ActionResult Index()
{
DistributionCentre centre = db.Users.FirstOrDefault(a => a.Login == User.Identity.Name).AccountReferences.FirstOrDefault()?.DistributionCentre;
IEnumerable <Package> packages;
if (centre == null)
{
packages = db.Packages.Include(p => p.PersonFrom).Include(p => p.PersonTo).Include(p => p.Tariff);
}
else
{
packages = db.Packages.Where(a => a.PersonFrom.CentreId == centre.Id || a.PersonFrom.CityId == centre.CityId);
}
PackageListViewModel list = new PackageListViewModel(packages, "Все", centre);
return(View(list));
}
public IHttpResponse Pending()
{
var packages = this.Db.Packages.Where(p => p.Status == Status.Pending).Select(package => new PackageDetailViewModel()
{
Id = package.Id,
Description = package.Description,
ShippingAddress = package.ShippingAddress,
Weight = package.Weight,
Recipient = package.Recipient.Username
}).ToList();
var model = new PackageListViewModel()
{
Packages = packages
};
return(this.View(model));
}
public IHttpResponse Shipped()
{
var packages = this.Db.Packages.Where(p => p.Status == Status.Shipped).Select(package => new PackageDetailViewModel()
{
Id = package.Id,
Description = package.Description,
EstimateDeliveryDate = package.EstimateDeliveryDate.ToString(),
Weight = package.Weight,
Recipient = package.Recipient.Username
}).ToList();
var model = new PackageListViewModel()
{
Packages = packages
};
return(this.View(model));
}
public List <PackageListViewModel> GetPackages()
{
string selectStatement = "SELECT PackageId, PkgName, PkgStartDate FROM Packages ORDER BY PackageId";
SqlConnection conn = new SqlConnection(connString);
SqlCommand selectCommand = new SqlCommand(selectStatement, conn);
try
{
conn.Open();
SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.CloseConnection);
List <PackageListViewModel> data = new List <PackageListViewModel>();
while (reader.Read())
{
DateTime today = DateTime.Now;
PackageListViewModel p = new PackageListViewModel();
p.PackageId = Convert.ToInt32(reader["PackageId"]);
p.PkgName = reader["PkgName"].ToString();
DateTime PkgStartDate = Convert.ToDateTime(reader["PkgStartDate"]);
if (PkgStartDate < today)
{
p.expired = true;
}
else
{
p.expired = false;
}
data.Add(p);
}
reader.Close();
return(data);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
return(null);
}
finally
{
conn.Close();
}
}
private PackageListViewModel CreateModel(DateTime beginDate, DateTime endDate, Int64 controllerId = -1, Int64 orgId = -1)
{
var user_srv = CompositionRoot.Resolve <IUserService>();
var status_srv = CompositionRoot.Resolve <IFileStatusService>();
var org_srv = CompositionRoot.Resolve <IOrganizationService>();
var package_srv = CompositionRoot.Resolve <IPackageService>();
var model = new PackageListViewModel();
model.SelectedOgvId = orgId == -1 ? Organization.All.Id : orgId;
model.SelectedControllerId = controllerId == -1 ? mfc.domain.entities.User.All.Id : controllerId;
model.BeginDate = beginDate;
model.EndDate = endDate;
//заполняем список всеми контролерами
foreach (var user in user_srv.GetControllers())
{
model.Controllers.Add(user);
}
model.Controllers.Insert(0, mfc.domain.entities.User.All);
//заполняем список всеми организациями
model.Organizations.Add(Organization.All);
foreach (var item in org_srv.GetAllOrganizations())
{
model.Organizations.Add(item);
}
foreach (var package in package_srv.GetPackages(model.BeginDate, model.EndDate, model.SelectedControllerId, model.SelectedOgvId))
{
model.Packages.Add(package);
}
return(model);
}
