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);
}
private Dictionary <int, tblWarehouse> Shipment_GetLstWareHouse_Dic(List <int> lstWarehouseId)
{
Dictionary <int, tblWarehouse> lsResult = new Dictionary <int, tblWarehouse>();
var key = "Shipment-" + string.Join("-", lstWarehouseId);
object HTML = MemoryCache.Default.Get(key);
if (HTML != null)
{
return((Dictionary <int, tblWarehouse>)HTML);
}
else
{
try
{
using (var db = ContextFactory.UsTransportEntities())
{
lsResult = db.tblWarehouses
.Where(x => lstWarehouseId.Contains(x.id))
.ToDictionary(x => x.id);
}
if (lsResult != null && lsResult.Any())
{
}
MemoryCache.Default.Add(key, lsResult, DateTimeOffset.UtcNow.AddMinutes(60));
}
catch (Exception ex)
{
SELog.WriteLog("ShipmentService => Shipment_GetLstWareHouse_Dic", ex);
}
}
return(lsResult);
}
public List <tblDistrictStateProvice> GetLstDictrictByCityId(string cityId)
{
List <tblDistrictStateProvice> result = new List <tblDistrictStateProvice>();
var key = "GetLstDictrictByCityId-" + cityId;
object HTML = MemoryCache.Default.Get(key);
if (HTML != null)
{
return((List <tblDistrictStateProvice>)HTML);
}
else
{
try
{
using (var db = ContextFactory.UsTransportEntities())
{
result = db.tblDistrictStateProvices.Where(x => x.StateProvinceID.Equals(cityId, StringComparison.OrdinalIgnoreCase)).Select(x => x).ToList();
}
if (result != null)
{
MemoryCache.Default.Add(key, result, DateTimeOffset.UtcNow.AddMinutes(30));
}
}
catch (Exception ex)
{
SELog.WriteLog("LocationServices => GetLstDictrictByCityId", ex);
}
}
return(result);
}
public IPagedList <tblWarehouse> GetListWarehouse(int pageIndex, int pageSize, string keyword, int searchType)
{
List <tblWarehouse> ListRS = new List <tblWarehouse>();
try
{
keyword = string.IsNullOrEmpty(keyword) ? null : keyword;
using (var db = ContextFactory.UsTransportEntities())
{
ListRS = db.tblWarehouses.Where(x =>
(keyword == null ||
(keyword != null &&
(
(searchType == 1 && keyword.Contains(x.id.ToString())) ||
(searchType == 2 && x.FullName.Contains(keyword)) ||
(searchType == 3 && x.Warehouse.Contains(keyword))
))
)).ToList();
}
}
catch (Exception ex)
{
SELog.WriteLog("WareHouseServices => GetListWarehouse", ex);
}
return(ListRS.ToPagedList(pageIndex, pageSize));
}
public long InsertStore(tblStoreAccount storeaccount)
{
long result = 0;
try
{
storeaccount.CreatedDate = DateTime.Now;
storeaccount.IsActive = true;
using (var db = ContextFactory.UsTransportEntities())
{
if (db.tblStoreAccounts.FirstOrDefault(s => s.Email.ToLower() == storeaccount.Email.ToLower()) != null)
{
return(-1);
}
db.tblStoreAccounts.Add(storeaccount);
db.SaveChanges();
result = storeaccount.id;
}
}
catch (Exception ex)
{
SELog.WriteLog("StoreServices => InsertStore", ex);
}
return(result);
}
public bool Admin_CheckPhoneUserInfoOfStore(int storeId, int typeUser, string phone)
{
bool result = false;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
switch ((Models.Extension.Constant.OrderUserInfo)typeUser)
{
case Models.Extension.Constant.OrderUserInfo.Sender:
var sender = db.tblSenders.FirstOrDefault(x => x.Phone == phone && x.StoreId == storeId);
if (sender != null && sender.Id > 0)
{
result = true;
}
break;
case Models.Extension.Constant.OrderUserInfo.Recipient:
var receipient = db.tblRecipientsInfoes.FirstOrDefault(x => x.Phone == phone && x.StoreId == storeId);
if (receipient != null && receipient.id > 0)
{
result = true;
}
break;
}
}
}
catch (Exception ex)
{
SELog.WriteLog("StoreServices => Admin_CheckPhoneUserInfoOfStore", ex);
}
return(result);
}
public long UpdateReciever(tblRecipientsInfo reciver)
{
long result = 0;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
var _temp = db.tblRecipientsInfoes.FirstOrDefault(x => x.id == reciver.id);
if (_temp != null)
{
db.Entry(_temp).CurrentValues.SetValues(reciver);
if (db.SaveChanges() > 0)
{
result = _temp.id;
}
}
}
}
catch (Exception ex)
{
SELog.WriteLog("StoreServices => UpdateReciever", ex);
}
return(result);
}
public int Admin_UpdateShipmentForPackage(List <long> lstPackagageId, int?shipmentId, string shipmentCode)
{
int result = 0;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
foreach (var id in lstPackagageId)
{
var item = db.tblPackageInfoes.FirstOrDefault(x => x.id == id);
if (item != null)
{
item.ShipmentCode = shipmentCode;
item.ShipmentId = shipmentId;
//db.Entry(item).CurrentValues.SetValues(item);
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
SELog.WriteLog("ShipmentService => Admin_UpdateShipmentForPackage", ex);
}
return(result);
}
public long CreateUser(string username, string password, string fullname, bool isactive = false)
{
long result = 0;
try
{
tblUser user = new tblUser {
Username = username, Password = Utils.HashMD5(password), IsActive = isactive, IsDeleted = false, CreatedOn = DateTime.Now, FullName = fullname
};
user.CreatedOn = DateTime.Now;
using (var db = ContextFactory.UsTransportEntities())
{
if (db.tblUsers.FirstOrDefault(s => s.Username.ToLower() == user.Username.ToLower()) != null)
{
return(-1);
}
db.tblUsers.Add(user);
db.SaveChanges();
result = user.Id;
}
}
catch (Exception ex)
{
SELog.WriteLog("UserService => CreateUser", ex);
}
return(result);
}
public int UpdateMenu(tblMenu menu)
{
int result = 0;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
var m = db.tblMenus.FirstOrDefault(u => u.Id == menu.Id);
if (m != null)
{
db.Entry(m).CurrentValues.SetValues(menu);
if (db.SaveChanges() > 0)
{
result = m.Id;
}
}
}
}
catch (Exception ex)
{
SELog.WriteLog("MenuService => UpdateMenu", ex);
}
return(result);
}
public tblCategory SelectByCatelogyID(int id)
{
tblCategory _item = new tblCategory();
try
{
var key = "SelectByCatelogyID-" + id;
object HTML = MemoryCache.Default.Get(key);
if (HTML != null)
{
return((tblCategory)HTML);
}
else
{
using (var db = ContextFactory.UsTransportEntities())
{
_item = db.tblCategories.Where(x => x.id == id).FirstOrDefault();
}
if (_item != null)
{
MemoryCache.Default.Add(key, _item, DateTimeOffset.UtcNow.AddMinutes(60));
}
}
}
catch (Exception ex)
{
SELog.WriteLog("CategoryService => SelectByCatelogyID", ex);
}
return(_item);
}
public long UpdateRoleUser(long UserID, int RoleID)
{
long result = 0;
try
{
tblUserRole userRole = new tblUserRole {
UserId = UserID, RoleId = RoleID
};
using (var db = ContextFactory.UsTransportEntities())
{
var updaterole = db.tblUserRoles.FirstOrDefault(u => u.UserId == UserID);
if (updaterole != null)
{
updaterole.RoleId = RoleID;
if (db.SaveChanges() > 0)
{
result = updaterole.Id;
}
}
else
{
db.tblUserRoles.Add(userRole);
db.SaveChanges();
result = userRole.Id;
}
}
}
catch (Exception ex)
{
SELog.WriteLog("RoleService => UpdateRoleUser", ex);
}
return(result);
}
public long InsertProduct(tblProduct product)
{
long result = 0;
string key = "usexpress_productlist";
tblProduct _item = new tblProduct();
try
{
using (var db = ContextFactory.UsTransportEntities())
{
if (db.tblProducts.Any(x => x.BarCode == product.BarCode))
{
return(-1);
}
db.tblProducts.Add(product);
db.SaveChanges();
MemoryCache.Default.Remove(key);
result = product.id;
}
}
catch (Exception ex)
{
SELog.WriteLog("ProductServices => InsertProduct", ex);
}
return(result);
}
public tblProduct SelectByProductID(int id)
{
tblProduct _item = new tblProduct();
try
{
var key = "usexpress_select" + id;
object HTML = MemoryCache.Default.Get(key);
if (HTML != null)
{
return((tblProduct)HTML);
}
else
{
using (var db = ContextFactory.UsTransportEntities())
{
_item = db.tblProducts.FirstOrDefault(x => x.id == id);
}
if (_item != null)
{
MemoryCache.Default.Add(key, _item, DateTimeOffset.UtcNow.AddMinutes(60));
}
}
}
catch (Exception ex)
{
SELog.WriteLog("ProductServices => SelectByProductID", ex);
}
return(_item);
}
public List <ShipmentViewDTO> Admin_SearchShipmentByCondition(string keyword, DateTime FromDate, DateTime ToDate)
{
List <ShipmentViewDTO> lsResult = null;
try
{
double douFromdate = FromDate.ToUnixTimestamp();
double douTodate = ToDate.Date.AddDays(1).ToUnixTimestamp();
using (var db = ContextFactory.UsTransportEntities())
{
lsResult = db.tblShipments
.Where(x => !x.IsDeleted &&
(keyword == null || x.ShipmentCode.Contains(keyword)) &&
x.CreateTime >= douFromdate &&
x.CreateTime <= douTodate
)
.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();
}
}
catch (Exception ex)
{
SELog.WriteLog("ShipmentService => Admin_SearchShipmentByCondition", ex);
}
return(lsResult);
}
private async Task PostRequestAsync(string apiUrl, string JsonParams)
{
try
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(apiUrl);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var responseMessage = await client.PostAsync(apiUrl, new StringContent(JsonParams, Encoding.UTF8, "application/json"));
var responseJson = await responseMessage.Content.ReadAsStringAsync();
if (responseMessage.StatusCode != HttpStatusCode.OK)
{
throw new Exception(responseJson);
}
//return await Task.FromResult(JsonConvert.DeserializeObject<KerryExpress.PostNewOrderResponse>(responseJson));
}
}
catch (Exception ex)
{
SELog.WriteLog("KerryService => PostRequestAsync", ex);
throw ex;
}
}
public IPagedList <EmployeesDTO> SearchUser(int pageIndex, int pageSize, string keyword, int searchType = -1)
{
List <EmployeesDTO> ListRS = new List <EmployeesDTO>();
try
{
using (var db = ContextFactory.UsTransportEntities())
{
ListRS = db.tblUsers.GroupJoin(db.tblWarehouses,
user => user.WarehouseID,
warehouse => warehouse.id,
(user, warehouse) => new { U = user, W = warehouse.FirstOrDefault() })
.Where(x => (searchType == -1 ||
(searchType == 1 && x.U.Phone.Contains(keyword)) ||
(searchType == 2 && x.U.FullName.Contains(keyword)) ||
(searchType == 3 && x.W.Warehouse.Contains(keyword))
)).Select(x => new EmployeesDTO
{
Id = x.U.Id,
FullName = x.U.FullName,
Phone = x.U.Phone,
Add1 = x.U.Add1,
Email = x.U.Email,
WarehouseName = x.W.Warehouse,
IsActive = x.U.IsActive
}).ToList();
}
}
catch (Exception ex)
{
SELog.WriteLog("UserService => SearchUser", ex);
}
return(ListRS.ToPagedList(pageIndex, pageSize));
}
public long UpdateProduct(tblProduct product)
{
long result = 0;
var key = "usexpress_select" + product.id;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
var _temp = db.tblProducts.FirstOrDefault(x => x.id == product.id);
if (_temp != null)
{
db.Entry(_temp).CurrentValues.SetValues(product);
if (db.SaveChanges() > 0)
{
result = _temp.id;
MemoryCache.Default.Remove(key);
}
}
result = product.id;
}
}
catch (Exception ex)
{
SELog.WriteLog("ProductServices => UpdateProduct", ex);
}
return(result);
}
public List <tblMenu> GetLstMenuByLstRoleId(List <int> lstRoleId)
{
List <tblMenu> result = null;
var key = "Menu-" + string.Join("-", lstRoleId);
object HTML = MemoryCache.Default.Get(key);
if (HTML != null)
{
return((List <tblMenu>)HTML);
}
else
{
try
{
using (var db = ContextFactory.UsTransportEntities())
{
var lstmenuId = db.tblMenuPermissions.Where(x => lstRoleId.Contains(x.RoleId)).Select(x => x.MenuId).Distinct().ToList();
if (lstmenuId != null && lstmenuId.Any())
{
result = db.tblMenus.Where(x => lstmenuId.Contains(x.Id) && x.IsActive == true && !x.IsDeleted).Select(x => x).ToList();
}
}
MemoryCache.Default.Add(key, result, DateTimeOffset.UtcNow.AddMinutes(60));
}
catch (Exception ex)
{
SELog.WriteLog("MenuService => GetLstMenuByLstRoleId", ex);
}
}
return(result);
}
public long RegisUser(tblUser user)
{
long result = 0;
try
{
user.Password = Utils.HashMD5(user.Password);
user.CreatedOn = DateTime.Now;
user.Username = user.Email;
using (var db = ContextFactory.UsTransportEntities())
{
if (db.tblUsers.FirstOrDefault(s => s.Username.ToLower() == user.Username.ToLower()) != null)
{
return(-1);
}
db.tblUsers.Add(user);
db.SaveChanges();
result = user.Id;
}
}
catch (Exception ex)
{
SELog.WriteLog("UserService => RegisUser", ex);
}
return(result);
}
public List <int> GetLstRoleIdByUserId(long userId)
{
List <int> result = null;
var key = "User-" + userId;
object HTML = MemoryCache.Default.Get(key);
if (HTML != null)
{
return((List <int>)HTML);
}
else
{
try
{
using (var db = ContextFactory.UsTransportEntities())
{
result = db.tblUserRoles.Where(x => x.UserId == userId).Select(x => x.RoleId).ToList();
}
MemoryCache.Default.Add(key, result, DateTimeOffset.UtcNow.AddMinutes(60));
}
catch (Exception ex)
{
SELog.WriteLog("UserService => GetLstRoleIdByUserId", ex);
}
}
return(result);
}
public long UpdateStore(tblStoreAccount storeaccount)
{
long result = 0;
try
{
storeaccount.CreatedDate = DateTime.Now;
using (var db = ContextFactory.UsTransportEntities())
{
var _temp = db.tblStoreAccounts.FirstOrDefault(x => x.id == storeaccount.id);
if (storeaccount.Status == null)
{
storeaccount.Status = _temp.Status;
storeaccount.Password = _temp.Password;
}
if (_temp != null)
{
db.Entry(_temp).CurrentValues.SetValues(storeaccount);
if (db.SaveChanges() > 0)
{
result = _temp.id;
}
}
result = storeaccount.id;
}
}
catch (Exception ex)
{
SELog.WriteLog("StoreServices => UpdateStore", ex);
}
return(result);
}
public tblUser GetUserByUsername(string username)
{
tblUser result = null;
if (!String.IsNullOrEmpty(username))
{
var key = "User-" + username;
object HTML = MemoryCache.Default.Get(key);
if (HTML != null)
{
return((tblUser)HTML);
}
else
{
try
{
using (var db = ContextFactory.UsTransportEntities())
{
result = db.tblUsers.FirstOrDefault(u => u.Username.Equals(username));
}
if (result != null)
{
MemoryCache.Default.Add(key, result, DateTimeOffset.UtcNow.AddMinutes(60));
}
}
catch (Exception ex)
{
SELog.WriteLog("UserService => GetUserByUsername", ex);
}
}
}
return(result);
}
public IPagedList <ProductDTO> GetAllProduct(int pageIndex, int pageSize, string keyword, int searchType)
{
List <ProductDTO> result = new List <ProductDTO>();
try
{
using (var db = ContextFactory.UsTransportEntities())
{
var query = db.tblProducts.Join(db.tblCategories,
pro => pro.CategoryID,
cat => cat.id,
(pro, cat) => new { Pro = pro, Cat = cat }
).Where(x => (
(searchType == -1) ||
(searchType == 1 && (keyword != null && x.Pro.BarCode.Contains(keyword))) ||
(searchType == 2 && (keyword != null && x.Pro.Description.Contains(keyword))) ||
(searchType == 2 && (keyword != null && x.Cat.CategoryName.Contains(keyword)))
)).ToList();
result = query.Select(x => new ProductDTO()
{
BarCode = x.Pro.BarCode,
CategoryID = x.Pro.CategoryID,
CategoryName = x.Cat.CategoryName,
Description = x.Pro.Description,
id = x.Pro.id,
ScheduleBCode = x.Pro.ScheduleBCode
}).ToList();
}
}
catch (Exception ex)
{
SELog.WriteLog("ProductServices => GetAllProduct", ex);
}
return(result.ToPagedList(pageIndex, pageSize));
}
public long UpdateCatelogy(tblCategory category)
{
long result = 0;
var key = "SelectByCatelogyID-" + category.id;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
var _temp = db.tblCategories.Where(x => x.id == category.id).FirstOrDefault();
if (_temp != null)
{
db.Entry(_temp).CurrentValues.SetValues(category);
if (db.SaveChanges() > 0)
{
result = _temp.id;
MemoryCache.Default.Remove(key);
}
}
result = category.id;
}
}
catch (Exception ex)
{
SELog.WriteLog("CategoryService => UpdateCatelogy", ex);
}
return(result);
}
public ShipmentViewDTO Admin_GeDetailShipmentHasPackageById(int shipmentId)
{
ShipmentViewDTO result = null;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
var detail = db.tblShipments.FirstOrDefault(x => x.Id == shipmentId);
if (detail != null)
{
result = new ShipmentViewDTO
{
Destination = detail.Destination ?? 0,
Id = detail.Id,
ShipmentCode = detail.ShipmentCode,
TotalWeight = detail.TotalWeight ?? 0,
WarehouseId = detail.WarehouseId ?? 0
};
}
}
if (result != null)
{
var dicPackage = Shipment_GetLstPackage_Dic(new List <int> {
result.Id
});
var lstPackage = new List <tblPackageInfo>();
dicPackage.TryGetValue(result.Id, out lstPackage);
if (lstPackage != null && lstPackage.Any())
{
result.LstPackage = new List <PackageViewDTO>();
var lstStoreAcount = _orderService.Order_GetLstStoreAcountInfo(lstPackage.Select(x => x.StoreId).Distinct().ToList());
foreach (var p in lstPackage)
{
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;
result.LstPackage.Add(op);
}
result.TotalPackage = result.LstPackage.Count();
result.DestinationName = Common.ServiceHelper.GetDestionationCodeById(result.Destination);
}
}
}
catch (Exception ex)
{
SELog.WriteLog("ShipmentService => Admin_GeDetailShipmentHasPackageById", ex);
}
return(result);
}
public List <ShippingInfoDTO> SearchInfoByPhone(int top, string phone, int typeUser, int storeId = -1)
{
List <ShippingInfoDTO> result = new List <ShippingInfoDTO>();
try
{
using (var db = ContextFactory.UsTransportEntities())
{
switch ((OrderUserInfo)typeUser)
{
case OrderUserInfo.Sender:
result = db.tblSenders.Where(x => x.Phone.Contains(phone) && (x.StoreId == storeId || storeId == -1))
.Take(top)
.Select(x => new ShippingInfoDTO
{
Phone = x.Phone,
FullName = x.FullName,
AddressLine1 = x.Add1,
AddressLine2 = x.Add2,
Id = x.Id,
StoreId = x.StoreId ?? 0,
TypeUser = typeUser,
CityId = x.CityId,
CityName = x.CityId,
StateId = x.StateId,
StateName = x.StateId,
Zip = x.Zip
}).ToList();
break;
case OrderUserInfo.Recipient:
result = db.tblRecipientsInfoes.Where(x => x.Phone.Contains(phone) && (x.StoreId == storeId || storeId == -1))
.Take(top)
.Select(x => new ShippingInfoDTO
{
Phone = x.Phone,
FullName = x.FullName,
AddressLine1 = x.Add1,
AddressLine2 = x.Add2,
Id = x.id,
CityId = x.CityId,
DistrictId = x.DistrictId,
StoreId = x.StoreId ?? 0,
TypeUser = typeUser,
WardId = x.WardId
}).ToList();
break;
}
}
}
catch (Exception ex)
{
SELog.WriteLog("UserService => SearchInfoByPhone", ex);
}
return(result);
}
public List <tblPackageInfo> listPackageInday()
{
List <tblPackageInfo> result = null;
try
{
}
catch (Exception ex)
{
SELog.WriteLog("ShipmentService => listPackageInday", ex);
}
return(null);
}
public int Admin_RemoveLstShipmentId(List <int> lstId)
{
int result = 0;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
foreach (var item in lstId)
{
var detail = db.tblShipments.FirstOrDefault(x => x.Id == item);
if (detail != null)
{
detail.IsDeleted = true;
db.Entry(detail).CurrentValues.SetValues(detail);
db.SaveChanges();
var lst = db.tblPackageInfoes.Where(x => x.ShipmentId == item).ToList();
if (lst != null && lst.Any())
{
foreach (var p in lst)
{
p.ShipmentCode = string.Empty;
p.ShipmentId = null;
db.Entry(p).CurrentValues.SetValues(p);
db.SaveChanges();
}
}
}
}
transaction.Commit();
result = 1;
}
catch (Exception ex)
{
SELog.WriteLog("ShipmentService => Admin_RemoveLstShipmentId with rollback", ex);
transaction.Rollback();
}
}
}
}
catch (Exception ex)
{
SELog.WriteLog("ShipmentService => Admin_RemoveLstShipmentId", ex);
}
return(result);
}
public List <tblAppUserRoleMenu> GetAppUserRoleMenu(int UserId)
{
try
{
using (var db = ContextFactory.UsTransportEntities())
{
return(db.tblAppUserRoleMenus.Where(x => x.UserId == UserId).ToList());
}
}
catch (Exception ex)
{
SELog.WriteLog("AppService => GetAppUserRoleMenu", ex);
throw ex;
}
}
