public ActionResult Create2(string vko, string vtw, string kun, string spa, Contactoc conC) { using (TruequeEntities db = new TruequeEntities()) { if (conC.defecto) { var conAct = db.CONTACTOCs .Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.DEFECTO == true).ToList(); foreach (var item in conAct) { item.DEFECTO = false; } db.SaveChanges(); var con = db.CONTACTOCs .Add(new CONTACTOC { NOMBRE = conC.nombre, PHONE = conC.telefono, EMAIL = conC.correo, VKORG = vko, VTWEG = vtw, KUNNR = kun, SPART = spa, ACTIVO = true, DEFECTO = conC.defecto, CARTA = conC.carta }); db.SaveChanges(); } else { var con = db.CONTACTOCs .Add(new CONTACTOC { NOMBRE = conC.nombre, PHONE = conC.telefono, EMAIL = conC.correo, VKORG = vko, VTWEG = vtw, KUNNR = kun, SPART = spa, ACTIVO = true, DEFECTO = conC.defecto, CARTA = conC.carta }); db.SaveChanges(); } return(RedirectToAction("Index", new { vko = vko, vtw = vtw, kun = kun, spa = spa })); } }
public ActionResult Index(string vko, string vtw, string kun, string spa, string aa) { int pagina = 641; //ID EN BASE DE DATOS using (TruequeEntities db = new TruequeEntities()) { string u = User.Identity.Name; FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } var con = db.CONTACTOCs .Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.ACTIVO == true).ToList(); Contactoc conCli = new Contactoc { kunnr = kun, vkorg = vko, vtweg = vtw, spart = spa, tabContacto = con }; return(View(conCli)); } }
public ActionResult Create(string vko, string vtw, string kun, string spa) { int pagina = 643; //ID EN BASE DE DATOS using (TruequeEntities db = new TruequeEntities()) { string u = User.Identity.Name; FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } Contactoc conC = new Contactoc { vkorg = vko, vtweg = vtw, kunnr = kun, spart = spa }; CLIENTE cliente = db.CLIENTEs.Find(vko, vtw, spa, kun); ViewBag.Cliente = cliente.NAME1; ViewBag.NoCliente = cliente.KUNNR; return(View(conC)); } }
// GET: Contacto public ActionResult Index(string vko, string vtw, string kun, string spa) { int pagina = 641; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList(); ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList(); ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;; ViewBag.rol = user.MIEMBROS.FirstOrDefault().ROL.NOMBRE; ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50; ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; if (vko != null && vtw != null && kun != null && spa != null) { var con = db.CONTACTOCs .Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.ACTIVO == true).ToList(); Contactoc conCli = new Contactoc(); conCli.vkorg = vko; conCli.vtweg = vtw; conCli.kunnr = kun; conCli.spart = spa; conCli.tabContacto = con; return(View(conCli)); } else { var con = db.CONTACTOCs.Where(x => x.ACTIVO == true).ToList(); Contactoc conCli = new Contactoc(); conCli.vkorg = vko; conCli.vtweg = vtw; conCli.kunnr = kun; conCli.spart = spa; conCli.tabContacto = con; return(View(conCli)); } } }
// GET: Contacto public ActionResult Index(string vko, string vtw, string kun, string spa) { int pagina = 641; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } if (vko != null && vtw != null && kun != null && spa != null) { var con = db.CONTACTOCs .Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.ACTIVO == true).ToList(); CLIENTE cli = db.CLIENTEs.Find(vko, vtw, spa, kun); Contactoc conCli = new Contactoc { vkorg = vko, vtweg = vtw, kunnr = kun, spart = spa, tabContacto = con }; ViewBag.Cliente = cli.NAME1; ViewBag.NoCliente = cli.KUNNR; return(View(conCli)); } else { var con = db.CONTACTOCs.Where(x => x.ACTIVO == true).ToList(); Contactoc conCli = new Contactoc { vkorg = vko, vtweg = vtw, kunnr = kun, spart = spa, tabContacto = con }; return(View(conCli)); } } }
public ActionResult Edit(int id, Contactoc co) { using (TruequeEntities db = new TruequeEntities()) { try { var idCli = db.CONTACTOCs.Where(x => x.ID == id).First(); if (co.defecto) { var conAct = db.CONTACTOCs .Where(x => x.VKORG == idCli.VKORG && x.VTWEG == idCli.VTWEG && x.KUNNR == idCli.KUNNR && x.SPART == idCli.SPART && x.DEFECTO == true).ToList(); foreach (var item in conAct) { item.DEFECTO = false; } db.SaveChanges(); var con = db.CONTACTOCs.Where(x => x.ID == id).First(); con.NOMBRE = co.nombre; con.PHONE = co.telefono; con.EMAIL = co.correo; con.DEFECTO = co.defecto; con.CARTA = co.carta; db.SaveChanges(); } else { var con = db.CONTACTOCs.Where(x => x.ID == id).First(); con.NOMBRE = co.nombre; con.PHONE = co.telefono; con.EMAIL = co.correo; con.DEFECTO = co.defecto; db.SaveChanges(); } return(RedirectToAction("Index", new { vko = idCli.VKORG, vtw = idCli.VTWEG, kun = idCli.KUNNR, spa = idCli.SPART })); } catch { int pagina = 644; //ID EN BASE DE DATOS string u = User.Identity.Name; FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller); return(View(co)); } } }
public ActionResult Edit(int id, Contactoc co) { using (TAT001Entities db = new TAT001Entities()) { try { string u = User.Identity.Name; var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); var idCli = db.CONTACTOCs.Where(x => x.ID == id).First(); if (co.defecto == true) { var conAct = db.CONTACTOCs .Where(x => x.VKORG == idCli.VKORG && x.VTWEG == idCli.VTWEG && x.KUNNR == idCli.KUNNR && x.SPART == idCli.SPART && x.DEFECTO == true).ToList(); foreach (var item in conAct) { item.DEFECTO = false; } db.SaveChanges(); var con = db.CONTACTOCs.Where(x => x.ID == id).First(); con.NOMBRE = co.nombre; con.PHONE = co.telefono; con.EMAIL = co.correo; con.DEFECTO = co.defecto; db.SaveChanges(); } else { var con = db.CONTACTOCs.Where(x => x.ID == id).First(); con.NOMBRE = co.nombre; con.PHONE = co.telefono; con.EMAIL = co.correo; con.DEFECTO = co.defecto; db.SaveChanges(); } return(RedirectToAction("Index", new { vko = idCli.VKORG, vtw = idCli.VTWEG, kun = idCli.KUNNR, spa = idCli.SPART })); } catch { return(View("Edit")); } } }
// GET: Contacto/Edit/5 public ActionResult Edit(string vko, string vtw, string kun, string spa, int id) { int pagina = 642; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList(); ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList(); ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;; ViewBag.rol = user.MIEMBROS.FirstOrDefault().ROL.NOMBRE; ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50; ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; var con = db.CONTACTOCs .Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.ID == id) .First(); Contactoc co = new Contactoc(); co.vkorg = con.VKORG; co.vtweg = con.VTWEG; co.kunnr = con.KUNNR; co.spart = con.SPART; co.id = con.ID.ToString(); co.nombre = con.NOMBRE; co.telefono = con.PHONE; co.correo = con.EMAIL; co.defecto = Convert.ToBoolean(con.DEFECTO); return(View(co)); } }
// GET: Contacto/Edit/5 public ActionResult Edit(string vko, string vtw, string kun, string spa, int id) { int pagina = 644; //ID EN BASE DE DATOS using (TruequeEntities db = new TruequeEntities()) { string u = User.Identity.Name; FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } var con = db.CONTACTOCs .Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.ID == id) .First(); Contactoc co = new Contactoc { vkorg = con.VKORG, vtweg = con.VTWEG, kunnr = con.KUNNR, spart = con.SPART, id = con.ID.ToString(), nombre = con.NOMBRE, telefono = con.PHONE, correo = con.EMAIL, defecto = Convert.ToBoolean(con.DEFECTO), carta = Convert.ToBoolean(con.CARTA) }; CLIENTE cli = db.CLIENTEs.Find(vko, vtw, spa, kun); ViewBag.Cliente = cli.NAME1; ViewBag.NoCliente = cli.KUNNR; return(View(co)); } }
public ActionResult Create2(string vko, string vtw, string kun, string spa, Contactoc conC) { using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); if (conC.defecto == true) { var conAct = db.CONTACTOCs .Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.DEFECTO == true).ToList(); foreach (var item in conAct) { item.DEFECTO = false; } db.SaveChanges(); var con = db.CONTACTOCs .Add(new CONTACTOC { NOMBRE = conC.nombre, PHONE = conC.telefono, EMAIL = conC.correo, VKORG = vko, VTWEG = vtw, KUNNR = kun, SPART = spa, ACTIVO = true, DEFECTO = conC.defecto }); db.SaveChanges(); } else { var con = db.CONTACTOCs .Add(new CONTACTOC { NOMBRE = conC.nombre, PHONE = conC.telefono, EMAIL = conC.correo, VKORG = vko, VTWEG = vtw, KUNNR = kun, SPART = spa, ACTIVO = true, DEFECTO = conC.defecto }); db.SaveChanges(); } return(RedirectToAction("Index", new { vko = vko, vtw = vtw, kun = kun, spa = spa })); } }
public ActionResult Create(string vko, string vtw, string kun, string spa) { int pagina = 642; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList(); ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList(); ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;; ViewBag.rol = user.MIEMBROS.FirstOrDefault().ROL.NOMBRE; ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50; ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; Contactoc conC = new Contactoc(); conC.vkorg = vko; conC.vtweg = vtw; conC.kunnr = kun; conC.spart = spa; return(View(conC)); } }