public static string insertar(string TD_nombre)
{
DTipoDocumento obj = new DTipoDocumento();
obj.TD_Nombre = TD_nombre;
return(obj.Insertar(obj));
}
public List <DTipoDocumento> Getdata(DTipoDocumento Entity)
{
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_ShowDoc";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dtr = cmd.ExecuteReader();
using (DataTable dt = new DataTable())
{
dt.Load(dtr);
dtr.Dispose();
listTipoDoc = new List <DTipoDocumento>();
foreach (DataRow item in dt.Rows)
{
listTipoDoc.Add(new DTipoDocumento()
{
Iddocumento = Convert.ToInt32(item[0]),
Codigo = item[1].ToString(),
Descripcion = item[2].ToString()
});
}
}
}
}
return(listTipoDoc);
}
public string Edit(DTipoDocumento Entity)
{
result = "";
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
try
{
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_EditDocumento";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@iddoc", Entity.Iddocumento);
cmd.Parameters.AddWithValue("@codigo", Entity.Codigo);
cmd.Parameters.AddWithValue("@descripcion", Entity.Descripcion);
result = cmd.ExecuteNonQuery() == 1 ? "Se Modifico Correctamente!" : "Error al Modificar";
cmd.Parameters.Clear();
}
}
catch (Exception ex)
{
result = ex.Message;
}
}
return(result);
}
public static string Eliminar(int TD_id)
{
DTipoDocumento obj = new DTipoDocumento();
obj.TD_Id = TD_id;
return(obj.Eliminar(obj));
}
public static string Editar(int TD_id, string TD_nombre)
{
DTipoDocumento obj = new DTipoDocumento();
obj.TD_Id = TD_id;
obj.TD_Nombre = TD_nombre;
return(obj.Editar(obj));
}
public FrmTipoDocumento()
{
InitializeComponent();
dtipoDoc = new DTipoDocumento();
rtipoDoc = new RTipoDocumento();
Show_TipoDoc();
Tabla();
}
public string Delete(DTipoDocumento Entity)
{
using (SqlConnection conn = Dconexion.Getconectar())
{
conn.Open();
cmd = null;
using (cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "manto.SP_DeleteDocumento";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@iddocumento", Entity.Iddocumento);
result = cmd.ExecuteNonQuery() == 1 ? "Se Elimino Correctamente!" : "Error al Eliminar";
cmd.Parameters.Clear();
}
}
return(result);
}
public string Add(DTipoDocumento Entity)
{
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
try
{
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_AddDocumento";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigo", Entity.Codigo);
cmd.Parameters.AddWithValue("@descripcion", Entity.Descripcion);
result = cmd.ExecuteNonQuery() == 1 ? "Registrado Correctamente!" : "Error al Regsitrar";
cmd.Parameters.Clear();
}
}
catch (Exception ex)
{
SqlException sqlex = ex as SqlException;
if (sqlex != null && sqlex.Number == 2627)
{
result = "EL CODIGO INGRESADO YA SE ENCUENTRA REGISTRADO";
}
else
{
result = ex.Message;
}
}
} //aqui esta cerrando la conexion.
return(result);
}
public FrmVTipo_Doc()
{
InitializeComponent();
dTipoDocumento = new DTipoDocumento();
rTipoDoc = new RTipoDocumento();
}
/// <summary>
/// Consulta de catálogo : Author JUVA
/// </summary>
/// <param name="tipoSolicitudID">Filtro</param>
/// <param name="soloActivos">Filtro opcional</param>
/// <returns>Tipos de documentos</returns>
public List <OTipoDocumento> ObtenerListaV(int tipoSolicitudID = 1, bool soloActivos = false)
{
DTipoDocumento tipoDocumento = new DTipoDocumento();
return(tipoDocumento.ObtenerListaV(tipoSolicitudID, soloActivos));
}
