public ActionResult Create([Bind(Include = "ID,TITULO,FINICIO,FRECUENCIA,FRECUENCIA_N,DIA_SEMANA,DIA_MES,ORDINAL_MES,ORDINAL_DSEMANA")] NEGOCIACION2 nEGOCIACION, FormCollection col)
{
int pagina = 903; //ID EN BASE DE DATOS
string u = User.Identity.Name;
USUARIO user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller, 901);
ViewBag.mensajes = JsonConvert.SerializeObject(db.MENSAJES.Where(a => (a.PAGINA_ID.Equals(901) || a.PAGINA_ID.Equals(0)) && a.SPRAS.Equals(user.SPRAS_ID)).ToList(), Formatting.Indented);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
}
ViewBag.lan = user.SPRAS_ID;
if (ModelState.IsValid)
{
NEGOCIACION2 nego = new NEGOCIACION2();
var proximaFecha = FnCommon.obtenerProximaFecha(nEGOCIACION, col["group1"]);
nego.FRECUENCIA_N = nEGOCIACION.FRECUENCIA_N;
nego.TITULO = nEGOCIACION.TITULO;
nego.FRECUENCIA = nEGOCIACION.FRECUENCIA;
nego.FINICIO = nEGOCIACION.FINICIO;
if (nego.FRECUENCIA == "S")
{
nego.DIA_SEMANA = nEGOCIACION.DIA_SEMANA;
}
else if (nego.FRECUENCIA == "M")
{
if (col["group1"] == "1")
{
nego.DIA_MES = nEGOCIACION.DIA_MES;
}
else
{
nego.ORDINAL_DSEMANA = nEGOCIACION.ORDINAL_DSEMANA;
nego.ORDINAL_MES = nEGOCIACION.ORDINAL_MES;
}
}
db.NEGOCIACION2.Add(nego);
db.SaveChanges();
try
{
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(View("Error"));
}
}
else
{
ViewBag.FRECUENCIA = new SelectList(FnCommon.ObtenerCmbFrecuencia(user.SPRAS_ID), "Value", "Text");
ViewBag.ORDINAL_DSEMANA = new SelectList(FnCommon.ObtenerCmbDias(user.SPRAS_ID), "Value", "Text");
ViewBag.ORDINAL_MES = new SelectList(FnCommon.ObtenerCmbOrdinales(user.SPRAS_ID), "Value", "Text");
return(View(nEGOCIACION));
}
}
// GET: Cuenta/Details/5
public ActionResult Details(string soc, string pai, string tal, int?eje)
{
int pagina = 694; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 693);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
if (soc == null || pai == null || tal == null || eje == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CUENTA cUENTA = db.CUENTAs.Find(soc, pai, tal, eje);
if (cUENTA == null)
{
return(HttpNotFound());
}
return(View(cUENTA));
}
// GET: Iimpuesto/Details/5
public ActionResult Details(string id, string id2, string id3)
{
int pagina = 732; //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();
FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller, 731);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
Session["spras"] = user.SPRAS_ID;
//Busqueda de un registro que coincida con los parametros
var con = db.IIMPUESTOes.Where(x => x.LAND == id && x.MWSKZ == id2 && x.KSCHL == id3).First();
IIMPUESTO txx = new IIMPUESTO();
txx.LAND = con.LAND;
txx.MWSKZ = con.MWSKZ;
txx.KSCHL = con.KSCHL;
txx.KBETR = con.KBETR;
return(View(txx));
}
}
// GET: Consoporte/Details/5
public ActionResult Details(string tsol, string tsopo)
{
int pagina_id = 843; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
if (tsol == null || tsopo == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CONSOPORTE cONSOPORTE = db.CONSOPORTEs.Include(c => c.TSOL.TSOLTs).Include(c => c.TSOPORTE.TSOPORTETs).Where(x => x.TSOL_ID == tsol && x.TSOPORTE_ID == tsopo).First();
if (cONSOPORTE == null)
{
return(HttpNotFound());
}
return(View(cONSOPORTE));
}
// GET: LAContabilizacion
public ActionResult Index()
{
FnCommon.ObtenerConfPage(db, 560, User.Identity.Name, this.ControllerContext.Controller);
string spras_id = ViewBag.spras_id;
return(View());
}
public ActionResult Edit([Bind(Include = "SOCIEDAD_ID,PAIS_ID,TSOL,FACTURA,FECHA,PROVEEDOR,CONTROL,AUTORIZACION,VENCIMIENTO,FACTURAK,EJERCICIOK,BILL_DOC,BELNR,IMPORTE_FAC,PAYER,DESCRIPCION,SOCIEDAD,ACTIVO")] FACTURASCONF fACTURASCONF)
{
if (ModelState.IsValid)
{
db.Entry(fACTURASCONF).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
int pagina_id = 1213; //ID EN BASE DE DATOS
int pagina2 = 1210;
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, pagina2);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
return(View(fACTURASCONF));
}
public ActionResult Create(string vko, string vtw, string kun, string spa)
{
int pagina = 643; //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");
}
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: Warnings/Create
public ActionResult Create(string id)
{
int pagina = 511; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 510);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
int ids = Int32.Parse(id);
ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(ids)), "ID", "ID");
ViewBag.SPRAS_ID = new SelectList(db.SPRAS.Where(x => x.ID != "PT"), "ID", "ID");
ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID");
WARNING w = new WARNING();
w.PAGINA_ID = ids;
return(View(w));
}
// GET: Soporte/Details/5
public ActionResult Details(string tsoporte_id)
{
int pagina_id = 1315; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
if (tsoporte_id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var sopor = db.TSOPORTEs.Where(x => x.ID == tsoporte_id).FirstOrDefault();
if (tsoporte_id == null)
{
return(HttpNotFound());
}
return(View(sopor));
}
public ActionResult Edit([Bind(Include = "PAGINA_ID,CAMPO_ID,SPRAS_ID,WARNING1,POSICION,ACTIVO")] WARNING wARNING)
{
if (ModelState.IsValid)
{
wARNING.WARNING1 = wARNING.WARNING1.Replace("\r\n", "<br>");
db.Entry(wARNING).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { id = wARNING.PAGINA_ID }));
}
int pagina = 512; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 510);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
ViewBag.PAGINA_ID = new SelectList(db.CAMPOS, "PAGINA_ID", "DESCRIPCION", wARNING.PAGINA_ID);
ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID");
return(View(wARNING));
}
// GET: Warnings
public ActionResult Index(string id)
{
int pagina = 510; //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
{
//return RedirectToAction("Pais", "Home");
}
TempData["id"] = id;
try
{
int idi = Int32.Parse(id);
var wARNINGs = db.WARNINGs.Where(a => a.PAGINA_ID.Equals(idi)).Include(w => w.CAMPOS);
return(View(wARNINGs.ToList()));
}
catch
{
var wARNINGs = db.WARNINGs.Include(w => w.CAMPOS);
return(View(wARNINGs.ToList()));
}
}
// GET: Warnings/Edit/5
public ActionResult Edit(string spras_id, string campo_id, int pagina_id)
{
int pagina = 512; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 510);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
WARNING wARNING = db.WARNINGs.Find(pagina_id, campo_id, spras_id);
if (wARNING == null)
{
return(HttpNotFound());
}
wARNING.WARNING1 = wARNING.WARNING1.Replace("<br>", "\r\n");
ViewBag.PAGINA_ID = new SelectList(db.CAMPOS, "PAGINA_ID", "DESCRIPCION", wARNING.PAGINA_ID);
ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(wARNING.PAGINA_ID)), "ID", "ID");
ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID");
return(View(wARNING));
}
public ActionResult Create([Bind(Include = "PAGINA_ID,CAMPO_ID,SPRAS_ID,WARNING1,POSICION,ACTIVO")] WARNING wARNING)
{
if (ModelState.IsValid)
{
var obj = db.WARNINGs.Where(a => a.PAGINA_ID.Equals(wARNING.PAGINA_ID) && a.CAMPO_ID.Equals(wARNING.CAMPO_ID) && a.SPRAS_ID.Equals(wARNING.SPRAS_ID)).FirstOrDefault();
if (obj == null)
{
wARNING.WARNING1 = wARNING.WARNING1.Replace("\r\n", "<br>");
db.WARNINGs.Add(wARNING);
db.SaveChanges();
return(RedirectToAction("Index", new { id = wARNING.PAGINA_ID }));
}
}
int pagina = 511; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 510);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(wARNING.PAGINA_ID)), "ID", "ID");
ViewBag.SPRAS_ID = new SelectList(db.SPRAS.Where(x => x.ID != "PT"), "ID", "ID");
ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID");
ViewBag.Error = "Registro duplicado";
return(View(wARNING));
}
// GET: Usuarios/Create
public ActionResult Create()
{
int pagina = 923; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller);
return(View());
}
// GET: Taxeoh/Create
public ActionResult Create(string kun, string vko, string vtw, string spa)
{
int pagina_id = 854; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 851);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//ViewBag.pais = "mx.svg";
//return RedirectToAction("Pais", "Home");
}
ViewBag.VKORG = new SelectList(db.CLIENTEs, "VKORG", "NAME1");
ViewBag.IMPUESTO_ID = new SelectList(db.IMPUESTOes.Where(x => x.ACTIVO), "MWSKZ", "MWSKZ");
ViewBag.PAIS_ID = new SelectList(db.PAIS, "LAND", "SPRAS");
ViewBag.SOCIEDAD_ID = new SelectList(db.SOCIEDADs, "BUKRS", "BUTXT");
ViewBag.CONCEPTO_ID = new SelectList(db.TX_CONCEPTO, "ID", "DESCRIPCION");
ViewBag.TNOTA_ID = new SelectList(db.TX_TNOTA, "ID", "DESCRIPCION");
ViewBag.kun = kun;
ViewBag.vko = vko;
ViewBag.vtw = vtw;
ViewBag.spa = spa;
CLIENTE cli = db.CLIENTEs.Find(vko, vtw, spa, kun);
ViewBag.Cliente = cli.NAME1;
ViewBag.NoCliente = cli.KUNNR;
return(View());
}
// GET: Soporte/Create
public ActionResult Create()
{
int pagina_id = 1316; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller);
ViewBag.activo = true;
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
TSOPORTE soporte = new TSOPORTE();
soporte.ACTIVO = true;
soporte.TSOPORTETs = new List <TSOPORTET>();
soporte.TSOPORTETs.Add(new TSOPORTET {
SPRAS_ID = "ES"
});
soporte.TSOPORTETs.Add(new TSOPORTET {
SPRAS_ID = "EN"
});
return(View(soporte));
}
public ActionResult Edit(Calendario445ViewModel modelView)
{
int pagina_id = 532;//ID EN BASE DE DATOS
try
{
CALENDARIO_AC calendarioAc = modelView.calendario445;
DateTime fechaActual = DateTime.Now;
calendarioAc.USUARIOM_ID = User.Identity.Name;
calendarioAc.FECHAM = fechaActual;
if (!ValidarFechas(calendarioAc))
{
throw (new Exception());
}
db.Entry(calendarioAc).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception)
{
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller);
CargarSelectList(ref modelView, new string[] {
CMB_SOCIEDADES + "," + modelView.calendario445.SOCIEDAD_ID,
CMB_PERIODOS + "," + modelView.calendario445.PERIODO,
CMB_EJERCICIO,
CMB_TIPOSSOLICITUD + "," + modelView.calendario445.TSOL_ID
});
return(View(modelView));
}
}
public ActionResult Details(string id)
{
int pagina_id = 662; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MATERIAL mATERIAL = db.MATERIALs.Find(id);
if (mATERIAL == null)
{
return(HttpNotFound());
}
return(View(mATERIAL));
}
// GET: DocRelacion/Details/5
public ActionResult Details(string id, string pais, string tsol)
{
int pagina_id = 1212; //ID EN BASE DE DATOS
int pagina2 = 1210;
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, pagina2);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//ViewBag.pais = "mx.svg";
//return RedirectToAction("Pais", "Home");
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var rel = db.FACTURASCONFs.Where(x => x.SOCIEDAD_ID == id && x.PAIS_ID == pais && x.TSOL == tsol).FirstOrDefault();
if (id == null)
{
return(HttpNotFound());
}
return(View(rel));
}
// GET: Taxeoh
public ActionResult Index(string vko, string vtw, string kun, string spa)
{
int pagina_id = 851; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//ViewBag.pais = "mx.svg";
//return RedirectToAction("Pais", "Home");
}
var tAXEOHs = db.TAXEOHs.Include(t => t.CLIENTE).Include(t => t.IMPUESTO).Include(t => t.PAI).Include(t => t.SOCIEDAD).Include(t => t.TX_CONCEPTO).Include(t => t.TX_TNOTA);
ViewBag.kun = kun;
ViewBag.vko = vko;
ViewBag.vtw = vtw;
ViewBag.spa = spa;
CLIENTE cli = db.CLIENTEs.Find(vko, vtw, spa, kun);
ViewBag.Cliente = cli.NAME1;
ViewBag.NoCliente = cli.KUNNR;
return(View(tAXEOHs.Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.ACTIVO == true).ToList()));
}
public ActionResult Index(string vko, string vtw, string kun, string spa, string aa)
{
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");
}
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 Edit([Bind(Include = "SOCIEDAD_ID,PAIS_ID,VKORG,VTWEG,SPART,KUNNR,CONCEPTO_ID,TNOTA_ID,FECHAC,USUARIOC_ID,FECHAM,USUARIOM_ID,IMPUESTO_ID,PORC,PAY_T,ACTIVO")] TAXEOH tx, string MWSKZ)
{
if (ModelState.IsValid)
{
var por = db.IIMPUESTOes.Where(ip => ip.MWSKZ == MWSKZ).FirstOrDefault();
var tax = db.TAXEOHs.Where(x => x.KUNNR == tx.KUNNR && x.VKORG == tx.VKORG && x.CONCEPTO_ID == tx.CONCEPTO_ID).FirstOrDefault();
tax.IMPUESTO_ID = MWSKZ;
tax.PORC = por.KBETR;
tax.PAY_T = tx.PAY_T;
db.Entry(tax).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
int pagina_id = 853; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 851);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//ViewBag.pais = "mx.svg";
//return RedirectToAction("Pais", "Home");
}
ViewBag.VKORG = new SelectList(db.CLIENTEs, "VKORG", "NAME1", tx.VKORG);
ViewBag.IMPUESTO_ID = new SelectList(db.IMPUESTOes, "MWSKZ", "MWSKZ", tx.IMPUESTO_ID);
ViewBag.PAIS_ID = new SelectList(db.PAIS, "LAND", "SPRAS", tx.PAIS_ID);
ViewBag.SOCIEDAD_ID = new SelectList(db.SOCIEDADs, "BUKRS", "BUTXT", tx.SOCIEDAD_ID);
ViewBag.CONCEPTO_ID = new SelectList(db.TX_CONCEPTO, "ID", "DESCRIPCION", tx.CONCEPTO_ID);
ViewBag.TNOTA_ID = new SelectList(db.TX_TNOTA, "ID", "DESCRIPCION", tx.TNOTA_ID);
return(View(tx));
}
public ActionResult Create([Bind(Include = "ID,HOST,PORT,SSL,MAIL,PASS")] Conmail conmail)
{
CONMAIL u = new CONMAIL();
u.ID = conmail.ID;
u.HOST = conmail.HOST;
u.PORT = conmail.PORT;
u.SSL = conmail.SSL;
u.MAIL = conmail.MAIL;
u.PASS = conmail.PASS;
u.ACTIVO = true;
db.CONMAILs.Add(u);
try
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch {
ViewBag.Error = "El usuario ya existe. Introduzca un ID de usuario diferente";
int pagina = 933; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller);
Conmail cONMAIL = new Conmail();
return(View(cONMAIL));
}
}
// GET: Taxeoh/Delete/5
public ActionResult Delete(string kun, string vk, string con)
{
int pagina_id = 855; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 851);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//ViewBag.pais = "mx.svg";
//return RedirectToAction("Pais", "Home");
}
int ci = Convert.ToInt32(con);
TAXEOH tAXEOH = db.TAXEOHs.Where(x => x.KUNNR == kun && x.VKORG == vk && x.CONCEPTO_ID == ci).FirstOrDefault();
if (tAXEOH == null)
{
return(HttpNotFound());
}
return(View(tAXEOH));
}
// GET: CalendarioEx445/5
public ActionResult Index(short ejercicio, int periodo, string sociedad_id, string tsol_id)
{
int pagina_id = 533;//ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller);
Calendario445ViewModel modelView = new Calendario445ViewModel();
modelView.calendarioEx445.EJERCICIO = ejercicio;
modelView.calendarioEx445.PERIODO = periodo;
modelView.calendarioEx445.SOCIEDAD_ID = sociedad_id;
modelView.calendarioEx445.TSOL_ID = tsol_id;
modelView.calendariosEx445List = ObtenerExcepciones(ejercicio, periodo, sociedad_id, tsol_id);
modelView.calendario445 = ObtenerCalendario445(ejercicio, periodo, sociedad_id, tsol_id);
CargarSelectList(ref modelView, new string[] {
CMB_SOCIEDADES + "," + sociedad_id,
CMB_PERIODOS + "," + periodo,
CMB_TIPOSSOLICITUD + "," + tsol_id,
CMB_USUARIOS
});
return(View(modelView));
}
public ActionResult DeleteConfirmed(TAXEOH tx)
{
try
{
TAXEOH tAXEOH = db.TAXEOHs.Where(x => x.KUNNR == tx.KUNNR && x.VKORG == tx.VKORG && x.CONCEPTO_ID == tx.CONCEPTO_ID && x.VTWEG == tx.VTWEG).FirstOrDefault();
tAXEOH.ACTIVO = false;
db.Entry(tAXEOH).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { vko = tAXEOH.VKORG, vtw = tAXEOH.VTWEG, kun = tAXEOH.KUNNR, spa = tAXEOH.SPART }));
}
catch (Exception e)
{
int pagina_id = 855; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 851);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//ViewBag.pais = "mx.svg";
//return RedirectToAction("Pais", "Home");
}
return(View(tx));
}
}
// GET: Iimpuesto/Delete/5
public ActionResult Delete(string id, string id2, string id3)
{
int pagina = 201; //ID EN BASE DE DATOS
using (TAT001Entities db = new TAT001Entities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//ViewBag.pais = "mx.svg";
//return RedirectToAction("Pais", "Home");
}
Session["spras"] = user.SPRAS_ID;
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
IIMPUESTO txx = db.IIMPUESTOes.Where(x => x.LAND == id && x.MWSKZ == id2 && x.KSCHL == id3).FirstOrDefault();
return(View(txx));
}
// GET: Taxeoh/Details/5
public ActionResult Details(string kun, string vk, string con, string sc)
{
int pagina_id = 852; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 851);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
var coni = Convert.ToInt32(con);
TAXEOH tAXEOH = db.TAXEOHs.Where(x => x.KUNNR == kun && x.VKORG == vk && x.CONCEPTO_ID == coni && x.SOCIEDAD_ID == sc).FirstOrDefault();
if (tAXEOH == null)
{
return(HttpNotFound());
}
//ViewBag.kun = kun;
//ViewBag.vko = vko;
//ViewBag.vtw = vtw;
//ViewBag.spa = spa;
CLIENTE cli = db.CLIENTEs.Find(vk, tAXEOH.VTWEG, tAXEOH.SPART, kun);
ViewBag.Cliente = cli.NAME1;
ViewBag.NoCliente = cli.KUNNR;
return(View(tAXEOH));
}
// GET: Iimpuesto/Create
public ActionResult Create()
{
int pagina = 734; //ID EN BASE DE DATOS
using (TAT001Entities db = new TAT001Entities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller, 731);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//ViewBag.pais = "mx.svg";
//return RedirectToAction("Pais", "Home");
}
Session["spras"] = user.SPRAS_ID;
}
ViewBag.MWSKZ = new SelectList(db.IMPUESTOes, "MWSKZ", "MWSKZ");
ViewBag.LAND = new SelectList(db.PAIS, "LAND", "SPRAS");
return(View());
}
// GET: Negs/Edit/5
public ActionResult Edit(int id)
{
int pagina = 902; //ID EN BASE DE DATOS
string u = User.Identity.Name;
USUARIO user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller, 901);
ViewBag.mensajes = JsonConvert.SerializeObject(db.MENSAJES.Where(a => (a.PAGINA_ID.Equals(901) || a.PAGINA_ID.Equals(0)) && a.SPRAS.Equals(user.SPRAS_ID)).ToList(), Formatting.Indented);
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
}
Session["spras"] = user.SPRAS_ID;
ViewBag.lan = user.SPRAS_ID;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NEGOCIACION2 nEGOCIACION = db.NEGOCIACION2.Where(x => x.ID == id).FirstOrDefault();
if (nEGOCIACION == null)
{
return(HttpNotFound());
}
ViewBag.FRECUENCIA = new SelectList(FnCommon.ObtenerCmbFrecuencia(user.SPRAS_ID), "Value", "Text", nEGOCIACION.FRECUENCIA);
ViewBag.ORDINAL_DSEMANA = new SelectList(FnCommon.ObtenerCmbDias(user.SPRAS_ID), "Value", "Text", nEGOCIACION.ORDINAL_DSEMANA);
ViewBag.ORDINAL_MES = new SelectList(FnCommon.ObtenerCmbOrdinales(user.SPRAS_ID), "Value", "Text", nEGOCIACION.ORDINAL_MES);
return(View(nEGOCIACION));
}
