public void Update(TecnicoEntity objEnt)
{
con = objCon.Conectar();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SP_UPD_TECNICO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.Add("@IDTECNICO", SqlDbType.Int).Value = objEnt.IdTecnico;
cmd.Parameters.Add("@NOMBRE", SqlDbType.VarChar, 50).Value = objEnt.Nombre;
cmd.Parameters.Add("@APEPATERNO", SqlDbType.VarChar, 50).Value = objEnt.ApePaterno;
cmd.Parameters.Add("@APEMATERNO", SqlDbType.VarChar, 50).Value = objEnt.ApeMaterno;
cmd.Parameters.Add("@USUARIO", SqlDbType.VarChar, 50).Value = objEnt.Usuario;
cmd.Parameters.Add("@CLAVE", SqlDbType.NVarChar, 300).Value = objEnt.Clave;
cmd.Parameters.Add("@FLGESTADO", SqlDbType.Int).Value = objEnt.FLGTecnico;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
public DataTable Login(string user, string pass)
{
TecnicoModel objMod = new TecnicoModel();
TecnicoEntity objEnt = new TecnicoEntity();
objEnt.Usuario = user;
objEnt.ApePaterno = pass;
return(objMod.Login(objEnt));
}
public void Delete(TecnicoEntity objEnt)
{
con = objCon.Conectar();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SP_DEL_TECNICO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.Add("@IDTECNICO", SqlDbType.Int).Value = objEnt.IdTecnico;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
public DataTable Login(TecnicoEntity objEnt)
{
DataTable dt = new DataTable("tecnico");
try
{
con = objCon.Conectar();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SP_LOGIN", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@USUARIO", SqlDbType.VarChar, 50).Value = objEnt.Usuario;
da.SelectCommand.Parameters.Add("@PASSWORD", SqlDbType.VarChar, 50).Value = objEnt.Clave;
da.Fill(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(dt);
}
public void Delete(TecnicoEntity objEnt)
{
objMod.Delete(objEnt);
}
public void Update(TecnicoEntity objEnt)
{
objMod.Update(objEnt);
}
public void Add(TecnicoEntity objEnt)
{
objMod.Insert(objEnt);
}