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