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