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