public ActionResult Actualizarhab(string id)
{
ConectorDataContext db = new ConectorDataContext();
ViewBag.hab = (from f in db.Habitacions where id == f.CodHab select f).ToList();
return View();
}
public ActionResult Registrar()
{
ConectorDataContext db = new ConectorDataContext();
ViewBag.id = db.usuarios.OrderByDescending(a => a.id).First().id;
return(View());
}
public ActionResult registrarhab()
{
ConectorDataContext db = new ConectorDataContext();
ViewBag.habi = (from i in db.Habitacions select i).ToList();
return View();
}
/// <summary>
/// Procedimiento que lista los conectores en base al calibre y cantidad
/// </summary>
/// <param name="intCalibreAceroID"></param>
/// <param name="intCantidad"></param>
/// <returns></returns>
public List <SeleccionConector> ListarConectorCartonFlow(short intCalibreAceroID, int intCantidad)
{
List <SeleccionConector> result = new List <SeleccionConector>();
try
{
using (ConectorDataContext dc = new ConectorDataContext(Helper.ConnectionString()))
{
var query = from item in dc.stp_ListarConectorCartonFlow(intCalibreAceroID, intCantidad)
select new SeleccionConector
{
sintTipoCartonFlowID = item.sintTipoCartonFlowID,
sintCalibre = item.sintCalibre,
vchTipoCartonFlow = item.vchTipoCartonFlow,
decAncho = item.decAncho,
decLargo = item.decLargo,
sintPesoPieza = item.sintPesoPieza,
decTotalKiloUnitario = item.decTotalKiloUnitario,
decPesoTotal = item.decPesoTotal,
decPrecioUnitario = item.decPrecioUnitario,
decPrecioTotal = item.decPrecioTotal,
vchLeyenda = item.vchLeyenda
};
result.AddRange(query);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public ActionResult Registrar(registrar r)
{
ConectorDataContext db = new ConectorDataContext();
if (ModelState.IsValid)
{
int l =0 ;
l=db.Clientes.Where(n => n.CodCli == r.Di).Count();
if (l == 0)
{
if (r.e == null)
r.e = "";
if (r.t == null)
r.t = "0";
db.Ins_cli_p(r.Nombre, r.Ap, r.Am, r.Di, r.Td, 1, r.ciu, Convert.ToInt32(r.t, 10), r.e, r.dir, r.fecha);
}
else
{
}
}
ViewBag.usu = (from f in db.Personas join j in db.Clientes on f.DocId equals j.CodCli select f).ToList();
return View();
}
public ActionResult Actualizarhab(Acthab r)
{
ConectorDataContext db = new ConectorDataContext();
if (ModelState.IsValid)
{
Convert.ToDouble(r.Pres);
db.Updambiente(r.bu, r.Tipo, r.Nro, Convert.ToDouble(r.Pres), r.Des, r.Est);
return Redirect("../registrarhab");
}
ViewBag.hab = (from f in db.Habitacions where r.bu == f.CodHab select f).ToList();
return View();
}
public ActionResult Registrar(usuario newuser, string repass)
{
if (ModelState.IsValid)
{
ConectorDataContext db = new ConectorDataContext();
newuser.fecha = DateTime.Now;
db.usuarios.InsertOnSubmit(newuser);
db.SubmitChanges();
return(RedirectToAction("exito", "Usuario"));
}
return(View());
}
public ActionResult actualizar(actualizar r)
{
ConectorDataContext db = new ConectorDataContext();
if (ModelState.IsValid) {
//ViewBag.usu2 = (from f in db.Personas join j in db.Clientes on f.DocId equals j.CodCli where id == f.DocId select f).ToList();
db.Updacliente(r.bu, r.Nombre, r.Ap, r.Am, r.Di, r.Td, 1, r.ciu, Convert.ToInt32(r.t, 10), r.e, r.dir, r.fecha);
return Redirect("../registrar");
}
ViewBag.usu2 = (from f in db.Personas join j in db.Clientes on f.DocId equals j.CodCli where r.bu == f.DocId select f).ToList();
return View();
}
public ActionResult Registrar(contenido aa)
{
if (ModelState.IsValid)
{
ConectorDataContext db = new ConectorDataContext();
aa.fecha = DateTime.Now;
aa.idUs = Convert.ToInt32(aa.idUs);
db.contenidos.InsertOnSubmit(aa);
db.SubmitChanges();
return(RedirectToAction("articulos", "Contenido"));
}
return(View());
}
public ActionResult registrarhab(registrarhab r)
{
ConectorDataContext db = new ConectorDataContext();
if (ModelState.IsValid)
{
int l = 0;
l = db.Habitacions.Where(n => n.CodHab == r.Nro).Count();
if (l == 0)
{
Convert.ToDouble(r.Pres);
db.Reg_Habi(r.Tipo, r.Nro, Convert.ToDouble(r.Pres), r.Des, r.Est);
}
}
ViewBag.habi = (from i in db.Habitacions select i).ToList();
return View();
}
public ActionResult articulos()
{
ConectorDataContext db = new ConectorDataContext();
List <Publicaciones> lista = db.contenidos.
OrderByDescending(a => a.id).
Where(a => a.idUs == a.usuario.id).
Select(a => new Publicaciones()
{
nickname = a.usuario.nickname,
email = a.usuario.email,
idC = a.id, content = a.content,
fecha = a.fecha
}).ToList();
ViewBag.lista = lista;
return(View());
}
public ActionResult Ingresar(ingresar newuser)
{
if (ModelState.IsValid)
{
ConectorDataContext db = new ConectorDataContext();
List<aux> l= db.Usuarios.Where(a => a.CodUs == newuser.usua && a.Pass == newuser.pas ).Select(a=>new aux{ id= a.CodUs }).ToList();
if (l.Count != 0) {
string al=db.Personas.Where(a => a.DocId == newuser.usua).First().DocId;
l = db.Personas.Where(a => a.DocId == newuser.usua).Select(a => new aux {id=a.DocId, nom = a.Nombre }).ToList();
ViewBag.lo = l[0].nom;
ViewBag.nom = l[0].nom;
return RedirectToAction("index", "cliente");
}
}
return View();
}
public JsonResult publicarcomentarios(comentario cc)
{
cc.fecha = DateTime.Now;
cc.idUs = 1;
ConectorDataContext db = new ConectorDataContext();
db.comentarios.InsertOnSubmit(cc);
db.SubmitChanges();
rendercomentario obj = new rendercomentario()
{
nickname = db.usuarios.Where(a => a.id == cc.idUs).First().nickname,
content = cc.content,
fecha = cc.fecha.ToShortTimeString(),
email = db.usuarios.Where(a => a.id == cc.idUs).First().email
};
return(Json(new { data = obj }));
}
/// <summary>
/// Procedimiento que lista los datos de conector de carton flow en base al ID de la cotización o al Id del conector
/// </summary>
/// <param name="intCotizacionID"></param>
/// <param name="intDatosConectorCFID"></param>
/// <returns></returns>
public List <DatosConectorCartonFlow> ListarDatosConectorCartonFlow(int intCotizacionID, int intDatosConectorCFID)
{
List <DatosConectorCartonFlow> result = new List <DatosConectorCartonFlow>();
try
{
using (ConectorDataContext dc = new ConectorDataContext(Helper.ConnectionString()))
{
var query = from item in dc.stp_ListarDatosConectorCartonFlow(intCotizacionID, intDatosConectorCFID)
select new DatosConectorCartonFlow
{
intDatosConectorCFID = item.intDatosConectorCFID,
intCotizacionID = item.intCotizacionID,
intDetCotizaID = item.intDetCotizaID,
sintTipoCartonFlowID = item.sintTipoCartonFlowID,
intCalibreAceroID = item.intCalibreAceroID,
decAncho = item.decAncho,
decLargo = item.decLargo,
sintPesoPieza = item.sintPesoPieza,
decTotalKiloUnitario = item.decTotalKiloUnitario,
decPesoTotal = item.decPesoTotal,
decPrecioUnitario = item.decPrecioUnitario,
decPrecioTotal = item.decPrecioTotal,
vchLeyenda = item.vchLeyenda,
intCantidad = item.intCantidad,
bitActivo = item.bitActivo
};
result.AddRange(query);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public ActionResult eliminar(string id, string ti)
{
ConectorDataContext db = new ConectorDataContext();
db.eli_hab(id, ti);
return Redirect("../registrarhab");
}
public ActionResult eliminar(string id)
{
ConectorDataContext db = new ConectorDataContext();
db.eli_cli(id);
return Redirect("../registrar");
}
//
// GET: /cliente/
public ActionResult Registrar()
{
ConectorDataContext db = new ConectorDataContext();
ViewBag.usu = (from f in db.Personas join j in db.Clientes on f.DocId equals j.CodCli select f).ToList();
return View();
}
public JsonResult loadData()
{
ConectorDataContext db =new ConectorDataContext();
return Json(new { lista = db.Personas.ToList(), nombres = db.Personas.Select(m => m.DocId).ToList() });
// return Json(new { lista = db.usuarios.ToList(), nombres = db.usuarios.Select(a => a.nombre).ToList() });
}
public ActionResult actualizar(string id)
{
ConectorDataContext db = new ConectorDataContext();
ViewBag.usu2 = (from f in db.Personas join j in db.Clientes on f.DocId equals j.CodCli where id == f.DocId select f).ToList();
return View();
}
