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)); }