public HttpResponseMessage UpdateData(string user_id, string profession_type_id, [FromBody] preg_profession dataUpdate) { try { if (!dataUpdate.DeepEquals(new preg_profession())) { preg_profession profession = new preg_profession(); profession = dao.GetItemByID(Convert.ToInt32(user_id), Convert.ToInt32(profession_type_id)).FirstOrDefault(); if (profession == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, SysConst.DATA_NOT_FOUND)); } if (dataUpdate.status != null) { profession.status = dataUpdate.status; } dao.UpdateData(profession); return(Request.CreateResponse(HttpStatusCode.Accepted, SysConst.DATA_UPDATE_SUCCESS)); } else { HttpError err = new HttpError(SysConst.DATA_NOT_EMPTY); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err)); } } catch (Exception ex) { HttpError err = new HttpError(ex.Message); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err)); } }
public HttpResponseMessage Post([FromBody] preg_profession data) { try { if (data.user_id != 0 && data.profession_type_id != 0) { //Check user & profession type exist using (PregnancyEntity connect = new PregnancyEntity()) { preg_user checkUserExist = connect.preg_user.Where(c => c.id == data.user_id).FirstOrDefault(); preg_profession_type checkPTypeExist = connect.preg_profession_type.Where(c => c.id == data.profession_type_id).FirstOrDefault(); if (checkUserExist == null || checkPTypeExist == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, SysConst.DATA_NOT_FOUND)); } } dao.InsertData(data); return(Request.CreateResponse(HttpStatusCode.Created, SysConst.DATA_INSERT_SUCCESS)); } else { HttpError err = new HttpError(SysConst.DATA_NOT_EMPTY); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err)); } } catch (Exception ex) { HttpError err = new HttpError(ex.Message); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, err)); } }
public void DeleteData(int user_id, int profession_type_id) { preg_profession item = GetItemByID(user_id, profession_type_id).FirstOrDefault(); connect.preg_profession.Remove(item); connect.SaveChanges(); }
public HttpResponseMessage Get(string user_id, string profession_type_id) { try { preg_profession data = dao.GetItemByID(Convert.ToInt32(user_id), Convert.ToInt32(profession_type_id)).FirstOrDefault(); if (data != null) { return(Request.CreateResponse(HttpStatusCode.OK, data)); } else { HttpError err = new HttpError(SysConst.DATA_NOT_FOUND); return(Request.CreateErrorResponse(HttpStatusCode.NotFound, err)); } } catch (Exception ex) { HttpError err = new HttpError(ex.Message); return(Request.CreateErrorResponse(HttpStatusCode.NotFound, err)); } }
public IQueryable <preg_profession> GetItemsByParams(preg_profession data) { IQueryable <preg_profession> result = connect.preg_profession; for (int i = 0; i < data.GetType().GetProperties().ToList().Count(); i++) { string propertyName = data.GetType().GetProperties().ToList()[i].Name; var propertyValue = data.GetType().GetProperty(propertyName).GetValue(data, null); if (propertyName == "user_id" && (int)propertyValue != 0) { result = result.Where(c => c.user_id == (int)(propertyValue)); } else if (propertyName == "profession_type_id" && (int)propertyValue != 0) { result = result.Where(c => c.profession_type_id == (int)(propertyValue)); } else if (propertyName == "status" && propertyValue != null) { result = result.Where(c => c.status == (int)(propertyValue)); } } return(result); }
public HttpResponseMessage Get([FromUri] preg_profession data) { try { if (!data.DeepEquals(new preg_profession())) { IEnumerable <preg_profession> result = dao.GetItemsByParams(data); if (result.Count() > 0) { return(Request.CreateResponse(HttpStatusCode.OK, result)); } else { HttpError err = new HttpError(SysConst.DATA_NOT_FOUND); return(Request.CreateErrorResponse(HttpStatusCode.NotFound, err)); } } else { IEnumerable <preg_profession> result = dao.GetListItem(); if (result.Count() > 0) { return(Request.CreateResponse(HttpStatusCode.OK, result)); } else { HttpError err = new HttpError(SysConst.DATA_NOT_FOUND); return(Request.CreateErrorResponse(HttpStatusCode.NotFound, err)); } } } catch (Exception ex) { HttpError err = new HttpError(ex.Message); return(Request.CreateErrorResponse(HttpStatusCode.NotFound, err)); } }
public HttpResponseMessage Put(string user_id, string profession_type_id, [FromBody] preg_profession dataUpdate) { return(UpdateData(user_id, profession_type_id, dataUpdate)); }
public void UpdateData(preg_profession item) { connect.SaveChanges(); }
public void InsertData(preg_profession item) { connect.preg_profession.Add(item); connect.SaveChanges(); }