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)); } }