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