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