public CityModel DeleteCity(int intCityId) { CityModel _objdata = new CityModel(); tbl_Cities _objCity = new tbl_Cities(); try { using (newconecommerce dataContext = new newconecommerce()) { dataContext.Database.Connection.Open(); var _query = dataContext.tbl_Cities.Where(x => x.int_Id == intCityId).FirstOrDefault(); if (_query != null) { tbl_Cities _log = new tbl_Cities(); _log = dataContext.tbl_Cities.Where(x => x.int_Id == intCityId).FirstOrDefault(); _log.b_flag = false; dataContext.SaveChanges(); dataContext.Database.Connection.Close(); } _objdata.StatusMessaage = "City deleted sucessfully."; return(_objdata); } } catch (Exception) { throw; } }
public CityModel UpdateCity(CityModel _objdata) { tbl_Cities _objproduct = new tbl_Cities(); try { using (newconecommerce dataContext = new newconecommerce()) { dataContext.Database.Connection.Open(); var _query = dataContext.tbl_Cities.Where(x => x.int_Id == _objdata.intCityId).FirstOrDefault(); if (_query != null) { tbl_Cities _log = new tbl_Cities(); _log = dataContext.tbl_Cities.Where(x => x.int_Id == _objdata.intCityId).FirstOrDefault(); _log.v_City = _objdata.strCityName; _log.int_State_Id = _objdata.intStateId; dataContext.SaveChanges(); dataContext.Database.Connection.Close(); } _objdata.StatusMessaage = "City Updated sucessfully."; return(_objdata); } } catch (Exception ex) { throw ex; } }
public ActionResult DeleteConfirmed(int id) { tbl_Cities tbl_Cities = db.tbl_Cities.Find(id); db.tbl_Cities.Remove(tbl_Cities); db.SaveChanges(); return(RedirectToAction("Index")); }
private void ChangeLocation_B_Click(object sender, RoutedEventArgs e) { String CityName = this.Cities_LB.SelectedValue.ToString(); if (!String.IsNullOrWhiteSpace(CityName) && !String.IsNullOrEmpty(CityName)) { tbl_Cities NewCity = this.channel.Get_City(CityName); this.channel.Change_Status(NewCity); } }
public ActionResult Edit([Bind(Include = "City_ID,City_Name,AccountID")] tbl_Cities tbl_Cities) { if (ModelState.IsValid) { db.Entry(tbl_Cities).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AccountID = new SelectList(db.tbl_Accounts, "Account_ID", "Account_FirstName", tbl_Cities.AccountID); return(View(tbl_Cities)); }
// GET: Cities/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Cities tbl_Cities = db.tbl_Cities.Find(id); if (tbl_Cities == null) { return(HttpNotFound()); } return(View(tbl_Cities)); }
// GET: Cities/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Cities tbl_Cities = db.tbl_Cities.Find(id); if (tbl_Cities == null) { return(HttpNotFound()); } ViewBag.AccountID = new SelectList(db.tbl_Accounts, "Account_ID", "Account_FirstName", tbl_Cities.AccountID); return(View(tbl_Cities)); }
public bool Change_Status(tbl_Cities _city) { try { Thread t = new Thread(Start_Change_Status); t.Start(_city); } catch (Exception ex) { Logger.Log(ex.Message); return(false); } return(true); }
public ActionResult Register() { Store_DB db = new Store_DB(); List <tbl_Cities> cityList = (from data in db.tbl_Cities select data).ToList(); tbl_Cities objCities = new tbl_Cities(); objCities.City_Name = "Select City"; objCities.City_ID = 0; cityList.Insert(0, objCities); SelectList objCityModel = new SelectList(cityList, "City_ID", "City_Name", 0); AccountsModel objModelForCity = new AccountsModel(); objModelForCity.AccountCityList = objCityModel; return(View(objModelForCity)); }
///<summary> ///Function - timer for update Client status ///</summary> ///<param name="_model">Object as tbl_Cities</param> private static void Start_Change_Status(Object _model = null) { tbl_Cities _city = _model as tbl_Cities; String newStatus = ""; System.Timers.Timer aTimer = new System.Timers.Timer(); aTimer.Elapsed += new ElapsedEventHandler(delegate { try { String temperature = Contract.Get_Date(_city.Site_Name); Int32 Int_Temp = Int32.Parse(temperature); newStatus = String.Format("At {0} the temperature in my city({2}) is {1} °С", DateTime.Now, temperature, _city.Name); #region Worrisome if (Int_Temp < 20) { Send_Temp_Cold_Warning(); } else if (Int_Temp > 25) { Send_Temp_Hot_Warning(); } #endregion #region Change & Log Status if (sAPI.API.Status.Set(newStatus)) { Logger.Log(String.Format("Status Updated!")); } #endregion } catch (Exception ex) { Logger.Log(ex.Message); } }); aTimer.Interval = 10000; aTimer.Enabled = true; }
public ActionResult Register(AccountsModel user, int Cityid) { using (Store_DB db = new Store_DB()) { List <tbl_Cities> cityList = (from data in db.tbl_Cities select data).ToList(); tbl_Cities objCities = new tbl_Cities(); objCities.City_Name = "Select City"; objCities.City_ID = 0; cityList.Insert(0, objCities); SelectList objCityModel = new SelectList(cityList, "City_ID", "City_Name", 0); AccountsModel objModelForCity = new AccountsModel(); objModelForCity.AccountCityList = objCityModel; var accountCitySelected = ViewBag.City_Name = cityList.Where(c => c.City_ID == Cityid).FirstOrDefault().City_Name; if (ModelState.IsValid) { var createAccount = new tbl_Accounts() { Account_FirstName = user.AccountFirstName, Account_LastName = user.AccountLastName, Account_BirthDate = user.AccountBirthDate, Account_City = accountCitySelected, Account_EmailAddress = user.AccountEmailAddress, Account_UserName = user.AccountUserName, Account_Password = user.AccountPassword, Account_Mobile = user.AccountMobile, Account_Phone = user.AccountPhone, Account_CreatedDate = user.AccountCreateDate }; db.tbl_Accounts.Add(createAccount); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } return(View(objModelForCity)); } }
public CityModel SaveCity(CityModel _objdata) { tbl_Cities _objCity = new tbl_Cities(); try { using (newconecommerce dataContext = new newconecommerce()) { dataContext.Database.Connection.Open(); _objCity.v_City = _objdata.strCityName; _objCity.int_State_Id = _objdata.intStateId; _objCity.b_flag = true; dataContext.tbl_Cities.Add(_objCity); dataContext.SaveChanges(); dataContext.Database.Connection.Close(); _objdata.StatusMessaage = "City save sucessfully."; return(_objdata); } } catch (Exception) { throw; } }