public List <tblWarehouse> GetWarehouseReceivedlist(tblWarehouse tblWarehouse)
{
List <tblWarehouse> list;
try
{
if (tblWarehouse.AddedDate != null)
{
var startDate = DateTime.Today;
var endDate = startDate.AddDays(1).AddTicks(-1);
list = _wcmsEntities.tblWarehouse.Where(a => a.AddedDate >= startDate && a.AddedDate <= endDate).ToList();
}
else
{
list = _wcmsEntities.tblWarehouse
.WhereIf(tblWarehouse.BoxCode != null, x => x.BoxCode == tblWarehouse.BoxCode)
.WhereIf(tblWarehouse.Imei1 != null, x => x.Imei1 == tblWarehouse.Imei1)
.WhereIf(tblWarehouse.Imei2 != null, x => x.Imei2 == tblWarehouse.Imei2)
.AsNoTracking().ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public long UpdateWarehouse(tblWarehouse warehouse)
{
long result = 0;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
var _temp = db.tblWarehouses.Where(x => x.id
== warehouse.id).FirstOrDefault();
if (_temp != null)
{
db.Entry(_temp).CurrentValues.SetValues(warehouse);
//if (db.SaveChanges() > 0)
//{
// result = _temp.id;
//}
db.SaveChanges();
result = _temp.id;
}
}
}
catch (Exception ex)
{
SELog.WriteLog("WareHouseServices => UpdateWarehouse", ex);
}
return(result);
}
public JsonResult UpdateWarehouse(tblWarehouse model)
{
var result = new Models.CustomJsonResult();
model.Status = bool.Parse(Request.Form["Status"]);
try
{
if (model.id > 0)
{
result.Result = _wareHouseServices.UpdateWarehouse(model);
if (int.Parse(result.Result.ToString()) > 0)
{
result.Message = "Update Warehouse Succeed";
}
}
else
{
result.Result = _wareHouseServices.InsertWarehouse(model);
if (int.Parse(result.Result.ToString()) > 0)
{
result.Message = "Create New Warehouse Succeed";
}
}
if (int.Parse(result.Result.ToString()) < 1)
{
result.Message = "Had error, please try again!";
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool InsertWareHouseData(List <tblWarehouse> wareHouseData)
{
try
{
foreach (var warehouse in wareHouseData)
{
//var logisticsSendItems = new tblLogisticsSentItems();
var entity = new tblWarehouse
{
BoxCode = warehouse.BoxCode,
Imei1 = warehouse.Imei1,
Imei2 = warehouse.Imei2,
Color = warehouse.Color,
Model = warehouse.Model,
AddedBy = warehouse.AddedBy,
AddedDate = warehouse.AddedDate
};
_entity.tblWarehouse.Add(entity);
_entity.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
private void Create(Facility facility)
{
var tblWarehouse = new tblWarehouse {
WHID = (OldContext.tblWarehouses.Any() ? OldContext.tblWarehouses.Max(w => w.WHID) : 0) + 1
};
facility.WHID = tblWarehouse.WHID;
OldContext.tblWarehouses.AddObject(tblWarehouse);
Update(tblWarehouse, facility);
}
public ActionResult DetailWareHouse(int id = -1)
{
tblWarehouse warehouse = new tblWarehouse();
if (id != -1)
{
warehouse = _wareHouseServices.SelectByWarehouseID(id);
}
return(View(warehouse));
}
public List <tblWarehouse> GetWarehouseReceivedlist(tblWarehouse tblWarehouse)
{
try
{
ISelectingCommon iDataAccessSelect = new DALGetCommonSelecting();
return(iDataAccessSelect.GetWarehouseReceivedlist(tblWarehouse));
}
catch (Exception ex)
{
throw ex;
}
}
public List <tblWarehouse> GetWarehouseReceivedlist(tblWarehouse tblWarehouse)
{
var list = new List <tblWarehouse>();
try
{
list = _CommonManager.GetWarehouseReceivedlist(tblWarehouse);
}
catch (Exception ex)
{
}
return(list);
}
private static void Update(tblWarehouse tblWarehouse, Facility facility)
{
tblWarehouse.InActive = !facility.Active;
tblWarehouse.WhouseAbbr = facility.Name;
tblWarehouse.Phone = facility.PhoneNumber;
tblWarehouse.Email = facility.EMailAddress;
tblWarehouse.Address1 = facility.Address.AddressLine1;
tblWarehouse.Address2 = facility.Address.AddressLine2;
tblWarehouse.Address3 = facility.Address.AddressLine3;
tblWarehouse.City = facility.Address.City;
tblWarehouse.State = facility.Address.State;
tblWarehouse.Zip = facility.Address.PostalCode;
tblWarehouse.Country = facility.Address.Country;
}
public JsonResult UpdateWarehouse(tblWarehouse model)
{
var service = new UpdateServices();
var res = service.SaveChangesWarehouse(model);
if (res)
{
return(Json(new { success = true }));
}
else
{
return(Json(new { success = false }));
}
}
public tblWarehouse SelectByWarehouseID(int id)
{
tblWarehouse _item = new tblWarehouse();
try
{
using (var db = ContextFactory.UsTransportEntities())
{
_item = db.tblWarehouses.Where(x => x.id == id).FirstOrDefault();
}
}
catch (Exception ex)
{
SELog.WriteLog("WareHouseServices => SelectByWarehouseID", ex);
}
return(_item);
}
public bool SaveWarehouse(tblWarehouse model)
{
using (var dbContextTransaction = _db.Database.BeginTransaction())
{
try
{
_db.Warehouses.Add(model);
_db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(false);
}
}
}
public long InsertWarehouse(tblWarehouse warehouse)
{
long result = 0;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
warehouse.CreateDate = DateTime.Now;
db.tblWarehouses.Add(warehouse);
db.SaveChanges();
result = warehouse.id;
}
}
catch (Exception ex)
{
SELog.WriteLog("WareHouseServices => InsertWarehouse", ex);
}
return(result);
}
public bool SaveChangesWarehouse(tblWarehouse model)
{
using (var dbContextTransaction = _db.Database.BeginTransaction())
{
try
{
tblWarehouse item = _db.Warehouses.Where(x => x.id == model.id).FirstOrDefault();
item.name = model.name;
item.address = model.address;
item.description = model.description;
_db.SaveChanges();
dbContextTransaction.Commit();
return(true);
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(false);
}
}
}
private static bool WarehouseExcluded(tblWarehouse warehouse)
{
return(WarehouseExclusions.Any(w => w == warehouse.WhouseAbbr));
}
public List <ShipmentViewDTO> Admin_SearchShipment(ShipmentSearch model = null)
{
if (model == null)
{
model = new ShipmentSearch
{
WarehouseId = -1,
Keyword = ""
};
}
List <ShipmentViewDTO> lsResult = null;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
lsResult = db.tblShipments
.Where(x => !x.IsDeleted &&
(x.WarehouseId == model.WarehouseId || model.WarehouseId == -1) &&
(x.CreateTime <= model.ToTime && x.CreateTime >= model.FromTime)
)
.Select(x => new ShipmentViewDTO
{
Destination = x.Destination ?? 0,
Id = x.Id,
ShipmentCode = x.ShipmentCode,
TotalWeight = x.TotalWeight ?? 0,
WarehouseId = x.WarehouseId ?? 0,
CreateTime = x.CreateTime ?? 0
}).ToList();
}
if (lsResult != null && lsResult.Any())
{
var dicPackage = Shipment_GetLstPackage_Dic(lsResult.Select(x => x.Id).Distinct().ToList());
var dicWarehouser = Shipment_GetLstWareHouse_Dic(lsResult.Select(x => x.WarehouseId).Distinct().ToList());
var lstPackage = new List <tblPackageInfo>();
var warehouse = new tblWarehouse();
foreach (var item in lsResult)
{
dicPackage.TryGetValue(item.Id, out lstPackage);
dicWarehouser.TryGetValue(item.WarehouseId, out warehouse);
item.WarehouseName = warehouse?.Warehouse;
if (lstPackage != null)
{
var lstOrder = Package_GetLstOrderByOrderIds(lstPackage.Select(x => x.OrderId).Distinct().ToList());
var lstShippingRecipientInfo = Order_GetLstShippingInfo((int)OrderUserInfo.Recipient, lstOrder.Select(x => x.id).ToList());
if (lstPackage != null && lstPackage.Any())
{
item.LstPackage = new List <PackageViewDTO>();
var dicItem = Package_GetLstItem_Dic(lstPackage.Select(x => x.id).Distinct().ToList());
var lstStoreAcount = _orderService.Order_GetLstStoreAcountInfo(lstPackage.Select(x => x.StoreId).Distinct().ToList());
foreach (var p in lstPackage)
{
var recipientInfo = lstShippingRecipientInfo.FirstOrDefault(x => x.OrderId == p.OrderId);
var op = p.Map <PackageViewDTO>();
op.Id = p.id;
op.StatusId = p.Status;
op.Destination = p.Destination ?? 0;
op.DestinationName = Common.ServiceHelper.GetDestionationCodeById(p.Destination ?? 0);
op.StatusName = ((Models.Extension.Constant.OrderStatusInfo)p.Status).ToString();
op.StoreName = lstStoreAcount.FirstOrDefault(x => x.id == p.StoreId)?.FullName;
op.CreateTime = p.CreateTime;
op.ShipmentId = p.ShipmentId ?? 0;
op.WarehouseId = p.WarehouseId ?? 0;
dicWarehouser.TryGetValue(op.WarehouseId, out warehouse);
op.WarehouseName = warehouse?.Warehouse;
op.RecipientCityName = recipientInfo?.CityName;
var lstItem = new List <tblItemInPackage>();
dicItem.TryGetValue(p.id, out lstItem);
op.Items = new List <ItemPackageViewDTO>();
if (lstItem != null && lstItem.Any())
{
foreach (var i in lstItem)
{
var idto = i.Map <ItemPackageViewDTO>();
idto.CategoryCode = i.Code;
op.Items.Add(idto);
}
}
item.LstPackage.Add(op);
}
item.TotalPackage = item.LstPackage.Count();
item.DestinationName = Common.ServiceHelper.GetDestionationCodeById(item.Destination);
}
}
}
}
}
catch (Exception ex)
{
SELog.WriteLog("ShipmentService => Admin_SearchShipment", ex);
}
return(lsResult);
}
private static FacilityType GetFacilityType(tblWarehouse warehouse)
{
FacilityType type;
return(FacilityTypes.TryGetValue(warehouse.WhouseAbbr, out type) ? type : FacilityType.Internal);
}
