private void PopulateRegionsTextsData(tblRegion tblRegion) { var allRegionsText = from rt in db.RegionsTexts where (rt.RegionId == tblRegion.RegionId) select new vmRegionsText { RegionsTextId = rt.Id, Region = rt.tblRegion.Name, Language = rt.Language1.Label, Name = rt.Name }; var viewModel = new List <vmRegionsText>(); foreach (var text in allRegionsText) { viewModel.Add(new vmRegionsText { RegionsTextId = text.RegionsTextId, Region = text.Region, Language = text.Language, Name = text.Name }); } ViewBag.RegionsText = viewModel; }
public string ChangeStatus(long id) { tblRegion user = _dbRepository.SelectById(id); user.IsActive = !user.IsActive; return(_dbRepository.Update(user)); }
public async Task <ActionResult> DeleteConfirmed(int id) { tblRegion tblRegion = await db.tblRegions.FindAsync(id); db.tblRegions.Remove(tblRegion); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "RegionId,Name,Priority,Active")] tblRegion tblRegion) { if (ModelState.IsValid) { db.Entry(tblRegion).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(tblRegion)); }
public async Task <ActionResult> Create([Bind(Include = "RegionId,Name,Priority,Active")] tblRegion tblRegion) { if (ModelState.IsValid) { db.tblRegions.Add(tblRegion); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(tblRegion)); }
// GET: Regions/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblRegion tblRegion = await db.tblRegions.FindAsync(id); if (tblRegion == null) { return(HttpNotFound()); } return(View(tblRegion)); }
// GET: Regions/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblRegion tblRegion = await db.tblRegions.FindAsync(id); if (tblRegion == null) { return(HttpNotFound()); } PopulateRegionsTextsData(tblRegion); return(View(tblRegion)); }
public bool Delete(int RegionID) { try { // CondominiumManagementSystemDBEntities entity = new CondominiumManagementSystemDBEntities(); tblRegion oldRegion = entity.tblRegions.Where(x => x.ID == RegionID).FirstOrDefault(); entity.tblRegions.Remove(oldRegion); entity.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public ActionResult KendoSave([DataSourceRequest] DataSourceRequest request, tblRegion model) { if (model == null || !ModelState.IsValid) { return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); } string message = string.Empty; message = model.Id > 0 ? _dbRepository.Update(model) : _dbRepository.Insert(model); ModelState.Clear(); if (!string.IsNullOrEmpty(message)) { ModelState.AddModelError("CountryName", message); } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }
public bool Save(RegionEntity regionEntity) { try { // tblRegion region = new tblRegion(); region.ID = regionEntity.ID; region.TItle = regionEntity.TItle; CondominiumManagementSystemDBEntities entity = new CondominiumManagementSystemDBEntities(); entity.tblRegions.Add(region); entity.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool Update(RegionEntity regionEntity) { try { // tblRegion newRegion = new tblRegion(); newRegion.ID = regionEntity.ID; newRegion.TItle = regionEntity.TItle; CondominiumManagementSystemDBEntities entity = new CondominiumManagementSystemDBEntities(); tblRegion oldRegion = entity.tblRegions.Where(x => x.ID == regionEntity.ID).FirstOrDefault(); entity.Entry(oldRegion).CurrentValues.SetValues(newRegion); entity.SaveChanges(); return(true); } catch (Exception) { return(false); } }
void cmbCountry_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e) { try { cmbRegion.Items.Clear(); cmbRegion.Items.Add(new RadComboBoxItem("[Select Region]", "-1")); cmbRegion.AppendDataBoundItems = true; cmbRegion.DataSource = GoProGo.Business.Lookup.Geo.GetRegionsByCountryID(int.Parse(cmbCountry.SelectedItem.Value)); cmbRegion.DataTextField = "Region"; cmbRegion.DataValueField = "ID"; cmbRegion.DataBind(); cmbCity.Items.Clear(); if (!IsPostBack) { tblRegion region = GoProGoDC.GeoDC.GetRegionByCountryAndRegion(int.Parse(cmbCountry.SelectedItem.Value), UserBrowsingInfo.RegionName.ToLower()).SingleOrDefault <tblRegion>(); //GoProGo.Business.Lookup.Geo.GetRegionsByCountryID(int.Parse(cmbCountry.SelectedItem.Value)).Where(a => a.Region.ToLower().Equals(UserBrowsingInfo.RegionName.ToLower())).SingleOrDefault<tblRegion>(); if (region != null) { cmbRegion.SelectedValue = region.ID.ToString(); } else { cmbRegion.SelectedIndex = 0; } //TODO: Log this situation //throw new Exception("Region can not be null."); } cmbRegion_SelectedIndexChanged(null, null); } catch (Exception ex) { ThrowError(this, new ControlErrorArgs() { InnerException = ex, Message = ex.Message, Severity = 3 }); } }
public ActionResult KendoDestroy([DataSourceRequest] DataSourceRequest request, tblRegion model) { string deleteMessage = _dbRepository.Delete(model.Id); ModelState.Clear(); if (!string.IsNullOrEmpty(deleteMessage)) { ModelState.AddModelError(deleteMessage, deleteMessage); } return(Json(new[] { model }.ToDataSourceResult(request, ModelState))); }