public DataTable SelectById(int id)
{
FichaSoporteEntity objEnt = new FichaSoporteEntity();
objEnt.IDFichaSoporte = id;
return(objMod.ListarPorIdFichaSoporte(objEnt));
}
public int Insert(FichaSoporteEntity objEnt)
{
int _ultimoId = 0;
con = objCon.Conectar();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SP_INS_FICHA_SOPORTE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.Add("@FECHASOLICITUD", SqlDbType.DateTime).Value = objEnt.FechaSolicitud;
cmd.Parameters.Add("@HORASOLICITUD", SqlDbType.DateTime).Value = objEnt.HoraSolicitud;
cmd.Parameters.Add("@NOMBRE", SqlDbType.VarChar, 50).Value = objEnt.NomSolicitante;
cmd.Parameters.Add("@APEPATERNO", SqlDbType.VarChar, 50).Value = objEnt.PatSolicitante;
cmd.Parameters.Add("@APEMATERNO", SqlDbType.VarChar, 50).Value = objEnt.MatSolicitante;
cmd.Parameters.Add("@IDOFICINA", SqlDbType.Int).Value = objEnt.IdOficina;
cmd.Parameters.Add("@CARGO", SqlDbType.VarChar, 50).Value = objEnt.Cargo;
cmd.Parameters.Add("@SEDE", SqlDbType.VarChar, 50).Value = objEnt.Sede;
cmd.Parameters.Add("@OBVSERVACIONES", SqlDbType.VarChar, 200).Value = objEnt.Observaciones;
cmd.Parameters.Add("@IDTECNICO", SqlDbType.Int).Value = objEnt.IdTecnico;
cmd.Parameters.Add("@IDUSUINGRESO", SqlDbType.Int).Value = objEnt.IdUsuarioIngreso;
cmd.Parameters.Add("@ULTIMOID", SqlDbType.Int).Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
_ultimoId = Convert.ToInt32(cmd.Parameters["@ULTIMOID"].Value.ToString());
}
catch (SqlException ex)
{
//throw new Exception(ex.Message);
return(_ultimoId);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(_ultimoId);
}
public bool Update(FichaSoporteEntity objEnt)
{
con = objCon.Conectar();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "SP_UPD_FICHA_SOPORTE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FECHASOLICITUD", SqlDbType.DateTime).Value = objEnt.FechaSolicitud;
cmd.Parameters.Add("@HORASOLICITUD", SqlDbType.DateTime).Value = objEnt.HoraSolicitud;
cmd.Parameters.Add("@NOMBRE", SqlDbType.VarChar, 50).Value = objEnt.NomSolicitante;
cmd.Parameters.Add("@APEPATERNO", SqlDbType.VarChar, 50).Value = objEnt.PatSolicitante;
cmd.Parameters.Add("@APEMATERNO", SqlDbType.VarChar, 50).Value = objEnt.MatSolicitante;
cmd.Parameters.Add("@IDOFICINA", SqlDbType.Int).Value = objEnt.IdOficina;
cmd.Parameters.Add("@CARGO", SqlDbType.VarChar, 50).Value = objEnt.Cargo;
cmd.Parameters.Add("@SEDE", SqlDbType.VarChar, 50).Value = objEnt.Sede;
cmd.Parameters.Add("@OBVSERVACIONES", SqlDbType.VarChar, 200).Value = objEnt.Observaciones;
cmd.Parameters.Add("@IDTECNICO", SqlDbType.Int).Value = objEnt.IdTecnico;
cmd.Parameters.Add("@IDUSUMODIFICA", SqlDbType.Int).Value = objEnt.IdUsuarioModifica;
cmd.Parameters.Add("@IDFICSOPORTE", SqlDbType.Int).Value = objEnt.IDFichaSoporte;
try
{
int r = cmd.ExecuteNonQuery();
if (r == 1)
{
return(true);
}
}
catch (Exception ex)
{
//throw new Exception(ex.Message);
return(false);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(false);
}
public DataTable SearchNroDocumento(FichaSoporteEntity objEnt)
{
con = objCon.Conectar();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SP_NRO_DOC_FIC_SOPORTE", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@NRODOCUMENTO", SqlDbType.VarChar, 50).Value = objEnt.NroDocumento;
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable ListarPorIdFichaSoporte(FichaSoporteEntity objEnt)
{
DataTable dt = new DataTable();
try
{
con = objCon.Conectar();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SP_BUS_POR_ID_FIC_SOPORTE", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@ID", SqlDbType.Int).Value = objEnt.IDFichaSoporte;
da.Fill(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(dt);
}
public void BuscarNroDocumento(DataGridView dgv, FichaSoporteEntity objEnt)
{
var tabla = this.SearchNroDocumento(objEnt);
this.ListarGrid(dgv, tabla);
}
public void SearchNroDocumento(DataGridView dgv, FichaSoporteEntity objEnt)
{
objMod.BuscarNroDocumento(dgv, objEnt);
}
public bool Update(FichaSoporteEntity objEnt)
{
return(objMod.Update(objEnt));
}
//public void Add(FichaSoporteEntity objEnt)
//{
// objMod.Insert(objEnt);
//}
public int Add(FichaSoporteEntity objEnt)
{
return(objMod.Insert(objEnt));
}
