public ActionResult CargarHojaVida(int LinkId, HttpPostedFileBase File)
{
if (File != null)
{
var folder = "~/Content/HojasVida";
var file = string.Format("{0}_{1}_{2}", 1, LinkId, File.FileName);
var response = FilesHelper.UploadPhoto(File, folder, file);
if (response)
{
var pic = string.Format("{0}/{1}", folder, file);
//Elimino la actual HV
var hoja = db.HojaVidas.Where(h => h.RolId == 2 && h.UserId == LinkId).FirstOrDefault();
if (hoja != null)
{
var resp = FilesHelper.DeleteDocument(hoja.Path);
db.HojaVidas.Remove(hoja);
db.SaveChanges();
}
var HV = new HojaVida
{
RolId = 2,
UserId = LinkId,
Path = pic,
};
db.HojaVidas.Add(HV);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
var user = db.Users.Find(id);
db.Users.Remove(user);
try
{
var response = FilesHelper.DeleteDocument(user.Photo);
db.SaveChanges();
UsersHelper.DeleteUser(user.UserName);
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.CountryId = new SelectList(
CombosHelper.GetCountries(),
"CountryId",
"Name",
user.CountryId);
ViewBag.CityId = new SelectList(
CombosHelper.GetCities(),
"CityId",
"Name",
user.CityId);
ViewBag.CompanyId = new SelectList(
CombosHelper.GetCompanies(),
"CompanyId",
"Name",
user.CompanyId);
ViewBag.DepartmentId = new SelectList(
CombosHelper.GetDepartments(),
"DepartmentId",
"Name",
user.DepartmentId);
return(View(user));
}
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 CargarHojaVida(int VoterId, HttpPostedFileBase File)
{
int roluserId = 0;
if (File != null)
{
var folder = "~/Content/HojasVida";
var file = string.Format("{0}_{1}_{2}", 1, VoterId, File.FileName);
var response = FilesHelper.UploadPhoto(File, folder, file);
if (response)
{
var pic = string.Format("{0}/{1}", folder, file);
//Elimino la actual HV
var voter = db.Voters.Find(VoterId);
if (voter.userId == 1)
{
var boss = db.Bosses.Where(b => b.Document == voter.Document).FirstOrDefault();
if (boss != null)
{
var hoja = db.HojaVidas.Where(h => h.RolId == 1 && h.UserId == boss.BossId).FirstOrDefault();
if (hoja != null)
{
var resp = FilesHelper.DeleteDocument(hoja.Path);
db.HojaVidas.Remove(hoja);
db.SaveChanges();
}
roluserId = boss.BossId;
}
}
if (voter.userId == 2)
{
var link = db.Links.Where(b => b.Document == voter.Document).FirstOrDefault();
if (link != null)
{
var hoja = db.HojaVidas.Where(h => h.RolId == 2 && h.UserId == link.LinkId).FirstOrDefault();
if (hoja != null)
{
var resp = FilesHelper.DeleteDocument(hoja.Path);
db.HojaVidas.Remove(hoja);
db.SaveChanges();
}
roluserId = link.LinkId;
}
}
if (voter.userId == 3)
{
var coor = db.Coordinators.Where(b => b.Document == voter.Document).FirstOrDefault();
if (coor != null)
{
var hoja = db.HojaVidas.Where(h => h.RolId == 3 && h.UserId == coor.CoordinatorId).FirstOrDefault();
if (hoja != null)
{
var resp = FilesHelper.DeleteDocument(hoja.Path);
db.HojaVidas.Remove(hoja);
db.SaveChanges();
}
roluserId = coor.CoordinatorId;
}
}
if (voter.userId == 4)
{
var leader = db.Leaders.Where(b => b.Document == voter.Document).FirstOrDefault();
if (leader != null)
{
var hoja = db.HojaVidas.Where(h => h.RolId == 4 && h.UserId == leader.LeaderId).FirstOrDefault();
if (hoja != null)
{
var resp = FilesHelper.DeleteDocument(hoja.Path);
db.HojaVidas.Remove(hoja);
db.SaveChanges();
}
roluserId = leader.LeaderId;
}
}
if (voter.userId == 5)
{
var hoja = db.HojaVidas.Where(h => h.RolId == 5 && h.UserId == voter.VoterId).FirstOrDefault();
if (hoja != null)
{
var resp = FilesHelper.DeleteDocument(hoja.Path);
db.HojaVidas.Remove(hoja);
db.SaveChanges();
}
roluserId = voter.VoterId;
}
var HV = new HojaVida
{
RolId = voter.userId,
UserId = roluserId,
Path = pic,
};
db.HojaVidas.Add(HV);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
