// GET: DesviacionesTS/Details/5
public ActionResult Details(int id)
{
int pagina = 1311; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 1312);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//ViewBag.pais = "mx.png";
//return RedirectToAction("Pais", "Home");
}
TS_CAMPO tS_CAMPO = db.TS_CAMPO.Include(x => x.TS_FORM).First(x => x.ID == id);
if (!tS_CAMPO.TS_FORMT.Any(x => x.SPRAS_ID == "ES"))
{
tS_CAMPO.TS_FORMT.Add(new TS_FORMT {
SPRAS_ID = "ES", TSFORM_ID = tS_CAMPO.ID, SPRA = db.SPRAS.Find("ES")
});
}
if (!tS_CAMPO.TS_FORMT.Any(x => x.SPRAS_ID == "EN"))
{
tS_CAMPO.TS_FORMT.Add(new TS_FORMT {
SPRAS_ID = "EN", TSFORM_ID = tS_CAMPO.ID, SPRA = db.SPRAS.Find("EN")
});
}
return(View(tS_CAMPO));
}
public ActionResult Edit([Bind(Include = "ID,ACTIVO")] TS_CAMPO tc, FormCollection collection)
{
if (ModelState.IsValid)
{
db.Entry(tc).State = EntityState.Modified;
var materialtextos = db.TS_FORMT.Where(t => t.TSFORM_ID == tc.ID).ToList();
db.TS_FORMT.RemoveRange(materialtextos);
List <TS_FORMT> textos = new List <TS_FORMT>();
if (collection.AllKeys.Contains("EN") && !String.IsNullOrEmpty(collection["EN"]))
{
TS_FORMT m = new TS_FORMT {
SPRAS_ID = "EN", TSFORM_ID = tc.ID, TXT100 = collection["EN"]
};
textos.Add(m);
}
if (collection.AllKeys.Contains("ES") && !String.IsNullOrEmpty(collection["ES"]))
{
TS_FORMT m = new TS_FORMT {
SPRAS_ID = "ES", TSFORM_ID = tc.ID, TXT100 = collection["ES"]
};
textos.Add(m);
}
db.TS_FORMT.AddRange(textos);
db.SaveChanges();
return(RedirectToAction("Index"));
}
int pagina = 1313; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//ViewBag.pais = "mx.png";
//return RedirectToAction("Pais", "Home");
}
ViewBag.des = db.TSOLTs.ToList();
return(View(tc));
}
public ActionResult Create([Bind(Include = "ID,ACTIVO")] TS_CAMPO tS_CAMPO, FormCollection collection)
{
int pagina = 1312; //ID EN BASE DE DATOS
try
{
if (ModelState.IsValid)
{
string socSelectedStr = collection["sociedadesSelected"];
List <string> socSelected = socSelectedStr.Split(',').ToList();
foreach (string soc in socSelected)
{
TS_CAMPO TS = new TS_CAMPO
{
ACTIVO = tS_CAMPO.ACTIVO,
ID = tS_CAMPO.ID
};
db.TS_CAMPO.Add(TS);
db.SaveChanges();
string land = db.SOCIEDADs.Find(soc).LAND;
db.TS_FORM.Add(new TS_FORM
{
POS = TS.ID,
CAMPO = TS.ID.ToString(),
ID = TS.ID,
BUKRS_ID = soc,
LAND_ID = land
});
db.SaveChanges();
List <TS_FORMT> listTextos = new List <TS_FORMT>();
if (collection.AllKeys.Contains("EN") && !String.IsNullOrEmpty(collection["EN"]))
{
listTextos.Add(new TS_FORMT {
SPRAS_ID = "EN", TSFORM_ID = TS.ID, TXT100 = collection["EN"]
});
}
if (collection.AllKeys.Contains("ES") && !String.IsNullOrEmpty(collection["ES"]))
{
listTextos.Add(new TS_FORMT {
SPRAS_ID = "ES", TSFORM_ID = TS.ID, TXT100 = collection["ES"]
});
}
db.TS_FORMT.AddRange(listTextos);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller);
return(View(tS_CAMPO));
}
catch (Exception e)
{
Log.ErrorLogApp(e, "DesviacionesTS", "Create");
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller);
ViewBag.SOCIEDADES = sociedadesDao.ComboSociedades(TATConstantes.ACCION_LISTA_SOCIEDADES);
return(View(tS_CAMPO));
}
}
