public IHttpActionResult PostOwner(CITY data)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
db.CITies.Add(data);
db.SaveChanges();
}
catch (Exception)
{
dynamic User = new ExpandoObject();
User.Message = "Something went wrong !";
return(User);
}
return(Ok(data));
}
/// <summary>
/// 根据省份id获取城市
/// </summary>
/// <param name="proId">province_id</param>
/// <returns></returns>
public static List <CITY> getCityByProId(string proId)
{
List <CITY> lst = new List <CITY>();
try
{
string sql = "select id,province_id,city_id,city_name from city where province_id='" + proId + "' order by city_id ";
DataTable dt = MySqlDHelper.ExecuteDataTable(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
CITY city = new CITY();
city.ID = int.Parse(row["id"].ToString());
city.PROVINCE_ID = row["province_id"].ToString();
city.CITY_ID = row["city_id"].ToString();
city.CITY_NAME = row["city_name"].ToString();
lst.Add(city);
}
}
return(lst);
}
catch (Exception e)
{
string err = new DateTime().ToString() + " 根据省份id获取城市：region/getCityByProId ,错误：" + e.Message;
LogHelper.WriteLog(err);
return(lst);
}
}
public ActionResult DeleteConfirmed(string id)
{
CITY cITY = db.CITY.Find(id);
db.CITY.Remove(cITY);
db.SaveChanges();
return RedirectToAction("Index");
}
public IHttpActionResult PutOwnerMaster(CITY City)
{
db.Configuration.ProxyCreationEnabled = false;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
CITY objEmp = new CITY();
objEmp = db.CITies.Find(City.CITYID);
if (objEmp != null)
{
objEmp.CITYNAME = City.CITYNAME;
objEmp.PROVINCEID = City.PROVINCEID;
}
int i = this.db.SaveChanges();
}
catch (Exception)
{
dynamic User = new ExpandoObject();
User.Message = "Something went wrong !";
return(User);
}
return(Ok(City));
}
public IEnumerable <CITY> GetCity(string city_name)
{
List <CITY> myList = new List <CITY>();
SqlConnection connection = new SqlConnection(this.connectionStrings.MyDefaultConnection);
//connection.Open();
if (string.IsNullOrWhiteSpace(city_name))
{
city_name = "%%";
}
else
{
city_name = "%" + city_name + "%";
}
SqlDataAdapter da = new SqlDataAdapter("select city_num,city_name from main.cr_city where city_name_a like @city_name", connection);
da.SelectCommand.Parameters.Add(new SqlParameter("@city_name", city_name));
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CITY CITY = new CITY();
CITY.city_num = int.Parse(ds.Tables[0].Rows[i]["city_num"].ToString());
CITY.city_name = ds.Tables[0].Rows[i]["city_name"].ToString();
myList.Add(CITY);
}
}
return(myList);
}
public void DeleteCity(CityModel City)
{
if (City == null)
{
throw new ArgumentNullException();
}
using (AppTourEntities data = new AppTourEntities())
{
CITY current = data.CITY.Where(x => x.ID == City.Id).SingleOrDefault();
if (current != null)
{
try
{
data.DeleteObject(current);
data.SaveChanges();
}
catch (UpdateException upx)
{
throw new UpdateException(upx.InnerException.Message);
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void UpdateCity(CityModel City)
{
using (AppTourEntities data = new AppTourEntities())
{
CITY current = data.CITY.Where(x => City.Id == x.ID).SingleOrDefault();
if (current != null)
{
try
{
current.COUNTRY = data.COUNTRY.Where(x => x.ID == City.Country.Id).SingleOrDefault();
current.NAME = City.Name;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public IHttpActionResult PutOwnerMaster(CITY City)
{
db.Configuration.ProxyCreationEnabled = false;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
CITY objEmp = new CITY();
objEmp = db.CITies.Find(City.CITYID);
if (objEmp != null)
{
objEmp.CITYNAME = City.CITYNAME;
objEmp.PROVINCEID = City.PROVINCEID;
}
int i = this.db.SaveChanges();
}
catch (Exception)
{
return(null);
}
return(Ok(City));
}
// PUT: odata/CITies(5)
public IHttpActionResult Put([FromODataUri] decimal key, CITY cITY)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (key != cITY.ID)
{
return(BadRequest());
}
db.Entry(cITY).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CITYExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(cITY));
}
public bool DeleteOwner(int id)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
try
{
CITY CityDetails = db.CITies.Find(id);
if (CityDetails == null)
{
return(false);
}
else
{
var propExist = db.AREAs.Where(kk => kk.CITYID == CityDetails.CITYID).ToList();
if (propExist.Count == 0)
{
db.CITies.Remove(CityDetails);
db.SaveChanges();
}
else
{
return(false);
}
}
return(false);
}
catch (Exception)
{
return(false);
}
}
public async Task <IHttpActionResult> PostCITY(CITY cITY)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CITY.Add(cITY);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (CITYExists(cITY.CityCode))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = cITY.CityCode }, cITY));
}
public async Task <IHttpActionResult> PutCITY(string id, CITY cITY)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != cITY.CityCode)
{
return(BadRequest());
}
db.Entry(cITY).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CITYExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Patch([FromODataUri] decimal key, Delta <CITY> patch)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
CITY cITY = db.CITies.Find(key);
if (cITY == null)
{
return(NotFound());
}
patch.Patch(cITY);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CITYExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(cITY));
}
public Address(string street, int houseNO, CITY city, int zipcode)
{
Street = street;
HouseNO = houseNO;
City = city;
ZipCode = zipcode;
}
/// <summary>
/// Initializes a new instance of the Branch class to the value indicated
/// by the given parameters.
/// </summary>
public Client(string name, string street, int houseNo, CITY city, int zipCode, string phoneNumber = null)
{
BirthDate = new DateTime(1996, 1, 1);
Name = name;
Add = new Address(street, houseNo, city, zipCode);
Location = Add;
PhoneNumber = phoneNumber;
}
public ActionResult Edit([Bind(Include = "CITY_NAME")] CITY cITY)
{
if (ModelState.IsValid)
{
db.Entry(cITY).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(cITY);
}
public ActionResult CityIndex(string id)
{
CITY s = new CITY();
ViewBag.Title = "City List";
List <SelectList> list = new List <SelectList>();
ViewBag.country_id = new SelectList(countryUtil.GetCountry(), "Value", "Text");
ViewBag.state_id = list;
return(View(s));
}
public ActionResult Create([Bind(Include = "CITY_NAME")] CITY cITY)
{
if (ModelState.IsValid)
{
db.CITY.Add(cITY);
db.SaveChanges();
return Redirect("~/Place");
}
return View(cITY);
}
// POST: odata/CITies
public IHttpActionResult Post(CITY cITY)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CITies.Add(cITY);
db.SaveChanges();
return(Created(cITY));
}
/// <summary>
/// Initializes a new instance of the Branch class to the value indicated
/// by the given parameters.
/// </summary>
public Branch(string name, string street, int houseNo, CITY city, int zipCode, string managerName, string phoneNumber, KOSHER kosher)
{
Add = new Address();
Name = name;
Add.Street = street;
Add.HouseNO = houseNo;
Add.City = city;
Add.ZipCode = zipCode;
ManagerName = managerName;
PhoneNumber = phoneNumber;
Kosher = kosher;
}
public bool PutCity(CITY city)
{
var isUpdated = sportsSideService.PutCity(city);
if (isUpdated)
{
return(true);
}
else
{
return(false);
}
}
// GET: City/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
CITY cITY = db.CITY.Find(id);
if (cITY == null)
{
return HttpNotFound();
}
return View(cITY);
}
public bool PostCity(CITY city)
{
var isSaved = sportsSideService.PostCity(city);
if (isSaved)
{
return(true);
}
else
{
return(false);
}
}
public bool DeleteCity(CITY city)
{
var isDeleted = sportsSideService.DeleteCity(city);
if (isDeleted)
{
return(true);
}
else
{
return(false);
}
}
public bool DeleteCity(CITY city)
{
try
{
db.Entry(city).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool PostCity(CITY city)
{
try
{
db.CITY.Add(city);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public async Task <IHttpActionResult> DeleteCITY(string id)
{
CITY cITY = await db.CITY.FindAsync(id);
if (cITY == null)
{
return(NotFound());
}
db.CITY.Remove(cITY);
await db.SaveChangesAsync();
return(Ok(cITY));
}
// DELETE: odata/CITies(5)
public IHttpActionResult Delete([FromODataUri] decimal key)
{
CITY cITY = db.CITies.Find(key);
if (cITY == null)
{
return(NotFound());
}
db.CITies.Remove(cITY);
db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult DeleteOwner(int id)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
CITY CityDetails = db.CITies.Find(id);
if (CityDetails == null)
{
return(NotFound());
}
db.CITies.Remove(CityDetails);
db.SaveChanges();
return(Ok(CityDetails));
}
public double revenueForCity(CITY city)
{
var x = from a in dal.getOrdersList()
group a by dal.getBranch(a.BranchID).Add.City into g
select g;
double sum = 0;
foreach (var item in x)
{
if (item.Key == city)
{
foreach (var i in item)
{
sum += calcTotalPrice(i.OrderID);
}
}
}
return(sum);
}
