public VehicleModel GetByMakeAndModelCode(string makeCode, string modelCode)
{
var model = GetFromCache(makeCode, modelCode);
if (model == null)
{
Vehicle vehicle = null;
using (var context = new VehicleEntities())
{
vehicle = context.Vehicles.Include("Model")
.Include("Model.Make")
.FirstOrDefault(x => x.Model.ModelCode == modelCode && x.Model.MakeCode == makeCode);
}
if (vehicle == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
model = new VehicleModel()
{
ImageUrl = vehicle.ImageUrl,
Make = vehicle.Model.Make.MakeName,
Model = vehicle.Model.ModelName,
ProducedFromUtc = vehicle.ProducedFromUtc,
ProducedToUtc = vehicle.ProducedToUtc
};
PutToCache(model, makeCode, modelCode);
}
return(model);
}
public void AddPhone(int custID, string phoneType, string phoneNumber)
{
using (var context = new VehicleEntities())
{
PhoneNumber queryAdd = new PhoneNumber
{
customerID = custID,
phoneType = phoneType,
number = phoneNumber
};
try
{
context.PhoneNumbers.AddObject(queryAdd);
context.SaveChanges();
// if context.SaveChanges() succeeded add text to the label Add -> lbl.Add.Text
// lblAdd.Text += string.Format("<br/>Added: number {0} of type: {1}", queryAdd.number.ToString(), queryAdd.phoneType);
//if context.savechanges() succeded then delete phone only if old values are DIFFERENT then new values
// Delete phone !only! if NEW values AREN'T same as OLD values!!
phoneTypeOld = ViewState["phoneTypeOld"].ToString();
phoneNumberOld = ViewState["phoneNumberOld"].ToString();
if (phoneType != phoneTypeOld || phoneNumber != phoneNumberOld)
{
DeletePhone(custID, phoneTypeOld, phoneNumberOld);
}
}
catch (OptimisticConcurrencyException ocex)
{
// Resolve the concurrency conflict by refreshing the
// object context before re-saving changes
context.Refresh(RefreshMode.StoreWins, queryAdd);
lblAdd.Text = ocex.ToString();
//throw;
}
catch (InvalidOperationException ioex)
{
context.Refresh(RefreshMode.StoreWins, queryAdd);
lblAdd.Text = ioex.ToString();
}
catch (SqlException sqlexc)
{
context.Refresh(RefreshMode.StoreWins, queryAdd);
lblAdd.Text = sqlexc.ToString();
}
catch (Exception)
{
if (phoneType == phoneTypeOld && phoneNumber == phoneNumberOld)
{
lblAdd.Text = "";
}
else
{
lblAdd.Text = "Error while trying to update record. The object could not be added." +
"Make sure that the same phone does not aleady exist.";
}
}
}
}
/// <summary>
/// DriverInfoEditSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <param name="RID"></param>
/// <returns></returns>
public static string DriverInfoEditSave(DriveInfoModel Model, string LoginUserID, string RID)
{
using (var db = new VehicleEntities())
{
var List = db.T_UserMaster.Where(t => t.RID == RID).FirstOrDefault();
List.username = Model.Driver_Name;
List.tel = Model.Driver_Tel;
List.userid = Model.Driver_Number;
List.text3 = Model.CarInfo;
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// LocationInfodelete
/// </summary>
/// <param name="deleteItem"></param>
/// <returns></returns>
public static string LocationInfodelete(string deleteItem)
{
string[] ridArr = deleteItem.Split(',');
using (var db = new VehicleEntities())
{
foreach (var ds in ridArr)
{
string Rid = ds;
var model = db.T_Location.FirstOrDefault(p => p.RID == Rid);
db.DeleteObject(model);
}
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "刪除成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "刪除失败"
}));
}
}
}
/// <summary>
/// 新增存儲
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <returns></returns>
public static string UserAddSave(UserModel Model)
{
using (var db = new VehicleEntities())
{
T_UserMaster List = new T_UserMaster();
List.name = Model.name;
List.userid = Model.userid;
List.username = Model.username;
List.type = Model.type;
List.tel = Model.tel;
List.text1 = "CN";
List.RID = Guid.NewGuid().ToString();
db.AddToT_UserMaster(List);
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// 作廢
/// </summary>
/// <param name="deleteItem"></param>
/// <returns></returns>
public static string Planremove(string removeItem)
{
string[] ridArr = removeItem.Split(',');
using (var db = new VehicleEntities())
{
foreach (var ds in ridArr)
{
string planID = ds;
var Planitem = db.M_Plan.FirstOrDefault(p => p.planID == planID && p.valid == "1");
Planitem.valid = "0";
}
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "作廢成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "作廢失败"
}));
}
}
}
/// <summary>
/// CarInfoAddSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <returns></returns>
public static string CarInfoAddSave(CarInfoModel Model, string LoginUserID)
{
using (var db = new VehicleEntities())
{
T_Car List = new T_Car();
List.CreateUser = LoginUserID;
List.CreateDate = Convert.ToDateTime(Model.Create_Time);
List.LastUpdDate = Convert.ToDateTime(Model.Create_Time);
List.LastUpdUser = LoginUserID;
List.seatNum = Convert.ToInt32(Model.seatNum);
List.carID = Model.carID;
List.carName = Model.carName;
List.RID = Guid.NewGuid().ToString();
db.AddToT_Car(List);
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// 更新存儲
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <param name="RID"></param>
/// <returns></returns>
public static string UserEditSave(UserModel Model, string RID)
{
using (var db = new VehicleEntities())
{
var List = db.T_UserMaster.Where(t => t.RID == RID).FirstOrDefault();
List.name = Model.name;
List.username = Model.username;
List.type = Model.type;
List.userid = Model.userid;
List.tel = Model.tel;
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "更新成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "更新失败"
}));
}
}
}
/// <summary>
/// CarInfoEditSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <param name="RID"></param>
/// <returns></returns>
public static string CarInfoEditSave(CarInfoModel Model, string LoginUserID, string RID)
{
using (var db = new VehicleEntities())
{
var List = db.T_Car.Where(t => t.RID == RID).FirstOrDefault();
List.LastUpdDate = DateTime.Now;
List.LastUpdUser = LoginUserID;
List.seatNum = Convert.ToInt32(Model.seatNum);
List.carID = Model.carID;
List.type = Model.type;
List.carName = Model.carName;
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
public static void Run()
{
try
{
Log.Debug("QuotePricePreloader.Run starting");
var ids = new List <int>();
using (var entities = new VehicleEntities())
{
ids.AddRange(entities.Vehicles.Select(x => x.VehicleId));
}
var postalCodes = new List <string>();
using (var pricing = new PricingEntities())
{
postalCodes.AddRange(pricing.PricingFactors.Where(x => x.PricingFactorType.PricingFactorTypeCode == "POC").Select(x => x.AppliesTo));
}
var quoteTasks = new List <Task>();
var stopwatch = Stopwatch.StartNew();
foreach (var id in ids)
{
foreach (var postalCode in postalCodes)
{
var tId = id;
var tPostalCode = postalCode;
quoteTasks.Add(Task.Factory.StartNew(() => PreloadQuotePrice(tId, tPostalCode)));
}
}
Log.Debug("QuotePricePreloader.Run fetching prices for: {0} quotes", quoteTasks.Count);
Task.WaitAll(quoteTasks.ToArray());
Log.Debug("QuotePricePreloader.Run fetched prices for: {0} quotes, in: {1}ms", quoteTasks.Count, stopwatch.ElapsedMilliseconds);
}
catch (Exception ex)
{
Log.Error(ex, "QuotePricePreloader.Run failed");
}
}
/// <summary>
/// LocationInfoEditSave
/// </summary>
/// <param name="Model"></param>
/// <param name="LoginUserID"></param>
/// <param name="RID"></param>
/// <returns></returns>
public static string LocationInfoEditSave(LocationInfoModel Model, string LoginUserID, string RID)
{
using (var db = new VehicleEntities())
{
var List = db.T_Location.Where(t => t.RID == RID).FirstOrDefault();
List.LastUpdDate = DateTime.Now;
List.LastUpdUser = LoginUserID;
List.name = Model.name;
List.longitude = Model.longitude;
List.latitude = Model.latitude;
if (Model.Radius != "")
{
List.Radius = Convert.ToInt32(Model.Radius);
}
int success = db.SaveChanges();
if (success > 0)
{
ViewModel.Result result = new Result();
result.success = true;
result.message = "保存成功";
return(JsonConvert.SerializeObject(result));
}
else
{
return(JsonConvert.SerializeObject(new ViewModel.Result()
{
success = true, message = "保存失败"
}));
}
}
}
/// <summary>
/// 獲取乘客表
/// </summary>
/// <returns></returns>
public static string GetPassengerGrid(string planID)
{
using (var db = new VehicleEntities())
{
var rst = db.D_PassengerList.Where(t => t.planID == planID);
return(JsonConvert.SerializeObject(rst.OrderBy(t => t.locationID).ThenBy(t => t.destinationID)));
}
}
/// <summary>
/// 獲取站點表
/// </summary>
/// <returns></returns>
public static string GetstepGrid(string planID)
{
using (var db = new VehicleEntities())
{
var rst = db.D_RoadList.Where(t => t.planID == planID);
return(JsonConvert.SerializeObject(rst.OrderBy(t => t.sequence)));
}
}
/// <summary>
/// 主檔搜索
/// </summary>
/// <param name="row"></param>
/// <param name="page"></param>
/// <param name="Model"></param>
/// <returns></returns>
public static string PlanSearch(int row, int page, PlanSearchModel Model)
{
DateTime?Begin_Date;
DateTime?End_Date;
int? status;
if (Model.BeginDate != "")
{
Begin_Date = Convert.ToDateTime(Model.BeginDate);
}
else
{
Begin_Date = null;
}
if (Model.EndData != "")
{
End_Date = Convert.ToDateTime(Model.EndData);
}
else
{
End_Date = null;
}
if (Model.status != "")
{
status = Convert.ToInt32(Model.status);
}
else
{
status = null;
}
using (var db = new VehicleEntities())
{
var Searchlist = from hdr in db.vw_Plan.Where(p =>
(p.LastUpdDate >= Begin_Date || Begin_Date == null) &&
(p.LastUpdDate <= End_Date || End_Date == null) &&
(p.carID == Model.carID || string.IsNullOrEmpty(Model.carID)) &&
(p.driverID == Model.driverID || string.IsNullOrEmpty(Model.driverID)) &&
(p.status == status || string.IsNullOrEmpty(Model.status))
).OrderByDescending(p => p.LastUpdDate).Skip((page - 1) * row).Take(row)
select hdr;
var AllList = from hdr in db.vw_Plan.Where(p =>
(p.LastUpdDate >= Begin_Date || Begin_Date == null) &&
(p.LastUpdDate <= End_Date || End_Date == null) &&
(p.carID.Contains(Model.carID) || string.IsNullOrEmpty(Model.carID)) &&
(p.driverID.Contains(Model.driverID) || string.IsNullOrEmpty(Model.driverID)) &&
(p.status == status || string.IsNullOrEmpty(Model.status))
).OrderByDescending(p => p.LastUpdDate)
select hdr;
var total = AllList.Count();
string JsonGrid = JsonConvert.SerializeObject(new { total = total, rows = Searchlist });
return(JsonGrid);
}
}
/// <summary>
/// 獲取主檔
/// </summary>
/// <param name="row"></param>
/// <param name="page"></param>
/// <returns></returns>
public static string GetPlanDataGrid(int row, int page)
{
using (var db = new VehicleEntities())
{
var list = db.vw_Plan.Where(t => true).OrderByDescending(t => t.time).ThenByDescending(t => t.planID).Skip((page - 1) * row).Take(row);
var total = db.vw_Plan.Count();
string JsonGrid = JsonConvert.SerializeObject(new { total = total, rows = list });
return(JsonGrid);
}
}
/// <summary>
/// 返回乘客列表
/// </summary>
/// <param name="PlanID"></param>
/// <returns></returns>
public static string GetMainDtlGridData(string PlanID)
{
using (var db = new VehicleEntities())
{
var MainModel = db.M_Plan.Where(t => t.planID == PlanID && t.valid == "1");
var MainRID = MainModel.FirstOrDefault().RID;
var DtlModel = db.vw_PassengerList.Where(t => t.PlanRID == MainRID);
return(JsonConvert.SerializeObject(DtlModel.OrderBy(t => t.locationID).ThenBy(t => t.destinationID)));
}
}
/// <summary>
/// GetLocationInfoDataGrid
/// </summary>
/// <param name="row"></param>
/// <param name="page"></param>
/// <returns></returns>
public static string GetLocationInfoDataGrid(int row, int page)
{
using (var db = new VehicleEntities())
{
var list = db.T_Location.Where(t => true).OrderByDescending(t => t.LastUpdDate).Skip((page - 1) * row).Take(row);
var total = db.T_Location.Count();
string JsonGrid = JsonConvert.SerializeObject(new { total = total, rows = list });
return(JsonGrid);
}
}
public void DeletePhone(int custID, string phoneType, string phoneNumber)
{
using (var context = new VehicleEntities())
{
PhoneNumber queryDelete = new PhoneNumber();
queryDelete = context.PhoneNumbers.First(p => p.customerID == custID && p.phoneType == phoneType && p.number == phoneNumber);
context.DeleteObject(queryDelete);
context.SaveChanges();
}
}
/// <summary>
/// GetDriveInfoDataGrid
/// </summary>
/// <param name="row"></param>
/// <param name="page"></param>
/// <returns></returns>
public static string GetDriveInfoDataGrid(int row, int page)
{
using (var db = new VehicleEntities())
{
var list = db.T_UserMaster.Where(t => t.type == "driver").OrderByDescending(t => t.username).Skip((page - 1) * row).Take(row);
var total = db.T_UserMaster.Where(t => t.type == "driver").Count();
string JsonGrid = JsonConvert.SerializeObject(new { total = total, rows = list });
return(JsonGrid);
}
}
/// <summary>
/// 獲取公司信息
/// </summary>
/// <returns></returns>
public static string GetCompany()
{
using (var db = new VehicleEntities())
{
var rst =
from hdr in db.T_SystemTable.Where(t => t.Field == "company" && t.Dataid != " ")
select new { text = hdr.Text, value = hdr.Dataid };
return(JsonConvert.SerializeObject(rst));
}
}
/// <summary>
/// 獲取車輛信息
/// </summary>
/// <returns></returns>
public static string GetCarInfo()
{
using (var db = new VehicleEntities())
{
var rst =
from hdr in db.T_Car
select new { order = hdr.LastUpdDate, carname = hdr.carName, capacity = hdr.seatNum, license = hdr.carID };
return(JsonConvert.SerializeObject(rst.OrderByDescending(t => t.order)));
}
}
public Vehicle GetVehicle(int id)
{
Vehicle vehicle = null;
using (var context = new VehicleEntities())
{
vehicle = context.Vehicles.Include("Model")
.Include("Model.Make")
.FirstOrDefault(x => x.VehicleId == id);
}
return(vehicle);
}
/// <summary>
/// CarInfoSearch
/// </summary>
/// <param name="row"></param>
/// <param name="page"></param>
/// <param name="Model"></param>
/// <returns></returns>
public static string CarInfoSearch(int row, int page, CarInfoModel Model)
{
DateTime?Begin_Date;
DateTime?End_Date;
int seatNum = 0;
if (Model.Create_Time != "")
{
Begin_Date = Convert.ToDateTime(Model.Create_Time);
}
else
{
Begin_Date = null;
}
if (Model.Create_Time_E != "")
{
End_Date = Convert.ToDateTime(Model.Create_Time_E);
}
else
{
End_Date = null;
}
if (Model.seatNum != "")
{
seatNum = Convert.ToInt32(Model.seatNum);
}
using (var db = new VehicleEntities())
{
var Searchlist = from hdr in db.T_Car.Where(p =>
(p.LastUpdDate >= Begin_Date || Begin_Date == null) &&
(p.LastUpdDate <= End_Date || End_Date == null) &&
(p.carID.Contains(Model.carID) || string.IsNullOrEmpty(Model.carID)) &&
(p.carName.Contains(Model.carName) || string.IsNullOrEmpty(Model.carName)) &&
(p.seatNum == seatNum || string.IsNullOrEmpty(Model.seatNum)) &&
(p.seatNum != 0)
).OrderByDescending(p => p.LastUpdDate).Skip((page - 1) * row).Take(row)
select hdr;
var AllList = from hdr in db.T_Car.Where(p =>
(p.LastUpdDate >= Begin_Date || Begin_Date == null) &&
(p.LastUpdDate <= End_Date || End_Date == null) &&
(p.carID.Contains(Model.carID) || string.IsNullOrEmpty(Model.carID)) &&
(p.carName.Contains(Model.carName) || string.IsNullOrEmpty(Model.carName)) &&
(p.seatNum == seatNum || string.IsNullOrEmpty(Model.seatNum)) &&
(p.seatNum != 0)
).OrderByDescending(p => p.LastUpdDate)
select hdr;
var total = AllList.Count();
string JsonGrid = JsonConvert.SerializeObject(new { total = total, rows = Searchlist });
return(JsonGrid);
}
}
/// <summary>
/// 獲取站點
/// </summary>
/// <returns></returns>
public static string Getstep()
{
using (var db = new VehicleEntities())
{
var rst = from hdr in db.T_Location
select new
{
value = hdr.locationID,
text = hdr.name
};
return(JsonConvert.SerializeObject(rst));
}
}
public List <Vehicle> GetVehicles(string makeName, string modelName)
{
var vehicles = new List <Vehicle>();
using (var context = new VehicleEntities())
{
vehicles.AddRange(context.Vehicles.Include("Model")
.Include("Model.Make")
.Where(x => x.Model.ModelNameLower == modelName.Trim().ToLower() &&
x.Model.Make.MakeNameLower == makeName.Trim().ToLower()).ToList());
}
return(vehicles);
}
public virtual IEnumerable <Make> GetMakes()
{
Log.Debug("VehicleRepository.GetMakes called");
var makes = new List <Make>();
using (var context = new VehicleEntities())
{
context.Configuration.LazyLoadingEnabled = false;
makes.AddRange(context.Makes);
}
Log.Debug("VehicleRepository.GetMakes completed");
return(makes);
}
/// <summary>
/// 獲取用戶類型
/// </summary>
/// <returns></returns>
public static string GetUserType()
{
using (var db = new VehicleEntities())
{
var rst = from hdr in db.T_UserMaster
select new
{
value = hdr.type,
text = hdr.type
};
return(JsonConvert.SerializeObject(rst.Distinct()));
}
}
/// <summary>
/// 獲取乘客
/// </summary>
/// <returns></returns>
public static string Getpassenger()
{
using (var db = new VehicleEntities())
{
var rst = from hdr in db.T_UserMaster.Where(t => t.type == "passenger" || t.type == "Admin")
select new
{
value = hdr.userid,
text = hdr.name,
};
return(JsonConvert.SerializeObject(rst));
}
}
/// <summary>
/// 獲取乘客狀態
/// </summary>
/// <returns></returns>
public static string Getpassengerstatus()
{
using (var db = new VehicleEntities())
{
var rst = from hdr in db.T_SystemTable.Where(t => t.Field == "PassengerState")
select new
{
value = hdr.Dataid,
text = hdr.Text
};
return(JsonConvert.SerializeObject(rst.OrderBy(t => t.value)));
}
}
/// <summary>
/// 獲取司機
/// </summary>
/// <returns></returns>
public static string GetdriverID()
{
using (var db = new VehicleEntities())
{
var rst = from hdr in db.T_UserMaster.Where(t => t.type == "driver")
select new
{
value = hdr.userid,
text = hdr.username
};
return(JsonConvert.SerializeObject(rst));
}
}
