public ActionResult DeleteConfirmed(string id) { t_merit t_merit = db.t_merit.Find(id); db.t_merit.Remove(t_merit); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "supervisor,axo,nombre,depto,budget_imp,budget_porc,budget_spen,estatus,notas,u_id,f_id,autoriza,ind_autoriza,f_autoriza,n_autoriza")] t_merit t_merit) { if (ModelState.IsValid) { db.Entry(t_merit).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.autoriza = new SelectList(db.t_empleados, "empleado", "nombre", t_merit.autoriza); ViewBag.supervisor = new SelectList(db.t_empleados, "empleado", "nombre", t_merit.supervisor); return(View(t_merit)); }
// GET: t_merit/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } t_merit t_merit = db.t_merit.Find(id); if (t_merit == null) { return(HttpNotFound()); } return(View(t_merit)); }
// GET: t_merit/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } t_merit t_merit = db.t_merit.Find(id); if (t_merit == null) { return(HttpNotFound()); } ViewBag.autoriza = new SelectList(db.t_empleados, "empleado", "nombre", t_merit.autoriza); ViewBag.supervisor = new SelectList(db.t_empleados, "empleado", "nombre", t_merit.supervisor); return(View(t_merit)); }
public ActionResult AddComments(string supervisor, decimal axo, string comments) { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } t_merit t_merit = db.t_merit.Find(supervisor, axo); t_merit.n_autoriza = comments; t_merit.f_autoriza = System.DateTime.Now; db.Entry(t_merit).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("IndexModule4", "t_merit", new { empleado = t_merit.supervisor })); }
public ActionResult CreateAll(decimal sparamx) { //list of employees / local & tress store procedure query var budgetAxo = db.t_budget_pta.Where(x => x.axo == sparamx).ToList(); decimal dBudget = 0; if (budgetAxo.Any()) { if (!decimal.TryParse(budgetAxo[0].budget.ToString(), out dBudget)) { return(HttpNotFound()); } } var spPlanners = db.sp_view_merit_planners().ToList(); if (spPlanners.ToList().Count() > 0) { for (int x = 0; x < spPlanners.ToList().Count(); x++) { var sSuper = spPlanners[x].empleado.ToString(); var sName = spPlanners[x].nombre.ToString(); var sDepto = spPlanners[x].TB_ELEMENT.ToString(); var sManager = string.Empty; if (spPlanners[x].gerente != null) { sManager = spPlanners[x].gerente.ToString(); } else { sManager = null; } decimal dSalary = 0; decimal dSalaryBudget = 0; if (!decimal.TryParse(spPlanners[x].salary.ToString(), out dSalary)) { dSalary = 0; } if (dSalary > 0) { dSalaryBudget = dSalary * (dBudget / 100); } else { continue; } var spDirect = db.sp_view_merit_dreport(sSuper).ToList(); if (spPlanners.ToList().Count() > 0) { //saver t_merit t_merit dbMerit = new t_merit(); dbMerit.supervisor = sSuper; dbMerit.axo = sparamx; dbMerit.nombre = sName; dbMerit.depto = sDepto; dbMerit.budget_imp = dSalaryBudget; dbMerit.budget_porc = dBudget; dbMerit.budget_spen = 0; dbMerit.autoriza = sManager; dbMerit.estatus = "PE"; dbMerit.u_id = Convert.ToString(Session["userAccount"]); dbMerit.f_id = System.DateTime.Now; db.Entry(dbMerit).State = EntityState.Added; if (db.SaveChanges() > 0) { //save t_meridet for (int i = 0; i < spDirect.ToList().Count(); i++) { t_meridet dbMeridet = new t_meridet(); dbMeridet.supervisor = sSuper; dbMeridet.axo = sparamx; dbMeridet.empleado = spDirect[i].empleado.ToString(); dbMeridet.nombre = spDirect[i].nombre.ToString(); dbMeridet.jobcode = spDirect[i].jobcode.ToString(); decimal dMRP = 0; if (!decimal.TryParse(spDirect[i].mrp.ToString(), out dMRP)) { dMRP = 0; } dbMeridet.market_mcr = dMRP; dbMeridet.puesto = spDirect[i].PU_DESCRIP.ToString(); dbMeridet.calificacion = spDirect[i].califica.ToString(); decimal dSalaryD = 0; if (!decimal.TryParse(spDirect[i].salary.ToString(), out dSalaryD)) { dSalaryD = 0; } dbMeridet.salario_axo = dSalaryD; dbMeridet.budget_porc = dBudget; dbMeridet.estatus = "PE"; dbMeridet.sugerido_imp = 0; dbMeridet.sugerido_porc = 0; dbMeridet.lump_imp = 0; dbMeridet.lump_porc = 0; dbMeridet.market_mcr = 0;//get mrc from job dbMeridet.out_guide = "0"; dbMeridet.salario_nuevo = 0; DateTime dtSalario = DateTime.Parse(spDirect[i].CB_FEC_ANT.ToString()); DateTime dtIngreso = DateTime.Parse(spDirect[i].CB_FEC_ING.ToString()); if (Elegible(dtSalario, dtSalario)) { dbMeridet.ind_elegible = "1"; } else { dbMeridet.ind_elegible = "0"; } dbMeridet.u_id = Convert.ToString(Session["userAccount"]); dbMeridet.f_id = DateTime.Now; db.Entry(dbMeridet).State = EntityState.Added; db.SaveChanges(); } } } } } return(RedirectToAction("Start", "t_merit", new { sparame = Session["userNo"], sparamx = sparamx })); }