public APIResult <DAL.tbl_vehicles> Put(int id, DAL.tbl_vehicles value)
{
try
{
using (var ctx = new MainEntities())
{
var u = APIRequest.User(HttpContext.Current.Request);
var v = ctx.tbl_vehicles.Find(id);
//v.id = id;
v.capacity = value.capacity;
v.color = value.color;
v.model = value.model;
v.license_no = value.license_no;
//ctx.Set<DAL.tbl_vehicles>().Attach(v);
ctx.Entry(v).State = System.Data.Entity.EntityState.Modified;
var result = ctx.SaveChanges();
if (result <= 0)
{
return(APIResult <DAL.tbl_vehicles> .Error(ResponseCode.BackendDatabase, "Error while saving data!"));
}
return(APIResult <DAL.tbl_vehicles> .Success(value, "API_SUCCESS"));
}
}
catch (Exception ex)
{
return(APIResult <DAL.tbl_vehicles> .Error(ResponseCode.BackendDatabase, ex.Message));
}
}
public static Users User(HttpRequest request)
{
try
{
var AuthKey = request.Headers.GetValues("AUTH_KEY");
if (AuthKey == null)
{
return(null);
}
using (MainEntities ctx = new MainEntities())
{
var result = ctx.sec_sessions.Find(Guid.Parse(AuthKey.First().ToString()));
if (result == null || result.end_time != null)
{
return(null);
}
return(new Users(result.user_id));
}
}
catch (Exception)
{
return(null);
}
}
// GET api/values/5
public APIResult <VehicleResponse> Get(int id)
{
try
{
using (var ctx = new MainEntities())
{
var data = ctx.Set <DAL.tbl_vehicles>().Find(id);
var car = new VehicleResponse()
{
data = data,
images = new ImagesResponse()
{
Count = ctx.tbl_images.Where(d => d.model_name == "tbl_vehicles" && d.model_id == data.id && d.model_tag == "main").Count(),
Url = (ctx.tbl_images.Where(d => d.model_name == "tbl_vehicles" && d.model_id == data.id && d.model_tag == "main").Count() == 0) ? "" : "/img/scale/tbl_vehicles/" + data.id + "/original/main-{index}.gif"
}
};
if (data == null)
{
return(APIResult <VehicleResponse> .Error(ResponseCode.BackendDatabase, "Error while getting the vehicle data !"));
}
return(APIResult <VehicleResponse> .Success(car, "API_SUCCESS"));
}
}
catch (Exception ex)
{
return(APIResult <VehicleResponse> .Error(ResponseCode.BackendDatabase, ex.Message));
}
}
public static void Load()
{
using (MainEntities ctx = new MainEntities())
{
AppSetting = ctx.tbl_setting.ToList();
}
}
public APIResult <bool> Rate(int id, RateRequest request)
{
var u = APIRequest.User(HttpContext.Current.Request);
using (var ctx = new MainEntities())
{
var books = ctx.trip_book.Include("trip_request_details").Include("trip_request_details.trip_request").Where(a => a.trip_share_details_id == id && a.trip_request_details.trip_request.created_by == u.Entity.id);
if (books == null || books.Count() == 0)
{
return(APIResult <bool> .Error(ResponseCode.UserValidationField, "This trip not found !"));
}
foreach (var book in books)
{
//if (book.trip_request_details.trip_request.rider_id == u.Entity.id)
//{
// return APIResult<bool>.Error(ResponseCode.UserValidationField, "You cannot rate this trip!");
//}
book.rider_rate = request.rate;
book.rate_comment = request.comment;
book.rate_reason_id = request.reason_id;
ctx.Entry(book).State = System.Data.Entity.EntityState.Modified;
}
ctx.SaveChanges();
return(APIResult <bool> .Success(true));
}
}
public APIResult <bool> Delete(int id)
{
//var accs = new BL.Accounts.Accounts();
using (MainEntities ctx = new MainEntities())
{
tbl_images img = ctx.tbl_images.Where(a => a.id == id).FirstOrDefault();
if (img != null)
{
try
{
ctx.Entry(img).State = System.Data.Entity.EntityState.Deleted;
System.IO.File.Delete(HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["mediaServer_Path"] + img.large));
System.IO.File.Delete(HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["mediaServer_Path"] + img.thumb));
System.IO.File.Delete(HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["mediaServer_Path"] + img.meduim));
System.IO.File.Delete(HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["mediaServer_Path"] + img.original));
}
catch (Exception)
{
}
return(APIResult <bool> .Success(true, "API_SUCCESS"));
}
}
return(APIResult <bool> .Error(ResponseCode.BackendInternalServer, "API_ERROR_BAD"));
}
/// <summary>
/// Get one image by ID
/// </summary>
/// <param name="id">Image ID</param>
/// <returns>List Of tbl_mages</returns>
public APIResult <tbl_images> Get(int id)
{
using (MainEntities ctx = new MainEntities())
{
tbl_images img = ctx.tbl_images.Where(a => a.id == id).FirstOrDefault();
if (img != null)
{
return(APIResult <tbl_images> .Success(img, "API_SUCCESS"));
}
}
return(APIResult <tbl_images> .Error(ResponseCode.BackendInternalServer, "Bad Request!"));
}
public Users CurrentUser(HttpRequestMessage request)
{
var AuthKey = request.Headers.GetValues("AUTH_KEY");
using (MainEntities ctx = new MainEntities())
{
var result = ctx.sec_sessions.Find(Guid.Parse(AuthKey.First().ToString()));
if (result == null || result.end_time != null)
{
return(null);
}
return(new Users(result.user_id));
}
}
