public IHttpActionResult PostOwner(PROVINCE data) { INF370Entities db = new INF370Entities(); db.Configuration.ProxyCreationEnabled = false; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { db.PROVINCEs.Add(data); db.SaveChanges(); } catch (Exception) { dynamic User = new ExpandoObject(); User.Message = "Something went wrong !"; return(User); } return(Ok(data)); }
public IHttpActionResult PutPROVINCE(int id, PROVINCE pROVINCE) { if (id != pROVINCE.PROVINCE_ID) { return(BadRequest()); } db.Entry(pROVINCE).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!PROVINCEExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// 获取所有省份 /// </summary> /// <returns></returns> public static List <PROVINCE> getAllProvince() { List <PROVINCE> lst = new List <PROVINCE>(); try { string sql = "select id,province_id,province_name from province order by province_id "; DataTable dt = MySqlDHelper.ExecuteDataTable(sql); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { PROVINCE pr = new PROVINCE(); pr.ID = int.Parse(row["id"].ToString()); pr.PROVINCE_ID = row["province_id"].ToString(); pr.PROVINCE_NAME = row["province_name"].ToString(); lst.Add(pr); } } return(lst); } catch (Exception e) { string err = new DateTime().ToString() + " 获取所有省份:region/getAllProvince ,错误:" + e.Message; LogHelper.WriteLog(err); return(lst); } }
public IHttpActionResult PutOwnerMaster(PROVINCE Province) { db.Configuration.ProxyCreationEnabled = false; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { PROVINCE objEmp = new PROVINCE(); objEmp = db.PROVINCEs.Find(Province.PROVINCEID); if (objEmp != null) { objEmp.PROVINCENAME = Province.PROVINCENAME; } int i = this.db.SaveChanges(); } catch (Exception) { dynamic User = new ExpandoObject(); User.Message = "Something went wrong !"; return(User); } return(Ok(Province)); }
public bool DeleteProvince(int id) { INF370Entities db = new INF370Entities(); db.Configuration.ProxyCreationEnabled = false; try { PROVINCE ProvinceDetails = db.PROVINCEs.Find(id); if (ProvinceDetails == null) { return(false); } else { var propExist = db.CITies.Where(kk => kk.PROVINCEID == ProvinceDetails.PROVINCEID).ToList(); if (propExist.Count == 0) { db.PROVINCEs.Remove(ProvinceDetails); db.SaveChanges(); } else { return(false); } } return(true); } catch (Exception) { return(false); } }
public IHttpActionResult GetPROVINCE(int id) { PROVINCE pROVINCE = db.PROVINCE.Find(id); if (pROVINCE == null) { return(NotFound()); } return(Ok(pROVINCE)); }
public IHttpActionResult DeletePROVINCE(int id) { PROVINCE pROVINCE = db.PROVINCE.Find(id); if (pROVINCE == null) { return(NotFound()); } db.PROVINCE.Remove(pROVINCE); db.SaveChanges(); return(Ok(pROVINCE)); }
public IHttpActionResult DeleteProvince(int id) { INF370Entities db = new INF370Entities(); db.Configuration.ProxyCreationEnabled = false; PROVINCE ProvinceDetails = db.PROVINCEs.Find(id); if (ProvinceDetails == null) { return(NotFound()); } db.PROVINCEs.Remove(ProvinceDetails); db.SaveChanges(); return(Ok(ProvinceDetails)); }
public IHttpActionResult GetProvinceDetailsById(string ProvinceID) { db.Configuration.ProxyCreationEnabled = false; PROVINCE objEmp = new PROVINCE(); try { int ID = Convert.ToInt32(ProvinceID); objEmp = db.PROVINCEs.Find(ID); if (objEmp == null) { return(NotFound()); } } catch (Exception) { return(null); } return(Ok(objEmp)); }
public IHttpActionResult PostPROVINCE(PROVINCE pROVINCE) { db.PROVINCE.Add(pROVINCE); try { db.SaveChanges(); } catch (DbUpdateException) { if (PROVINCEExists(pROVINCE.PROVINCE_ID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = pROVINCE.PROVINCE_ID }, pROVINCE)); }
public IHttpActionResult GetProvinceDetailsById(string ProvinceID) { db.Configuration.ProxyCreationEnabled = false; PROVINCE objEmp = new PROVINCE(); int ID = Convert.ToInt32(ProvinceID); try { objEmp = db.PROVINCEs.Find(ID); if (objEmp == null) { return(NotFound()); } } catch (Exception) { dynamic User = new ExpandoObject(); User.Message = "Something went wrong !"; return(User); } return(Ok(objEmp)); }
public IHttpActionResult PutOwnerMaster(PROVINCE Province) { db.Configuration.ProxyCreationEnabled = false; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { PROVINCE objEmp = new PROVINCE(); objEmp = db.PROVINCEs.Find(Province.PROVINCEID); if (objEmp != null) { objEmp.PROVINCENAME = Province.PROVINCENAME; } int i = this.db.SaveChanges(); } catch (Exception) { return(null); } return(Ok(Province)); }
public IHttpActionResult PostOwner(PROVINCE data) { INF370Entities db = new INF370Entities(); db.Configuration.ProxyCreationEnabled = false; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { db.PROVINCEs.Add(data); db.SaveChanges(); } catch (Exception) { return(null); } return(Ok(data)); }