// GET: Voters/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var voter = db.Voters.Find(id);
if (voter == null)
{
return(HttpNotFound());
}
var city = db.Cities.Where(c => c.Name.Contains(voter.CityId)).FirstOrDefault();
var comune = db.Communes.Where(c => c.Name.Contains(voter.CommuneId)).FirstOrDefault();
var country = db.Countries.Where(c => c.Name.Contains(voter.CountryId)).FirstOrDefault();
var department = db.Departments.Where(c => c.Name.Contains(voter.DepartmentId)).FirstOrDefault();
var votingplace = db.VotingPlaces.Where(c => c.Name.Contains(voter.VotingPlaceId)).FirstOrDefault();
ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name", city.CityId);
ViewBag.CommuneId = new SelectList(CombosHelper.GetCommunes(), "CommuneId", "Name", comune.CommuneId);
ViewBag.CountryId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name", country.CountryId);
ViewBag.DepartmentId = new SelectList(CombosHelper.GetDepartments(), "DepartmentId", "Name", department.DepartmentId);
ViewBag.VotingPlaceId = new SelectList(CombosHelper.GetVotingPlaces(), "VotingPlaceId", "Name", votingplace.VotingPlaceId);
ViewBag.PerfilId = new SelectList(CombosHelper.GetUser(), "userId", "name", voter.PerfilId);
ViewBag.ReferId = new SelectList(CombosHelper.GetRefer(), "ReferId", "FullName", voter.ReferId);
return(View(voter));
}
// GET: Emails/Create
public ActionResult Create()
{
ViewBag.userId = new SelectList(
CombosHelper.GetUserNoVoters(),
"userId",
"name");
ViewBag.ReferId = new SelectList(
CombosHelper.GetStandaloneRefer(),
"ReferId",
"FullName");
ViewBag.FilterId = new SelectList(
CombosHelper.GetVoterFilters(),
"FiltersId",
"name");
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name");
ViewBag.Comuna = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name");
return(View());
}
// GET: Voters/Create
public ActionResult Create()
{
var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
if (user == null)
{
return(RedirectToAction("Index", "Home"));
}
ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name");
ViewBag.CommuneId = new SelectList(CombosHelper.GetCommunes(), "CommuneId", "Name");
ViewBag.CountryId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name");
ViewBag.DepartmentId = new SelectList(CombosHelper.GetDepartments(), "DepartmentId", "Name");
ViewBag.VotingPlaceId = new SelectList(CombosHelper.GetVotingPlaces(), "VotingPlaceId", "Name");
ViewBag.PerfilId = new SelectList(
CombosHelper.GetUser(),
"userId",
"name");
ViewBag.ReferId = new SelectList(
CombosHelper.GetRefer(),
"ReferId",
"FullName");
var voter = new Voter
{
CompanyId = user.CompanyId,
DateBorn = DateTime.Now,
};
return(View(voter));
}
// GET: Bosses/Create
public ActionResult Create()
{
var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
if (user == null)
{
return(RedirectToAction("Index", "Home"));
}
ViewBag.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name");
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name");
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name");
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name");
ViewBag.BossId = new SelectList(
CombosHelper.GetBosses(user.CompanyId),
"BossId",
"FullName");
ViewBag.CommuneId = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name");
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name");
var link = new Link
{
CompanyId = user.CompanyId,
Date = DateTime.Now,
DateBorn = DateTime.Now,
};
return(View(link));
}
// GET: Bosses/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var boss = db.Bosses.Find(id);
if (boss == null)
{
return(HttpNotFound());
}
ViewBag.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name",
boss.CountryId);
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name",
boss.CityId);
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name",
boss.CompanyId);
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name",
boss.DepartmentId);
ViewBag.CommuneId = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name",
boss.CommuneId);
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name",
boss.WorkPlaceId);
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name",
boss.VotingPlaceId);
return(View(boss));
}
public ActionResult DeleteConfirmed(int id)
{
var voter = db.Voters.Find(id);
db.Voters.Remove(voter);
try
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("REFERENCE"))
{
ModelState.AddModelError(string.Empty, "El registro no se puede borrar porque tiene registros relacionados");
}
else
{
ModelState.AddModelError(string.Empty, ex.ToString());
}
}
ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name", voter.CityId);
ViewBag.CommuneId = new SelectList(CombosHelper.GetCommunes(), "CommuneId", "Name", voter.CommuneId);
ViewBag.CountryId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name", voter.CountryId);
ViewBag.DepartmentId = new SelectList(CombosHelper.GetDepartments(), "DepartmentId", "Name", voter.DepartmentId);
ViewBag.VotingPlaceId = new SelectList(CombosHelper.GetVotingPlaces(), "VotingPlaceId", "Name", voter.VotingPlaceId);
ViewBag.PerfilId = new SelectList(
CombosHelper.GetUser(),
"userId",
"name",
voter.PerfilId);
ViewBag.ReferId = new SelectList(
CombosHelper.GetRefer(),
"ReferId",
"FullName",
voter.ReferId);
return(View(voter));
}
public ActionResult DeleteConfirmed(int id)
{
var link = db.Links.Find(id);
using (var transaction = db.Database.BeginTransaction())
{
try
{
var response = FilesHelper.DeleteDocument(link.Photo);
var Voter = db.Voters.Where(V => V.Document == link.Document).FirstOrDefault();
if (Voter != null)
{
db.Voters.Remove(Voter);
}
var Refer = db.Refers.Where(r => r.ReferType == 2 && r.UserId == link.LinkId).FirstOrDefault();
if (Refer != null)
{
var coordinators = db.Coordinators.Where(c => c.ReferId == Refer.ReferId).ToList();
foreach (var coor in coordinators)
{
db.Coordinators.Remove(coor);
}
var leaders = db.Leaders.Where(l => l.ReferId == Refer.ReferId).ToList();
foreach (var leader in leaders)
{
db.Leaders.Remove(leader);
}
var voters = db.Voters.Where(v => v.ReferId == Refer.ReferId).ToList();
foreach (var voter in voters)
{
db.Voters.Remove(voter);
}
db.Refers.Remove(Refer);
db.SaveChanges();
}
//Elimino todo Coordinador y Lider Asociado a este enlace
//Borro cualquier anotacion que tenga en la agenda
var dates = db.Dates.Where(d => d.ProfessionalId == link.Document).ToList();
foreach (var item in dates)
{
db.Dates.Remove(item);
}
var dateItems = db.TimesDates.Where(di => di.ProfessionalId == link.Document).ToList();
foreach (var it in dateItems)
{
db.TimesDates.Remove(it);
}
var HV = db.HojaVidas.Where(h => h.RolId == 2 && h.UserId == link.LinkId).FirstOrDefault();
if (HV != null)
{
db.HojaVidas.Remove(HV);
}
db.Links.Remove(link);
db.SaveChanges();
transaction.Commit();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
transaction.Rollback();
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("REFERENCE"))
{
ModelState.AddModelError(string.Empty, "El registro no se puede borrar porque tiene registros relacionados");
}
else
{
ModelState.AddModelError(string.Empty, ex.ToString());
}
}
}
ViewBag.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name",
link.CountryId);
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name",
link.CityId);
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name",
link.CompanyId);
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name",
link.DepartmentId);
ViewBag.BossId = new SelectList(
CombosHelper.GetBosses(link.CompanyId),
"BossId",
"FullName",
link.BossId);
ViewBag.CommuneId = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name",
link.CommuneId);
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name",
link.WorkPlaceId);
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name",
link.VotingPlaceId);
return(View(link));
}
public ActionResult Edit(Link link, string newWorkPlace)
{
if (ModelState.IsValid)
{
if (link.WorkPlaceId == 9999)
{
if (!string.IsNullOrEmpty(newWorkPlace))
{
var workPlace = new WorkPlace
{
Name = newWorkPlace,
};
db.WorkPlaces.Add(workPlace);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("_Index"))
{
ModelState.AddModelError(string.Empty, "Ya existe un lugar de trabajo con ese nombre");
}
else
{
ModelState.AddModelError(string.Empty, ex.ToString());
}
ViewBag.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name",
link.CountryId);
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name",
link.CityId);
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name",
link.CompanyId);
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name",
link.DepartmentId);
ViewBag.CommuneId = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name",
link.CommuneId);
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name",
link.WorkPlaceId);
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name",
link.VotingPlaceId);
return(View(link));
}
db.SaveChanges();
link.WorkPlaceId = workPlace.WorkPlaceId;
}
}
if (link.PhotoFile != null)
{
var folder = "~/Content/Links";
var file = string.Format("{0}.jpg", link.LinkId);
var response = FilesHelper.UploadPhoto(link.PhotoFile, folder, file);
if (response)
{
var pic = string.Format("{0}/{1}", folder, file);
link.Photo = pic;
db.Entry(link).State = EntityState.Modified;
db.SaveChanges();
}
}
db.Entry(link).State = EntityState.Modified;
try
{
db.SaveChanges();
var referr = db.Refers.Where(r => r.ReferType == 1 && r.UserId == link.BossId).FirstOrDefault();
var voter = db.Voters.Where(v => v.Document == link.Document && v.UserName == link.UserName).FirstOrDefault();
var country = db.Countries.Find(link.CountryId);
var department = db.Departments.Find(link.DepartmentId);
var city = db.Cities.Find(link.CityId);
var commune = db.Communes.Find(link.CommuneId);
var voting = db.VotingPlaces.Find(link.VotingPlaceId);
voter.Address = link.Address;
voter.BossId = link.BossId;
voter.CityId = city.Name;
voter.CommuneId = commune.Name;
voter.CompanyId = link.CompanyId;
voter.CountryId = country.Name;
voter.DepartmentId = department.Name;
voter.Document = link.Document;
voter.FirstName = link.FirstName;
voter.LastName = link.LastName;
voter.Phone = link.Phone;
voter.UserName = link.UserName;
voter.VotingPlaceId = voting.Name;
voter.userId = 2;
voter.ReferId = referr.ReferId;
voter.PerfilId = 1;
voter.Fname = string.Format("{0} {1}", link.FirstName, link.LastName);
voter.Barrio = link.Barrio;
voter.Profesion = link.Profesion;
voter.DateBorn = link.DateBorn;
db.Entry(voter).State = EntityState.Modified;
var refer = db.Refers.Where(r => r.ReferType == 2 && r.UserId == link.LinkId).FirstOrDefault();
refer.FullName = link.FullName;
db.Entry(refer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("_Index"))
{
ModelState.AddModelError(string.Empty, "Ya existe un Registro con esa descripción");
}
else
{
ModelState.AddModelError(string.Empty, ex.ToString());
}
}
}
ViewBag.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name",
link.CountryId);
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name",
link.CityId);
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name",
link.CompanyId);
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name",
link.DepartmentId);
ViewBag.BossId = new SelectList(
CombosHelper.GetBosses(link.CompanyId),
"BossId",
"FullName",
link.BossId);
ViewBag.CommuneId = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name",
link.CommuneId);
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name",
link.WorkPlaceId);
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name",
link.VotingPlaceId);
return(View(link));
}
public ActionResult Index(string Document, string CustomerId, int?FilterId, int?Comuna, int?VotingPlaceId, int?WorkPlaceId, int?page = null)
{
ViewBag.uno = FilterId;
ViewBag.dos = Comuna;
ViewBag.tres = VotingPlaceId;
ViewBag.cuatro = WorkPlaceId;
page = (page ?? 1);
var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
if (user == null)
{
return(RedirectToAction("Index", "Home"));
}
if (!string.IsNullOrEmpty(Document))
{
if (Utilidades.isNumeric(Document))
{
ViewBag.FilterId = new SelectList(
CombosHelper.GetFilters(),
"FiltersId",
"name");
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name");
ViewBag.Comuna = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name");
double doc = Convert.ToDouble(Document);
var link = db.Links.Where(v => v.Document == doc);
return(View(link.OrderBy(b => b.CompanyId).ThenBy(b => b.FirstName).ToPagedList((int)page, 5)));
}
}
if (!string.IsNullOrEmpty(CustomerId))
{
if (Utilidades.isNumeric(CustomerId))
{
ViewBag.FilterId = new SelectList(
CombosHelper.GetFilters(),
"FiltersId",
"name");
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name");
ViewBag.Comuna = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name");
int doc = Convert.ToInt32(CustomerId);
var link = db.Links.Where(b => b.LinkId == doc);
return(View(link.OrderBy(b => b.CompanyId).ThenBy(b => b.FirstName).ToPagedList((int)page, 5)));
}
}
if (FilterId > 0)
{
if (FilterId == 1)//GENERAL
{
ViewBag.FilterId = new SelectList(
CombosHelper.GetFilters(),
"FiltersId",
"name",
FilterId);
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name");
ViewBag.Comuna = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name");
var linkGeneral = db.Links.Where(b => b.CompanyId == user.CompanyId);
return(View(linkGeneral.OrderBy(b => b.CompanyId).ThenBy(b => b.FirstName).ToPagedList((int)page, 5)));
}
if (FilterId == 2)//COMUNA
{
if (Comuna > 0)
{
ViewBag.FilterId = new SelectList(
CombosHelper.GetFilters(),
"FiltersId",
"name",
FilterId);
ViewBag.Comuna = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name",
Comuna);
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name");
var linkComuna = db.Links.Where(b => b.CompanyId == user.CompanyId && b.CommuneId == Comuna);
return(View(linkComuna.OrderBy(b => b.CompanyId).ThenBy(b => b.FirstName).ToPagedList((int)page, 10)));
}
}
if (FilterId == 3)//LUGAR DE VOTACION
{
if (VotingPlaceId > 0)
{
ViewBag.FilterId = new SelectList(
CombosHelper.GetFilters(),
"FiltersId",
"name",
FilterId);
ViewBag.Comuna = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name");
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name",
VotingPlaceId);
var linkVotacion = db.Links.Where(b => b.CompanyId == user.CompanyId && b.VotingPlaceId == VotingPlaceId);
return(View(linkVotacion.OrderBy(b => b.CompanyId).ThenBy(b => b.FirstName).ToPagedList((int)page, 10)));
}
}
if (FilterId == 4)
{
if (WorkPlaceId > 0)
{
ViewBag.FilterId = new SelectList(
CombosHelper.GetFilters(),
"FiltersId",
"name",
FilterId);
ViewBag.Comuna = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name");
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name",
WorkPlaceId);
var linkWork = db.Links.Where(b => b.CompanyId == user.CompanyId && b.WorkPlaceId == WorkPlaceId);
return(View(linkWork.OrderBy(b => b.CompanyId).ThenBy(b => b.FirstName).ToPagedList((int)page, 10)));
}
}
}
ViewBag.FilterId = new SelectList(
CombosHelper.GetFilters(),
"FiltersId",
"name");
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name");
ViewBag.Comuna = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name");
var links = db.Links.Where(b => b.CompanyId == user.CompanyId);
return(View(links.OrderBy(b => b.CompanyId).ThenBy(b => b.FirstName).ToPagedList((int)page, 10)));
}
public ActionResult Edit(Voter voter)
{
if (ModelState.IsValid)
{
var refer = db.Refers.Find(voter.ReferId);
var city = db.Cities.Find(Convert.ToInt32(voter.CityId));
var department = db.Departments.Find(Convert.ToInt32(voter.DepartmentId));
var country = db.Countries.Find(Convert.ToInt32(voter.CountryId));
var comune = db.Communes.Find(Convert.ToInt32(voter.CommuneId));
var votingPlace = db.VotingPlaces.Find(Convert.ToInt32(voter.VotingPlaceId));
if (voter.PerfilId == 1)
{
voter.BossId = refer.UserId;
}
if (voter.PerfilId == 2)
{
voter.LinkId = refer.UserId;
}
if (voter.PerfilId == 3)
{
voter.CoordinatorId = refer.UserId;
}
if (voter.PerfilId == 4)
{
voter.LeaderId = refer.UserId;
}
voter.ReferId = refer.ReferId;
voter.Fname = string.Format("{0} {1}", voter.FirstName, voter.LastName);
voter.CityId = city.Name;
voter.DepartmentId = department.Name;
voter.CountryId = country.Name;
voter.CommuneId = comune.Name;
voter.VotingPlaceId = votingPlace.Name;
db.Entry(voter).State = EntityState.Modified;
try
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("_Index"))
{
ModelState.AddModelError(string.Empty, "Ya existe un Registro con esa descripción");
}
else
{
ModelState.AddModelError(string.Empty, ex.ToString());
}
}
}
ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name", voter.CityId);
ViewBag.CommuneId = new SelectList(CombosHelper.GetCommunes(), "CommuneId", "Name", voter.CommuneId);
ViewBag.CountryId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name", voter.CountryId);
ViewBag.DepartmentId = new SelectList(CombosHelper.GetDepartments(), "DepartmentId", "Name", voter.DepartmentId);
ViewBag.VotingPlaceId = new SelectList(CombosHelper.GetVotingPlaces(), "VotingPlaceId", "Name", voter.VotingPlaceId);
ViewBag.PerfilId = new SelectList(
CombosHelper.GetUser(),
"userId",
"name",
voter.PerfilId);
ViewBag.ReferId = new SelectList(
CombosHelper.GetRefer(),
"ReferId",
"FullName",
voter.ReferId);
return(View(voter));
}
// GET: Leaders/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var leader = db.Leaders.Find(id);
if (leader == null)
{
return(HttpNotFound());
}
ViewBag.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name",
leader.CountryId);
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name",
leader.CityId);
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name",
leader.CompanyId);
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name",
leader.DepartmentId);
ViewBag.CommuneId = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name",
leader.CommuneId);
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name",
leader.VotingPlaceId);
ViewBag.userId = new SelectList(
CombosHelper.GetTypeUserCoordinator(),
"userId",
"name",
leader.userId);
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name",
leader.WorkPlaceId);
ViewBag.ReferId = new SelectList(
CombosHelper.GetRefer(),
"ReferId",
"FullName",
leader.ReferId);
return(View(leader));
}
public ActionResult Create(Leader leader, string newWorkPlace)
{
if (ModelState.IsValid)
{
if (leader.WorkPlaceId == 9999)
{
if (!string.IsNullOrEmpty(newWorkPlace))
{
var workPlace = new WorkPlace
{
Name = newWorkPlace,
};
db.WorkPlaces.Add(workPlace);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("_Index"))
{
ModelState.AddModelError(string.Empty, "Ya existe un lugar de trabajo con ese nombre");
}
else
{
ModelState.AddModelError(string.Empty, ex.ToString());
}
ViewBag.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name",
leader.CountryId);
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name",
leader.CityId);
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name",
leader.CompanyId);
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name",
leader.DepartmentId);
ViewBag.CommuneId = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name",
leader.CommuneId);
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name",
leader.WorkPlaceId);
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name",
leader.VotingPlaceId);
return(View(leader));
}
db.SaveChanges();
leader.WorkPlaceId = workPlace.WorkPlaceId;
}
}
var refer = db.Refers.Find(leader.ReferId);
if (leader.userId == 1)
{
leader.BossId = refer.UserId;
}
if (leader.userId == 2)
{
leader.LinkId = refer.UserId;
}
if (leader.userId == 3)
{
leader.CoordinatorId = refer.UserId;
}
db.Leaders.Add(leader);
try
{
db.SaveChanges();
//UsersHelper.CreateUserASP(leader.UserName, "Leader");
if (leader.PhotoFile != null)
{
var folder = "~/Content/Leader";
var file = string.Format("{0}.jpg", leader.LeaderId);
var response = FilesHelper.UploadPhoto(leader.PhotoFile, folder, file);
if (response)
{
var pic = string.Format("{0}/{1}", folder, file);
leader.Photo = pic;
db.Entry(leader).State = EntityState.Modified;
db.SaveChanges();
}
}
var Refer = new Refer
{
ReferType = 4,
UserId = leader.LeaderId,
FullName = leader.FullName,
Active = 1
};
db.Refers.Add(Refer);
db.SaveChanges();
var city = db.Cities.Find(leader.CityId);
var department = db.Departments.Find(leader.DepartmentId);
var country = db.Countries.Find(leader.CountryId);
var comune = db.Communes.Find(leader.CommuneId);
var votingPlace = db.VotingPlaces.Find(leader.VotingPlaceId);
var Voter = new Voter
{
Address = leader.Address,
BossId = leader.BossId,
LinkId = leader.LinkId,
CoordinatorId = leader.CoordinatorId,
CityId = city.Name,
CommuneId = comune.Name,
CompanyId = leader.CompanyId,
CountryId = leader.Country.Name,
DepartmentId = department.Name,
Document = leader.Document,
FirstName = leader.FirstName,
LastName = leader.LastName,
Phone = leader.Phone,
UserName = leader.UserName,
VotingPlaceId = votingPlace.Name,
userId = 4,
ReferId = refer.ReferId,
PerfilId = leader.userId,
Fname = string.Format("{0} {1}", leader.FirstName, leader.LastName),
Barrio = leader.Barrio,
Profesion = leader.Profesion,
DateBorn = leader.DateBorn,
};
db.Voters.Add(Voter);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("_Index"))
{
ModelState.AddModelError(string.Empty, "Ya existe un Registro con esa descripción");
}
else
{
ModelState.AddModelError(string.Empty, ex.ToString());
}
}
}
ViewBag.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name",
leader.CountryId);
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name",
leader.CityId);
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name",
leader.CompanyId);
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name",
leader.DepartmentId);
ViewBag.CommuneId = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name",
leader.CommuneId);
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name",
leader.VotingPlaceId);
ViewBag.userId = new SelectList(
CombosHelper.GetTypeUserCoordinator(),
"userId",
"name",
leader.userId);
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name",
leader.WorkPlaceId);
ViewBag.ReferId = new SelectList(
CombosHelper.GetRefer(),
"ReferId",
"FullName",
leader.ReferId);
return(View(leader));
}
// GET: Leaders/Create
public ActionResult Create()
{
var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
if (user == null)
{
return(RedirectToAction("Index", "Home"));
}
ViewBag.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name");
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name");
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name");
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name");
ViewBag.CommuneId = new SelectList(
CombosHelper.GetCommunes(),
"CommuneId",
"Name");
ViewBag.AssociationId = new SelectList(
CombosHelper.GetAssociations(),
"AssociationId",
"Name");
ViewBag.WorkPlaceId = new SelectList(
CombosHelper.GetWorkPlaces(),
"WorkPlaceId",
"Name");
ViewBag.VotingPlaceId = new SelectList(
CombosHelper.GetVotingPlaces(),
"VotingPlaceId",
"Name");
ViewBag.userId = new SelectList(
CombosHelper.GetTypeUserCoordinator(),
"userId",
"name");
ViewBag.ReferId = new SelectList(
CombosHelper.GetRefer(),
"ReferId",
"FullName");
var leader = new Leader
{
CompanyId = user.CompanyId,
Date = DateTime.Now,
DateBorn = DateTime.Now,
};
return(View(leader));
}