// 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 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: 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: Iimpuesto/Create
public ActionResult Create()
{
int pagina = 734; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
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());
}
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));
}
// 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: Iimpuesto/Delete/5
public ActionResult Delete(string id, string id2, string id3)
{
int pagina = 201; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
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));
}
bool ValidarCondExistente(WARNINGP warningP, List <WARNING_COND> warningConds)
{
int pagina_id = 540;
bool existeCondParaTabCampo = false;
List <WARNING_COND> warningPs = db.WARNINGPs
.Where(x => x.CAMPO_ID == warningP.CAMPO_ID && x.TAB_ID == warningP.TAB_ID && x.ID != warningP.ID && ((x.SOCIEDAD_ID == null || x.SOCIEDAD_ID == warningP.SOCIEDAD_ID) && (x.TSOL_ID == null || x.TSOL_ID == warningP.TSOL_ID)))
.Join(db.WARNING_COND, w => w.ID, wc => wc.WARNING_ID, (w, wc) => wc)
.ToList();
warningPs.ForEach(x =>
{
if (warningConds.Any(y => y.VALOR_COMP == x.VALOR_COMP && y.CONDICION_ID == x.CONDICION_ID))
{
existeCondParaTabCampo = true;
}
});
if (warningConds.Count == 2 && warningConds[0].VALOR_COMP == warningConds[1].VALOR_COMP && warningConds[0].CONDICION_ID == warningConds[1].CONDICION_ID)
{
existeCondParaTabCampo = true;
}
if (existeCondParaTabCampo)
{
ViewBag.mnjError = FnCommon.ObtenerTextoMnj(db, pagina_id, "lbl_mnjExisteCondAlerta", User.Identity.Name);
return(false);
}
return(true);
}
// GET: Alertas/Create
public ActionResult Create()
{
int pagina_id = 541;//ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller);
AlertaViewModel modelView = new AlertaViewModel
{
//Mensajes
alertaMensajes = new List <WARNINGPT> {
new WARNINGPT {
SPRAS_ID = "ES"
}, new WARNINGPT {
SPRAS_ID = "EN"
}
},
//Condiciones
alertaCondiciones = new List <WARNING_COND> {
new WARNING_COND {
POS = 1
}, new WARNING_COND {
POS = 2, ORAND = ")"
}
}
};
//Combos
CargarSelectList(ref modelView, new string[] { CMB_TIPOS, CMB_SOCIEDADES, CMBTREE_TIPOSSOLICITUD, CMB_TABS, CMB_CONDCAMPOS }, null, true);
return(View(modelView));
}
// 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/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));
}
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/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: ccat/Edit/5
public ActionResult Edit(string id)
{
int pagina_id = 873; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 871);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
////var per = Convert.ToInt32(pr);
CONFDIST_CAT cONFDIST_CAT = db.CONFDIST_CAT.Where(i => i.SOCIEDAD_ID == id).FirstOrDefault();
if (cONFDIST_CAT == null)
{
return(HttpNotFound());
}
List <bool> lstb = new List <bool>();
lstb.Add(true);
lstb.Add(false);
ViewBag.CAMPO = new SelectList(db.CAMPOZKE24, "CAMPO", "CAMPO", cONFDIST_CAT.CAMPO);
ViewBag.SOCIEDAD_ID = new SelectList(db.SOCIEDADs, "BUKRS", "BUKRS", cONFDIST_CAT.SOCIEDAD_ID);
ViewBag.bools = new SelectList(lstb, cONFDIST_CAT.PORC_AD);
return(View(cONFDIST_CAT));
}
public ActionResult Create([Bind(Include = "BUKRS,ID_USER,TIPOPRE")] SociedadesUsuario sociedadesUsuario)
{
DET_TIPOPRESUPUESTO u = new DET_TIPOPRESUPUESTO();
u.BUKRS = sociedadesUsuario.BUKRS;
u.ID_USER = sociedadesUsuario.ID_USER;
u.TIPOPRE = sociedadesUsuario.TIPOPRE;
db.DET_TIPOPRESUPUESTO.Add(u);
try
{
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.Error = "El usuario ya existe. Introduzca un ID de usuario diferente";
int pagina = 723; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller);
SociedadesUsuario obj = new SociedadesUsuario();
return(View(obj));
}
}
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 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));
}
}
// 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));
}
bool ValidarPeriodoExistente(CALENDARIO_AC calendarioAc)
{
int pagina_id = 530;
string spras_id = FnCommon.ObtenerSprasId(db, User.Identity.Name);
int noExiste = 0;
sociedadesDao.ListaSociedades(TATConstantes.ACCION_LISTA_SOCIEDADES).ForEach(x =>
{
tiposSolicitudesDao.ListaTiposSolicitudes(spras_id, null).ForEach(z =>
{
calendarioAc.SOCIEDAD_ID = x.BUKRS;
calendarioAc.TSOL_ID = z.TSOL_ID;
if (!db.CALENDARIO_AC.Any(y => y.EJERCICIO == calendarioAc.EJERCICIO && y.PERIODO == calendarioAc.PERIODO &&
y.SOCIEDAD_ID == calendarioAc.SOCIEDAD_ID && y.TSOL_ID == calendarioAc.TSOL_ID))
{
noExiste++;
}
});
});
if (noExiste == 0)
{
ViewBag.mnjError = FnCommon.ObtenerTextoMnj(db, pagina_id, "lbl_mnjExistePeriodo", User.Identity.Name);
return(false);
}
return(true);
}
// GET: Iimpuesto/Details/5
public ActionResult Details(string id, string id2, string id3)
{
int pagina = 732; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
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));
}
}
public ActionResult CreateFA(string id, int pid, int v)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ObtenerConfPage(923, 925);
List <DET_APROBP> flujosva = db.DET_APROBP.Where(t => t.SOCIEDAD_ID == id && t.PUESTOC_ID == pid && t.VERSION == v).ToList();
var lan = ViewBag.usuario.SPRAS_ID;
var puestos = db.PUESTOes.Where(t => t.ID == pid).ToList();
var sl_puestos = puestos.Select(x => new { x.ID, Puesto = x.PUESTOTs.Count > 0 ? x.PUESTOTs.Where(t => t.SPRAS_ID == lan).FirstOrDefault().TXT50 : "" }).ToList();
ViewBag.PUESTOC_ID = new SelectList(sl_puestos, "ID", "Puesto");
ViewBag.NivelesA = new SelectList(FnCommon.ObtenerCmbNivelesA(), "Value", "Text");
ViewBag.NivelesP = new SelectList(FnCommon.ObtenerCmbNivel(), "Value", "Text");
ViewBag.NivelesM = new SelectList(FnCommon.ObtenerCmbNivel(), "Value", "Text");
DET_APROBH dET_APROBP = new DET_APROBH {
SOCIEDAD_ID = id, ACTIVO = true, VERSION = v + 1, PUESTOC_ID = pid
};
var sociedad = db.SOCIEDADs.Find(id);
ViewBag.Miles = db.PAIS.Where(t => t.LAND == sociedad.LAND).SingleOrDefault().MILES;
ViewBag.PD = db.PAIS.Where(t => t.LAND == sociedad.LAND).SingleOrDefault().DECIMAL;
ViewBag.FlujosActuales = flujosva;
return(View(dET_APROBP));
}
// 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()));
}
void CargarSelectList(ref Calendario445ViewModel modelView, string[] combos)
{
string spras_id = FnCommon.ObtenerSprasId(db, User.Identity.Name);
for (int i = 0; i < combos.Length; i++)
{
string[] combosSplit = combos[i].Split(',');
string combo = combosSplit[0];
string id = combosSplit.Length > 1 ? combosSplit[1] : null;
switch (combo)
{
case CMB_SOCIEDADES:
modelView.sociedades = sociedadesDao.ComboSociedades(TATConstantes.ACCION_LISTA_SOCIEDADES, id);
break;
case CMB_PERIODOS:
int?idAux = (id == null ? null : (int?)int.Parse(id));
modelView.periodos = periodosDao.ComboPeriodos(spras_id, idAux);
break;
case CMB_USUARIOS:
modelView.usuarios = usuariosDao.ComboUsuarios(TATConstantes.ACCION_LISTA_USUARIO, id);
break;
case CMB_TIPOSSOLICITUD:
modelView.cmbTiposSolicitud = tiposSolicitudesDao.ComboTiposSolicitudes(spras_id, id);
break;
default:
break;
}
}
}
// 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));
}
// 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));
}
public ActionResult Create([Bind(Include = "REGION1,SOCIEDAD")] REGION rEGION)
{
int pagina_id = 951;//ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 950);
string spras_id = ViewBag.spras_id;
ViewBag.SOCIEDAD = new SelectList(db.SOCIEDADs.Where(t => t.ACTIVO).ToList(), "BUKRS", "BUKRS");
if (ModelState.IsValid)
{
if (!existeRegion(rEGION.REGION1))
{
rEGION.REGION1 = rEGION.REGION1.ToUpper();
db.REGIONs.Add(rEGION);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
TempData["MensajeExiste"] = "Ya existe una región con el mismo ID";
}
}
return(View(rEGION));
}
// GET: TSOL
public ActionResult Index()
{
int pagina = 790; //ID EN BASE DE DATOS
FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller);
string u = User.Identity.Name;
USUARIO user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
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.lan = user.SPRAS_ID;
var tSOLs = db.TSOLs.Include(t => t.RANGO).Include(t => t.TSOL2).Include(x => x.TSOLTs).ToList();
return(View(tSOLs));
}
// 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));
}
