public All_orders()
{
InitializeComponent();
this.db = new CarRentEntities();
fillDgv(db.Orders.ToList());
orders = db.Orders.ToList();
}
public List <CarStatus> GetAllCars()
{
using (CarRentEntities db = new CarRentEntities())
{
return(db.cars_tbl.Select(c => new CarStatus
{
CarTypeId = new CarType
{
CarTypeId = c.carsType_tbl.CarTypeId,
ModelMake = c.carsType_tbl.ModelMake,
Model = c.carsType_tbl.Model,
ModelName = c.carsType_tbl.ModelName,
ModelYear = c.carsType_tbl.ModelYear,
ModelBody = c.carsType_tbl.ModelBody,
ModelWeightKg = c.carsType_tbl.ModelWeightKg,
ModelDoors = c.carsType_tbl.ModelDoors,
Gear = c.carsType_tbl.Gear
},
ActuallyKm = c.ActuallyKm,
Picture = c.Picture,
AvaibleToBeRent = c.AvaibleToBeRent,
ProperToBeRent = c.ProperToBeRent,
DayPrice = c.DayPrice,
DayDelayPrice = c.DayDelayPrice,
PlateNumber = c.PlateNumber,
BranchId = new Branch
{
Adress = c.branchs_tbl.Adress,
BranchName = c.branchs_tbl.BranchName
},
}
).ToList());
}
}
public bool AddCar(CarType c)
{
try
{
using (CarRentEntities db = new CarRentEntities())
{
db.carsType_tbl.Add(
new carsType_tbl
{
ModelMake = c.ModelMake,
Model = c.Model,
ModelName = c.ModelName,
ModelYear = c.ModelYear,
ModelBody = c.ModelBody,
ModelWeightKg = c.ModelWeightKg,
ModelDoors = c.ModelDoors,
Gear = c.Gear
});
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 批量删除消息记录
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> DelsMessages(P_Message.P_DelsMessages arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
ExceptionMessage em = new ExceptionMessage();
using (DAL.CarRentEntities db = new CarRentEntities())
{
int count = db.Database.ExecuteSqlCommand("update ExceptionMessage set Deleted=1 where ExceptionID in(" + arg.id + ")");
ar.message = $"delete {count} data success!";
ar.result = new { url = "reload" };
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.code = StatusCode.error;
ar.message = ex.Message;
}
return ar;
}));
}
public DeliveryDate(int SelectedId, int UserId)
{
InitializeComponent();
this.db = new CarRentEntities();
this.selectedId = SelectedId;
this.userId = UserId;
}
public static List <Branch> getBranches()
{
using (CarRentEntities db = new CarRentEntities())
{
return(db.Branches.ToList());
}
}
public bool AddUser(User user)
{
try
{
using (CarRentEntities db = new CarRentEntities())
{
db.users_tbl.Add(
new users_tbl
{
FullName = user.FullName,
Identity = user.Identity,
UserName = user.UserName,
BirthDay = user.BirthDay,
Gender = user.Gender,
Email = user.Email,
Rank = user.Rank,
Passwords = user.Passwords,
Picture = user.Picture
}
);
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool EditCar(CarStatus changedCar)
{
try
{
using (CarRentEntities db = new CarRentEntities())
{
cars_tbl car = db.cars_tbl.FirstOrDefault(c => c.PlateNumber == changedCar.PlateNumber);
if (car != null)
{
car.ActuallyKm = changedCar.ActuallyKm;
car.AvaibleToBeRent = changedCar.AvaibleToBeRent;
car.ProperToBeRent = changedCar.ProperToBeRent;
car.Picture = changedCar.Picture;
car.DayPrice = changedCar.DayPrice;
car.DayDelayPrice = changedCar.DayDelayPrice;
car.PlateNumber = changedCar.PlateNumber;
db.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 修改设备信息
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> UpdateDeviceInfo(P_Devices.P_UpdateDeviceInfo arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
DAL.Devices d = new DAL.Devices();
d.DeviceID = arg.deviceid;
using (DAL.CarRentEntities db = new CarRentEntities())
{
var device = db.Devices.Find(arg.deviceid);
device.DeviceName = arg.devicename;
device.Description = arg.description;
device.GroupID = arg.groupid;
db.SaveChanges();//保存至数据库中
ar.message = "Device information is modified successfully";
ar.result = new { url = "reload" };
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.code = Interface.StatusCode.error;
ar.message = ex.Message;
}
return ar;
}));
}
public bool EditCar(CarType changedCar)
{
try
{
using (CarRentEntities db = new CarRentEntities())
{
carsType_tbl car = db.carsType_tbl.FirstOrDefault(c => c.CarTypeId == changedCar.CarTypeId);
if (car != null)
{
car.ModelMake = changedCar.ModelMake;
car.Model = changedCar.Model;
car.ModelName = changedCar.ModelName;
car.ModelYear = changedCar.ModelYear;
car.ModelBody = changedCar.ModelBody;
car.ModelWeightKg = changedCar.ModelWeightKg;
car.ModelDoors = changedCar.ModelDoors;
car.Gear = changedCar.Gear;
db.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 删除一条设备记录
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> DelDevice(P_Devices.P_DelDevice arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
using (DAL.CarRentEntities db = new CarRentEntities())
{
var de = db.Devices.First(d => d.DeviceID == arg.id);
de.Deleted = true;
int count = db.SaveChanges();
ar.message = $"delete{count} data success!";
ar.result = new { url = "" };
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.code = Interface.StatusCode.error;
ar.message = ex.Message;
}
return ar;
}));
}
public static List <User> getUsersByRole(char roleType)
{
using (CarRentEntities db = new CarRentEntities())
{
return(db.Users.Where(user => user.RoleType.ToString() == roleType.ToString()).ToList());
}
}
public static bool DeleteUser(string ID)
{
bool isDeleted;
try
{
using (CarRentEntities db = new CarRentEntities())
{
User user = db.Users.FirstOrDefault(u => u.ID == ID);
if (user != null)
{
db.Users.Remove(user);
db.SaveChanges();
isDeleted = true;
}
else
{
isDeleted = false;
}
}
}
catch (Exception e)
{
isDeleted = false;
}
return(isDeleted);
}
public static List <User> getAllUsers()
{
using (CarRentEntities db = new CarRentEntities())
{
return(db.Users.ToList());
}
}
public ActionResult getCarData()
{
CarRentEntities db = new CarRentEntities();
var cars = db.Cars.ToList();
return(Json(cars, JsonRequestBehavior.AllowGet));
}
public bool Edituser(User changedUser)
{
try
{
using (CarRentEntities db = new CarRentEntities())
{
users_tbl user = db.users_tbl.FirstOrDefault(u => u.UserName == changedUser.UserName);
if (user != null)
{
user.FullName = changedUser.FullName;
user.Identity = changedUser.Identity;
user.UserName = changedUser.UserName;
user.BirthDay = changedUser.BirthDay;
user.Gender = changedUser.Gender;
user.Email = changedUser.Email;
user.Passwords = changedUser.Passwords;
user.Rank = changedUser.Rank;
user.Picture = changedUser.Picture;
db.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 根据消息ID删除一条报警消息
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> DelMessage(P_Message.P_DelMessage arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
//DAL.ExceptionMessage dal = new ExceptionMessage()
//{
// ExceptionID = arg.exceptionid,
//};
using (DAL.CarRentEntities db = new CarRentEntities())
{
var em = db.ExceptionMessage.First(e => e.ExceptionID == arg.exceptionid);
em.Deleted = 1;
//db.ExceptionMessage.Delete(e => e.ExceptionID == arg.ExceptionID);
//var context= db.ExceptionMessage.Attach(dal);//将数据交给EF容器处理
// context.Deleted = 1;
// db.ExceptionMessage.Remove(dal);
int count = db.SaveChanges();
ar.message = $"delete{count}a data success!";
ar.result = new { url = "" };
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.code = StatusCode.error;
ar.message = ex.Message;
}
return ar;
}));
}
public static List <CarsForRent> getAllCars()
{
using (CarRentEntities db = new CarRentEntities())
{
List <CarsForRent> allCars = db.CarsForRents.ToList();
return(allCars);
}
}
public static List <RentCar> getAllRentCars()
{
using (CarRentEntities db = new CarRentEntities())
{
List <RentCar> rents = db.RentCars.ToList();
return(rents);
}
}
public static List <RentCar> getRentCarsByUserID(int userID)
{
using (CarRentEntities db = new CarRentEntities())
{
List <RentCar> rents = db.RentCars.Where(order => order.UserID == userID).ToList();
return(rents);
}
}
public Reports(int adminId)
{
InitializeComponent();
this.db = new CarRentEntities();
this.AdminId = adminId;
LblAdmin.Text += db.Administrators.Find(this.AdminId).Name + " " + db.Administrators.Find(this.AdminId).Surname;
FillDGV(db.CarsOnRent.OrderByDescending(c => c.ReturnDate).ToList());
}
public static List <CarType> getAllCarsType()
{
using (CarRentEntities db = new CarRentEntities())
{
List <CarType> allTypes = db.CarTypes.ToList();
return(allTypes);
}
}
public RentedCars(int adminId)
{
InitializeComponent();
this.db = new CarRentEntities();
this.AdminId = adminId;
LblAdmin.Text += db.Administrators.Find(this.AdminId).Name + " " + db.Administrators.Find(this.AdminId).Surname;
FillDGV(db.CarsOnRent.Where(c => c.AcceptedDate == null).ToList());
}
public Dashboard(int AdminId)
{
InitializeComponent();
this.db = new CarRentEntities();
this.adminId = AdminId;
LblAdmin.Text += db.Administrators.Find(this.adminId).Name + " " + db.Administrators.Find(this.adminId).Surname;
FillDGV();
}
public Task <IApiResult> GetDevice(P_Devices.PDevicesByDeviceID arg)
{
return(Task.Run(() =>
{
IApiResult hr = new IApiResult();
try
{
using (CarRentEntities cre = new CarRentEntities())
{
Func <double, double, bool> inoutChina = (lat, lng) => Mgoo.CarRent.Position.ZCChinaLocation.InOutChina(Convert.ToDouble(lat), Convert.ToDouble(lng));
var devs = from d in cre.Devices
join l in cre.LKLocation
on d.DeviceID equals l.DeviceID
into dl
from dli in dl.DefaultIfEmpty()
where d.DeviceID == arg.deviceid && d.Deleted == false
// let po = new Position.Point(Convert.ToDouble(dli.OLat ?? -1.00m), Convert.ToDouble(dli.OLng ?? -1.00m))
//let isChina = inoutChina(po.Lat, po.Lng)
//let point = isChina ? new Position.Point(po.Lat, po.Lng) : Position.PositionUtil.gps84_To_Gcj02(po.Lat, po.Lng)
select new Models.Return.R_Devices.GetDevice_Result
{
DeviceID = d.DeviceID,
DeviceName = d.DeviceName,
SerialNumber = d.SerialNumber,
Status = d.Status,
DataContext = dli.DataContext ?? "",
Lat = dli.OLat ?? -1.00m,
Lng = dli.OLng ?? -1.00m,
Speed = dli.Speed ?? default(decimal),
LastCommunication = dli.LastCommunication == null ? default(DateTime) : dli.LastCommunication,
Course = dli.Course ?? default(decimal),
IsStop = dli.IsStop ?? default(int)
};
var list = devs.ToList();
list.ForEach((item) =>
{
//如果是在中国大陆则需要转换一下坐标
if (Position.ZCChinaLocation.InOutChina(Convert.ToDouble(item.Lat), Convert.ToDouble(item.Lng)))
{
Position.Point point = Position.PositionUtil.gps84_To_Gcj02(Convert.ToDouble(item.Lat), Convert.ToDouble(item.Lng));
item.Lng = Convert.ToDecimal(point.Lng);
item.Lat = Convert.ToDecimal(point.Lat);
}
});
hr.result = list;
hr.message = $"查询到{list.Count}条数据.";
}
}
catch (Exception ex)
{
hr.message = ex.Message;
hr.code = StatusCode.error;
Log.Error(this, ex);
}
return hr;
}));
}
public Login()
{
InitializeComponent();
this.CenterToScreen();
this.db = new CarRentEntities();
pbx.Visible = false;
pbx2.Visible = false;
txtPass.UseSystemPasswordChar = true;
}
public ActionResult getLoginData(UserModel obj)
{
CarRentEntities db = new CarRentEntities();
var user = db.Users.FirstOrDefault(x => x.login.Equals(obj.Login) && x.password.Equals(obj.Password));
return(new JsonResult {
Data = user, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public CarsOptions(int adminId)
{
InitializeComponent();
this.db = new CarRentEntities();
this.AdminId = adminId;
LblAdmin.Text += db.Administrators.Find(this.AdminId).Name + " " + db.Administrators.Find(this.AdminId).Surname;
FillDGV();
FillCbCarBrand();
}
public NewRent(int AdminId)
{
InitializeComponent();
this.db = new CarRentEntities();
this.adminId = AdminId;
LblAdmin.Text += db.Administrators.Find(this.adminId).Name + " " + db.Administrators.Find(this.adminId).Surname;
FillCbName();
FillCbCarBrand();
}
public Reports(int UserId)
{
InitializeComponent();
this.Size = new Size(1430, 650);
this.CenterToScreen();
this.db = new CarRentEntities();
this.userId = UserId;
FillDgv(db.Orders.ToList());
}
