public string Edit(DClienteProv Entity)
{
result = "";
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
try
{
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_EditCliProv";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idcliprov", Entity.Idprov);
cmd.Parameters.AddWithValue("@nom_prov", Entity.Nom_prov);
cmd.Parameters.AddWithValue("@ruc", Entity.Ruc);
result = cmd.ExecuteNonQuery() == 1 ? "Se Modifico Correctamente!" : "Error al Modificar";
cmd.Parameters.Clear();
}
}
catch (Exception ex)
{
result = ex.Message;
}
}
return(result);
}
public List <DClienteProv> Getdata(DClienteProv Entity)
{
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_ShowCliProv";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dtr = cmd.ExecuteReader();
using (DataTable dt = new DataTable())
{
dt.Load(dtr);
dtr.Dispose();
listclienteprov = new List <DClienteProv>();
foreach (DataRow item in dt.Rows)
{
listclienteprov.Add(new DClienteProv()
{
Idprov = Convert.ToInt32(item[0]),
Nom_prov = item[1].ToString(),
Ruc = item[2].ToString()
});
}
}
}
}
return(listclienteprov);
}
public FrmClientePro()
{
InitializeComponent();
dclienteprov = new DClienteProv();
rclienteprov = new RClienteProv();
Show_business();
Tabla();
}
public string Delete(DClienteProv Entity)
{
using (SqlConnection conn = Dconexion.Getconectar())
{
conn.Open();
cmd = null;
using (cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "manto.SP_DeleteCliProv";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idcliprov", Entity.Idprov);
result = cmd.ExecuteNonQuery() == 1 ? "Se Elimino Correctamente!" : "Error al Eliminar";
cmd.Parameters.Clear();
}
}
return(result);
}
public string Add(DClienteProv Entity)
{
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
try
{
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_AddCliProv";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@nom_prov", Entity.Nom_prov);
cmd.Parameters.AddWithValue("@ruc", Entity.Ruc);
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 RUC " + Entity.Ruc + " INGRESADO YA SE ENCUENTRA REGISTRADO";
}
else
{
result = ex.Message;
}
}
} //aqui esta cerrando la conexion.
return(result);
}
public FrmV_ClienteProv()
{
InitializeComponent();
dClienteProv = new DClienteProv();
rClienteProv = new RClienteProv();
}
