public Task <IApiResult> DelGeofence(P_OnlyOneID arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
DAL.GeoFence gf = new DAL.GeoFence()
{
GeofenceID = arg.id
};
db.GeoFence.Attach(gf);
db.GeoFence.Remove(gf);
var i = db.SaveChanges();
ar.message = $"Deleted {i} data";
}
}
catch (Exception ex)
{
ar.message = ex.Message;
ar.code = Interface.StatusCode.error;
}
return ar;
}));
}
/// <summary>
/// 修改个人信息
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> UpdateUsersInfo(P_Users.P_UpdateUsersInfo arg)
{
return(Task.Run(() =>
{
IApiResult hr = new IApiResult();
try
{
//DAL.Users user = new DAL.Users();
//user.UserID = userInfo.UserID;
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
var u = db.Users.Find(arg.userid);
u.UserName = arg.username;
u.CellPhone = arg.phone;
u.FirstName = arg.contact;
u.PrimaryEmail = arg.email;
u.Address1 = arg.address;
u.UpdateTime = DateTime.Now;
u.ActivationCount = arg.price * 100;
db.SaveChanges();
}
hr.message = "User information is modified successfully";
hr.result = new { url = "reload" };
}
catch (Exception ex)
{
Log.Error(this, ex);
hr.code = StatusCode.error;
hr.message = ex.Message;
}
return hr;
}));
}
/// <summary>
/// 修改用户密码
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> UpdateUserPwd(P_Users.P_UpdatePwd arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
var us = db.Users.Where(u => u.UserID == arg.userid).FirstOrDefault();
if (us != null && us.Password == arg.old_userpwd)
{
us.Password = arg.new_userpwd;
db.SaveChanges();
ar.message = "success!";
}
else
{
ar.code = Interface.StatusCode.parameterError;
ar.message = "Old password error";
}
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.code = Interface.StatusCode.error;
ar.message = ex.Message;
}
return ar;
}));
}
public Task <IApiResult> ProofReview(P_OnlyOneID arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
var rr = db.RechargeRecord.Where(r => r.RID == arg.id && r.IsCheck == false).FirstOrDefault();
var user = db.Users.First(u => u.UserID == rr.UserID);
if (rr != null)
{
rr.IsCheck = true;
rr.CheckTime = DateTime.Now;
var money = user.MoneyCount;
user.MoneyCount = money + rr.Money;
db.SaveChanges();
}
ar.message = "Has been reviewed.";
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.message = ex.Message;
ar.code = StatusCode.error;
}
return ar;
}));
}
/// <summary>
/// 删除子用户
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> DelUserInfo(P_Users.P_DelUser arg)
{
return(Task.Run(() => {
IApiResult ar = new IApiResult();
try
{
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
DAL.Users us = new DAL.Users();
var res = db.Users.First(u => u.UserID == arg.userid);
res.Deleted = true;
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 Task <IApiResult> RechargeApply(P_Users.P_RechargeApply arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
string path = "", fileName = "";
using (MemoryStream stream = new MemoryStream(Convert.FromBase64String(arg.proof)))
{
var img = new Bitmap(stream);
fileName = DateTime.Now.Ticks + ".png";
string baseDirectory = System.AppDomain.CurrentDomain.BaseDirectory;
path = "/Assets/images/proof/";
if (!System.IO.Directory.Exists(baseDirectory + path))
{
Directory.CreateDirectory(baseDirectory + path);
}
img.Save(baseDirectory + path + fileName);
stream.Dispose();
img.Dispose();
}
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
DAL.RechargeRecord rr = new DAL.RechargeRecord();
rr.Money = arg.money;
rr.Created = DateTime.Now;
rr.UserID = userInfo.UserID;
rr.PaymentMethod = arg.payment_method;
rr.TransferMethod = arg.transfer_method;
rr.TransferTime = arg.transfer_time;
rr.ProofImg = path + fileName;
rr.IsCheck = false;
rr.Remark = arg.remark;
db.RechargeRecord.Add(rr);
int i = db.SaveChanges();
ar.message = i + " row of data is affected.";
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.code = StatusCode.error;
ar.message = ex.Message;
}
return ar;
}));
}
/// <summary>
/// 添加子用户
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> AddUsers(P_Users.P_AddUsers arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
DAL.Users us = new DAL.Users();
us.UserName = arg.username;
us.LoginName = arg.account;
us.FirstName = arg.contact;
us.CellPhone = arg.phone;
us.Password = "******";
us.Address1 = arg.address;
us.Deleted = false;
us.PrimaryEmail = arg.email;
us.Created = DateTime.Now;
us.UpdateTime = DateTime.Now;
us.AllDeviceCount = 0;
us.ActivationCount = arg.price * 100;
us.MoneyCount = 0;
us.ParentID = 1;
us.SuperAdmin = 0;
db.Users.Add(us);
db.SaveChanges();
ar.message = "Add successfu!";
ar.result = new { url = "reload" };
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.code = StatusCode.error;
ar.message = ex.Message;
}
return ar;
}));
}
public Task <IApiResult> AddGeofenceCircle(PGeofence.AddGeofenceCircle arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
try
{
DAL.GeoFence fence = new DAL.GeoFence();
fence.Created = DateTime.Now;
fence.Deleted = false;
fence.FenceName = arg.name;
fence.DeviceID = arg.deviceid;
fence.Latitude = arg.latitude;
fence.Longitude = arg.longitude;
fence.Radius = Convert.ToDecimal(arg.radius.ToString("0.00"));
fence.FenceType = 0; // 圆形
fence.UserID = arg.userid;
fence.Description = arg.description;
fence.IsInclusion = -1;
fence.Entry = false;
fence.Exit = false;
db.GeoFence.Add(fence);
db.SaveChanges();
var geoid = fence.GeofenceID;
ar.message = "success!";
}
catch (Exception ex)
{
ar.code = Interface.StatusCode.error;
ar.message = ex.Message;
Log.Error(this, ex);
}
}
return ar;
}));
}
/// <summary>
/// 注册用户信息
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public async Task <IApiResult> Register(Mgoo.CarRent.Models.Parameter.PRegister arg)
{
return(await Task.Run(() =>
{
var ar = new IApiResult();
try
{
DAL.Users user = new DAL.Users();
user.Created = DateTime.Now;
user.UpdateTime = DateTime.Now;
user.UserName = arg.username;
user.Password = arg.password;
user.LoginName = arg.phone;
user.UserType = 2;
user.ParentID = 1;
user.CellPhone = arg.phone;
user.TimeZone = "China Standard Time";
user.Deleted = false;
user.SuperAdmin = 0;
user.Gender = false;
user.MoneyCount = 0;
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
db.Users.Add(user);
db.SaveChanges();
}
ar.message = "success!";
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.message = ex.Message;
ar.code = StatusCode.error;
}
return ar;
}));
}
public Task <IApiResult> AddGeofencePolygon(PGeofence.AddGeofencePolygon arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
DAL.GeoFence fence = new DAL.GeoFence();
fence.Created = DateTime.Now;
fence.Deleted = false;
fence.FenceName = arg.name;
fence.UserID = arg.userid;
fence.FenceType = 1; //多边形
fence.Description = arg.description;
fence.SouthWestLat = arg.south_west_lat;
fence.SouthWestLng = arg.south_west_lng;
fence.NorthEastLat = arg.north_east_lat;
fence.NorthEastLng = arg.north_east_lng;
fence.Bounds = arg.bounds;
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
db.GeoFence.Add(fence);
db.SaveChanges();
ar.message = "success!";
}
}
catch (Exception ex)
{
ar.code = Interface.StatusCode.error;
ar.message = ex.Message;
Log.Error(this, ex);
}
return ar;
}));
}
public Task <IApiResult> DeleteRecharge(P_OnlyOneID arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
using (DAL.CarRentEntities db = new DAL.CarRentEntities())
{
var rr = db.RechargeRecord.First(r => r.RID == arg.id);
rr.Deleted = true;
db.SaveChanges();
ar.message = "success!";
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.message = ex.Message;
ar.code = StatusCode.error;
}
return ar;
}));
}