protected void Btn_Agregar_Click(object sender, EventArgs e)
{
AdmisionBusiness adminBusinness = new AdmisionBusiness(WebConfigurationManager.ConnectionStrings["ProyectoHospitales"].ToString());
String nombreHospital = DropDownList2.SelectedItem.Value;
int numPaciente = Int32.Parse(DropDownList1.SelectedItem.Value);
int numSala = Int32.Parse(DropDownList3.SelectedItem.Value);
// DateTime fecha = DateTime.Today;
Admision admision = new Admision();
admision.NumSala = numSala;
admision.NumeroPasiente = numPaciente;
admision.NombreHospital = nombreHospital;
// admision.Fecha = fecha;
try
{
adminBusinness.InsertarLibro(admision);
lbl_agregar.Text = "Admision agregada con exito...";
}
catch (Exception exp)
{
throw exp;
}
}
public ActionResult AgregarVerificacion(int idh, int idhp)
{
if (Session["Id_userPol"] != null)
{
ViewBag.sIdH = idh;
return(View(Admision.getlaAdmision(idh, idhp).FirstOrDefault()));
}
else
{
return(RedirectToAction("acceso", "Home"));
}
}
public ActionResult ConcentradoVerificacion(string fecha01 = "", string fecha02 = "") //Cat_controlador_Acciones: 78
{
if (Session["Id_userPol"] != null)
{
if (fecha01 != "" && fecha02 != "")
{
return(View(Admision.getConcentradoAdmisiones(fecha01, fecha02).ToList()));
}
return(View());
}
else
{
return(RedirectToAction("acceso", "Home"));
}
}
public JsonResult AgregarActualizarVerificacion(Admision Adm)
{
string resultado = "Error";
string result = Admision.agregaActualizaVerificacion(Adm.id, Adm.idh, Adm.verificacion, Session["UsuarioSise"].ToString(), Adm.horario, Adm.accion);
if (result == "Ok")
{
resultado = "Ok";
}
else
{
resultado = "ERROR";
}
return(Json(resultado));
}
public ActionResult Create(AdmisionViewModel viewModel)
{
if (ModelState.IsValid)
{
var atencion = db.Atenciones.Find(viewModel.Admision.IdAtenciones);
Admision admision = viewModel.Admision;
admision.UserName = HttpContext.User.Identity.Name;
if (atencion.Admisions.Count == 0)
{
db.Admisions.Add(admision);
db.SaveChanges();
}
else
{
foreach (var item in atencion.Admisions)
{
item.EnvApt = admision.EnvApt;
item.EnvAsi = admision.EnvAsi;
item.FecEnvResEmp = admision.FecEnvResEmp;
item.FecEnvResMed = admision.FecEnvResMed;
item.HorIng = admision.HorIng;
item.HorReg = admision.HorReg;
item.HorSal = admision.HorSal;
item.Pendie = admision.Pendie;
item.UserName = admision.UserName;
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
}
if (viewModel.Interconsultas.Count != 0)
{
foreach (var item in viewModel.Interconsultas)
{
item.UserName = HttpContext.User.Identity.Name;
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index", "Atenciones"));
}
return(View(viewModel));
}
public ActionResult IndexAdmision(string valor = "") //Cat_controlador_Acciones: 77
{
if (Session["Id_userPol"] != null)
{
if (valor != "")
{
return(View(Admision.getListaAdmision(valor).ToList()));
}
else
{
return(View());
}
}
else
{
return(RedirectToAction("acceso", "Home"));
}
}
/***********************************************INSERTAR ADMISION**************************************************************/
public Admision InsertarLibro(Admision admision)
{
SqlConnection conexion = new SqlConnection(this.cadenaConexion);
String StoreProcedureAdmin = "InsertarAdmision";
conexion.Open();
SqlTransaction transaccion = conexion.BeginTransaction();
SqlCommand cmdInsertarAdmision = new SqlCommand(StoreProcedureAdmin, conexion);
cmdInsertarAdmision.Transaction = transaccion;
try
{
cmdInsertarAdmision.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parameter = new SqlParameter("@num_admision", SqlDbType.Int);
parameter.Direction = ParameterDirection.Output;
cmdInsertarAdmision.Parameters.Add(parameter);
cmdInsertarAdmision.Parameters.Add(new SqlParameter("@num_paciente", admision.NumeroPasiente));
cmdInsertarAdmision.Parameters.Add(new SqlParameter("@nombre_h", admision.NombreHospital));
cmdInsertarAdmision.Parameters.Add(new SqlParameter("@num_sala", admision.NumSala));
cmdInsertarAdmision.ExecuteNonQuery();
//libro.CodLibro = Int32.Parse(cmdInsertarLibro.Parameters["@cod_libro"].Value.ToString());
transaccion.Commit();
}
catch (SqlException e)
{
transaccion.Rollback();
throw e;
}
finally
{
if (conexion != null)
{
conexion.Close();
}
}
return(admision);
}
public Admision InsertarLibro(Admision admision)
{
return(admisionData.InsertarLibro(admision));
}
