public async Task <ActionResult> Index()
{
CarrierRatingRepository rep = new CarrierRatingRepository();
var allcarriers = await rep.GetAll();
CarrierRepository cRep = new CarrierRepository();
var rated = allcarriers.GroupBy(x => new { x.Carrier.Name })
.Select(u => new
{
Carrier = u.Key.Name,
Stars = u.Sum(z => z.Stars) / u.Count()
});
var ratedList = new List <CarrierRating>();
foreach (var item in rated)
{
ratedList.Add(new CarrierRating {
Stars = item.Stars, Carrier = new Carrier()
{
Name = item.Carrier
}
});
}
return(View(ratedList));
}
/// <summary>
///
/// </summary>
/// <param name="contactBlackCarrier">是否包含黑名单 </param>
/// <returns></returns>
public static List <CarrierEntity> GetCarrierAll(bool contactBlackCarrier = true)
{
List <CarrierEntity> all = new List <CarrierEntity>();
CarrierRepository mr = new CarrierRepository();
List <CarrierInfo> miList = Cache.Get <List <CarrierInfo> >("CarrierALL");
//供应商黑名单
List <BlackListEntity> blackList = BlackListService.GetBlackListAll();
if (miList.IsEmpty())
{
miList = mr.GetAllCarrier();
Cache.Add("CarrierALL", miList);
}
if (!miList.IsEmpty())
{
foreach (CarrierInfo mInfo in miList)
{
if (!contactBlackCarrier && blackList != null && blackList.Count > 0 && blackList.Find(p => p.BlackType.Equals("Carrier") && p.UnionID == mInfo.CarrierID) != null)
{
}
else
{
CarrierEntity CarrierEntity = TranslateCarrierEntity(mInfo, true);
all.Add(CarrierEntity);
}
}
}
return(all);
}
public List <FrayteCarrierModel> GetCarrierList(string carrierType)
{
List <FrayteCarrierModel> lstCarrier = new List <FrayteCarrierModel>();
lstCarrier = new CarrierRepository().GetCarrierList(carrierType);
return(lstCarrier);
}
public void TestInitialize()
{
_context = new DbTestContext(Settings.Default.MainConnectionString);
_fixture = new Fixture();
_repository = new CarrierRepository(new PasswordConverter(),
new SqlProcedureExecutor(Settings.Default.MainConnectionString));
}
// GET api/carriers
public IHttpActionResult Get()
{
var repository = new CarrierRepository();
var carriers = repository.List();
var models = carriers.ToModel();
return(Ok(models));
}
public FrayteResult DeleteCarrier(int carrierId)
{
FrayteResult result = new FrayteResult();
result = new CarrierRepository().DeleteCarrier(carrierId);
return(result);
}
public List <FrayteCarrier> GetCarrierList()
{
List <FrayteCarrier> lstCarrier = new List <FrayteCarrier>();
lstCarrier = new CarrierRepository().GetCarrierList();
return(lstCarrier);
}
public static CarrierEntity GetCarrierById(long gid)
{
CarrierEntity result = new CarrierEntity();
CarrierRepository mr = new CarrierRepository();
CarrierInfo info = mr.GetCarrierByKey(gid);
result = TranslateCarrierEntity(info);
return(result);
}
public async Task <ActionResult> Index()
{
CarrierRepository rep = new CarrierRepository();
var allcarriers = await rep.GetAll();
ViewBag.UserLogged = Session["LogedUserFullname"];
return(View(allcarriers));
}
public static int Remove(long gid)
{
CarrierRepository mr = new CarrierRepository();
int i = mr.Remove(gid);
//List<CarrierInfo> miList = mr.GetAllCarrier();//刷新缓存
//Cache.Add("CarrierALL", miList);
return(i);
}
/// <summary>
/// convert packlingList to list model
/// </summary>
/// <param name="packingList"></param>
/// <returns></returns>
public PackingListViewModel ConvertToListView(PackingList packingList)
{
PackingListViewModel model = new PackingListViewModel();
var _customerDynamicsRepository = new CustomerDynamicsRepository();
var _customerAddressDynamicsRepository = new CustomerAddressDynamicsRepository();
var _stateRepository = new StateRepository();
var _carrierRepository = new CarrierRepository();
var dynamicsCustomer = _customerDynamicsRepository.GetCustomer(packingList.CustomerId);
var dynamicsCustomerAddress = _customerAddressDynamicsRepository.GetCustomerAddress(packingList.CustomerAddressId);
var state = _stateRepository.GetState((dynamicsCustomerAddress != null && !string.IsNullOrEmpty(dynamicsCustomerAddress.STATE)) ? dynamicsCustomerAddress.STATE : string.Empty);
var stateName = (state != null && !string.IsNullOrEmpty(state.Name)) ? ", " + state.Name : string.Empty;
var carrier = _carrierRepository.GetCarrier(packingList.CarrierId);
model.PackingListId = packingList.PackingListId;
model.CreatedDate = (packingList.CreatedDate != null) ? packingList.CreatedDate : DateTime.MinValue;
model.CreatedDateStr = (packingList.CreatedDate != null) ? packingList.CreatedDate.Value.ToShortDateString() : "N/A";
model.CustomerName = (dynamicsCustomer != null && !string.IsNullOrEmpty(dynamicsCustomer.SHRTNAME)) ? dynamicsCustomer.SHRTNAME : "N/A";
model.CustomerAddress = (dynamicsCustomerAddress != null) ? dynamicsCustomerAddress.ADDRESS1 + " " +
dynamicsCustomerAddress.CITY + ", " + stateName : "N/A";
model.ShipDate = packingList.ShipDate;
model.ShipDateStr = packingList.ShipDate.ToShortDateString();
model.CarrierName = (carrier != null && !string.IsNullOrEmpty(carrier.Name)) ? carrier.Name : "N/A";
model.TrackingNumber = (!string.IsNullOrEmpty(packingList.TrackingNumber)) ? packingList.TrackingNumber : "N/A";
model.Notes = (!string.IsNullOrEmpty(packingList.TrackingNumber)) ? packingList.Notes : "N/A";
model.IsClosed = packingList.IsClosed;
model.ClosedDate = (packingList.ClosedDate != null) ? packingList.ClosedDate : DateTime.MinValue;
model.ClosedDateStr = (packingList.ClosedDate != null) ? packingList.ClosedDate.Value.ToShortDateString() : "N/A";
if (_customerDynamicsRepository != null)
{
_customerDynamicsRepository.Dispose();
_customerDynamicsRepository = null;
}
if (_customerAddressDynamicsRepository != null)
{
_customerAddressDynamicsRepository.Dispose();
_customerAddressDynamicsRepository = null;
}
if (_stateRepository != null)
{
_stateRepository.Dispose();
_stateRepository = null;
}
if (_carrierRepository != null)
{
_carrierRepository.Dispose();
_carrierRepository = null;
}
return(model);
}
public void SetUp()
{
var repository = new CarrierRepository(Context);
var repositoryEmpty = new CarrierRepository(ContextEmpty);
var service = new CarrierService(repository, Mapper);
var serviceEmpty = new CarrierService(repositoryEmpty, Mapper);
_carriersController = new CarriersController(service);
_carriersControllerEmpty = new CarriersController(serviceEmpty);
}
public async Task <ActionResult> RateCarrier()
{
CarrierRepository rep = new CarrierRepository();
var allcarriers = await rep.GetAll();
List <SelectListItem> list = allcarriers.Select(x => new SelectListItem {
Value = x.Name, Text = x.Name
}).ToList();
ViewBag.carrierNames = list;
return(View());
}
public static List <CarrierEntity> GetCarrierInfoPager(PagerInfo pager)
{
List <CarrierEntity> all = new List <CarrierEntity>();
CarrierRepository mr = new CarrierRepository();
List <CarrierInfo> miList = mr.GetAllCarrierInfoPager(pager);
foreach (CarrierInfo mInfo in miList)
{
CarrierEntity carEntity = TranslateCarrierEntity(mInfo);
all.Add(carEntity);
}
return(all);
}
public static CarrierEntity GetCarrierEntityById(long cid)
{
CarrierEntity result = new CarrierEntity();
CarrierRepository mr = new CarrierRepository();
CarrierInfo info = mr.GetCarrierByKey(cid);
if (info != null)
{
result = TranslateCarrierEntity(info);
//获取联系人信息
result.listContact = ContactService.GetContactByRule(UnionType.Carrier.ToString(), info.CarrierID);
}
return(result);
}
public static List <CarrierEntity> GetCarrierInfoByRule(string name, string mcode, int status, PagerInfo pager)
{
List <CarrierEntity> all = new List <CarrierEntity>();
CarrierRepository mr = new CarrierRepository();
List <CarrierInfo> miList = mr.GetCarrierInfoByRule(name, mcode, status, pager);
if (!miList.IsEmpty())
{
foreach (CarrierInfo mInfo in miList)
{
CarrierEntity storeEntity = TranslateCarrierEntity(mInfo);
all.Add(storeEntity);
}
}
return(all);
}
public static List <CarrierEntity> GetCarrierByKeys(string ids)
{
List <CarrierEntity> all = new List <CarrierEntity>();
CarrierRepository mr = new CarrierRepository();
List <CarrierInfo> miList = mr.GetCarrierByKeys(ids);
if (!miList.IsEmpty())
{
foreach (CarrierInfo mInfo in miList)
{
CarrierEntity entity = TranslateCarrierEntity(mInfo);
all.Add(entity);
}
}
return(all);
}
public async Task <ActionResult> Create(Carrier model)
{
if (ModelState.IsValid)
{
CarrierRepository rep = new CarrierRepository();
if (rep.GetByName(model.Name).Result == null)
{
throw new Exception("This Carrier already exists.");
}
else
{
var allcarriers = await rep.AddCarrier(model);
}
}
return(RedirectToAction("Index"));
}
public CarrierApiController(CarrierRepository repository)
{
this.repository = repository;
this.OnCreated();
}
// Constructor
private CarrierUseCase()
{
repository = CarrierRepository.OpenRepository();
}
public static bool ModifyCarrier(CarrierEntity entity)
{
long result = 0;
if (entity != null)
{
CarrierRepository mr = new CarrierRepository();
CarrierInfo CarrierInfo = TranslateCarrierInfo(entity);
ContactJsonEntity jsonlist = null;
if (!string.IsNullOrEmpty(entity.ContactJson))
{
try
{
jsonlist = (ContactJsonEntity)JsonHelper.FromJson(entity.ContactJson, typeof(ContactJsonEntity));
}
catch (Exception ex)
{
string str = ex.ToString();
}
}
if (entity.CarrierID > 0)
{
CarrierInfo.CarrierID = entity.CarrierID;
CarrierInfo.ChangeDate = DateTime.Now;
result = mr.ModifyCarrier(CarrierInfo);
}
else
{
CarrierInfo.ChangeDate = DateTime.Now;
CarrierInfo.CreateDate = DateTime.Now;
result = mr.CreateNew(CarrierInfo);
}
#region 更新联系人信息
if (jsonlist != null)
{
List <ContactJson> list = jsonlist.listContact;
if (list != null && list.Count > 0)
{
foreach (ContactJson cc in list)
{
ContactRepository cr = new ContactRepository();
ContactInfo contact = new ContactInfo();
contact.ContactName = cc.ContactName;
contact.Mobile = cc.Mobile;
contact.Telephone = cc.Telephone;
contact.Email = cc.Email;
contact.Remark = cc.Remark;
contact.UnionType = UnionType.Carrier.ToString();//承运商
if (cc.ContactID > 0)
{
contact.ContactID = cc.ContactID;
contact.UnionID = entity.CarrierID;
contact.ChangeDate = DateTime.Now;
cr.ModifyContact(contact);
}
else
{
contact.UnionID = entity.CarrierID > 0 ? entity.CarrierID : result;
contact.CreateDate = DateTime.Now;
contact.ChangeDate = DateTime.Now;
cr.CreateNew(contact);
}
}
}
}
#endregion
List <CarrierInfo> miList = mr.GetAllCarrier();//刷新缓存
Cache.Add("CarrierALL", miList);
}
return(result > 0);
}
/// <summary>
/// convert packing list to view model
/// </summary>
/// <param name="packingList"></param>
/// <returns></returns>
public PackingListViewModel ConvertToView(PackingList packingList)
{
PackingListViewModel model = new PackingListViewModel();
var _customerDynamicsRepository = new CustomerDynamicsRepository();
var _customerAddressDynamicsRepository = new CustomerAddressDynamicsRepository();
var _stateRepository = new StateRepository();
var _carrierRepository = new CarrierRepository();
var _packingListRepository = new PackingListRepository();
var dynamicsCustomer = _customerDynamicsRepository.GetCustomer(packingList.CustomerId);
var dynamicsCustomerAddress = _customerAddressDynamicsRepository.GetCustomerAddress(packingList.CustomerAddressId);
var state = _stateRepository.GetState((dynamicsCustomerAddress != null && !string.IsNullOrEmpty(dynamicsCustomerAddress.STATE)) ? dynamicsCustomerAddress.STATE : string.Empty);
var stateName = (state != null && !string.IsNullOrEmpty(state.Name)) ? ", " + state.Name : string.Empty;
var carrier = _carrierRepository.GetCarrier(packingList.CarrierId);
model.PackingListId = packingList.PackingListId;
model.CustomerId = packingList.CustomerId;
model.CustomerName = (dynamicsCustomer != null && !string.IsNullOrEmpty(dynamicsCustomer.SHRTNAME)) ? dynamicsCustomer.SHRTNAME : "N/A";
model.CustomerAddressId = packingList.CustomerAddressId;
model.CustomerAddress = (dynamicsCustomerAddress != null) ? dynamicsCustomerAddress.ADDRESS1 + " " +
dynamicsCustomerAddress.CITY + ", " + stateName : "N/A";
model.ShipDate = packingList.ShipDate;
model.ShipDateStr = packingList.ShipDate.ToShortDateString();
model.Freight = packingList.Freight;
model.CarrierId = packingList.CarrierId;
model.CarrierName = (carrier != null && !string.IsNullOrEmpty(carrier.Name)) ? carrier.Name : "N/A";
model.TrailerNumber = (!string.IsNullOrEmpty(packingList.TrailerNumber)) ? packingList.TrailerNumber : "N/A";
model.TrackingNumber = (!string.IsNullOrEmpty(packingList.TrackingNumber)) ? packingList.TrackingNumber : "N/A";
model.Notes = (!string.IsNullOrEmpty(packingList.Notes)) ? packingList.Notes : "N/A";
model.NetWeight = packingList.NetWeight;
model.GrossWeight = packingList.GrossWeight;
model.DeliveryDate = (packingList.DeliveryDate != null) ? packingList.DeliveryDate : DateTime.MinValue;;
model.DeliveryDateStr = (packingList.DeliveryDate != null) ? packingList.DeliveryDate.Value.ToShortDateString() : "N/A";
model.IsClosed = packingList.IsClosed;
model.ClosedDate = (packingList.ClosedDate != null) ? packingList.ClosedDate : DateTime.MinValue;
model.ClosedDateStr = (packingList.ClosedDate != null) ? packingList.ClosedDate.Value.ToShortDateString() : "N/A";
model.CreatedDate = (packingList.CreatedDate != null) ? packingList.CreatedDate : DateTime.MinValue;
model.CreatedDateStr = (packingList.CreatedDate != null) ? packingList.CreatedDate.Value.ToShortDateString() : "N/A";
var parts = _packingListRepository.GetPackingListPartsByPackingList(packingList.PackingListId);
if (parts != null && parts.Count > 0)
{
var packingListParts = new List <PackingListPartViewModel>();
foreach (var part in parts)
{
PackingListPartViewModel packingListPart = new PackingListPartConverter().ConvertToView(part);
packingListParts.Add(packingListPart);
}
model.PackingListParts = packingListParts.OrderBy(x => x.ShipCode).ThenBy(y => y.PartNumber).ThenBy(z => z.PalletNumber).ToList();
}
if (_customerDynamicsRepository != null)
{
_customerDynamicsRepository.Dispose();
_customerDynamicsRepository = null;
}
if (_customerAddressDynamicsRepository != null)
{
_customerAddressDynamicsRepository.Dispose();
_customerAddressDynamicsRepository = null;
}
if (_stateRepository != null)
{
_stateRepository.Dispose();
_stateRepository = null;
}
if (_carrierRepository != null)
{
_carrierRepository.Dispose();
_carrierRepository = null;
}
if (_packingListRepository != null)
{
_packingListRepository.Dispose();
_packingListRepository = null;
}
return(model);
}
public CarrierService(CarrierRepository carrierRepository)
{
this.carrierRepository = carrierRepository;
}
public async Task SetUp()
{
var options = new DbContextOptionsBuilder <DatabaseContext>()
.UseInMemoryDatabase(databaseName: "TestDb")
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
context = new DatabaseContext(options);
busStopRepository = new BusStopRepository(context);
routeRepository = new RouteRepository(context);
carrierRepository = new CarrierRepository(context);
var routeForTest1 = new Route
{
Id = 1,
Name = "RouteName1",
Carrier = new Carrier
{
Id = 1,
Name = "CarrierName1"
}
};
var routeForTest2 = new Route
{
Id = 2,
Name = "RouteName2",
Carrier = new Carrier
{
Id = 1,
Name = "CarrierName1"
}
};
await busStopRepository.AddBusStopsRangeAsync(new List <BusStop>
{
new BusStop //FirstRoute
{
Id = 1,
Latitude = 5.0,
Longitude = 10.0,
Address = "TestAddress1",
Label = "TestLabel1",
Route = routeForTest1,
Hour = new TimeSpan(12, 0, 0),
},
new BusStop
{
Id = 2,
Latitude = 15.0,
Longitude = 20.0,
Address = "TestAddress2",
Label = "TestLabel2",
Route = routeForTest1,
Hour = new TimeSpan(12, 30, 0),
},
new BusStop
{
Id = 3,
Latitude = 25.0,
Longitude = 30.0,
Address = "TestAddress3",
Label = "TestLabel3",
Route = routeForTest1,
Hour = new TimeSpan(13, 00, 0),
},
new BusStop //SecondRoute
{
Id = 4,
Latitude = 35.0,
Longitude = 40.0,
Address = "TestAddress4",
Label = "TestLabel4",
Route = routeForTest2,
Hour = new TimeSpan(16, 0, 0),
},
new BusStop
{
Id = 5,
Latitude = 45.0,
Longitude = 50.0,
Address = "TestAddress5",
Label = "TestLabel5",
Route = routeForTest2,
Hour = new TimeSpan(17, 0, 0),
},
new BusStop
{
Id = 6,
Latitude = 55.0,
Longitude = 60.0,
Address = "TestAddress6",
Label = "TestLabel6",
Route = routeForTest2,
Hour = new TimeSpan(18, 0, 0),
}
});
await carrierRepository.AddCarrierAsync(new Carrier
{
Id = 2,
Name = "CarrierName2"
});
}
