public SingleProvedor(Provedor reg) { InitializeComponent(); provedor = reg; this.DataContext = provedor; btnActualizar.Visibility = Visibility.Visible; btnGuardar.Visibility = Visibility.Collapsed; }
public string Create(Provedor obj) { CreateDAC objDAC = new CreateDAC(); if (objDAC.CreateRecord(obj) == true) return "Registro almacenado con éxito."; else return "No se pudo almacenar el regitro."; }
public string Update(Provedor obj, int idProvedor) { UpdateDAC objDAC = new UpdateDAC(); if (objDAC.UpdateRecord(obj, idProvedor) == true) return "Registro almacenado con éxito."; else return "No se pudo almacenar el regitro."; }
public bool CreateRecord(Provedor obj) { SqlConnection con = new SqlConnection(Info.sqlSet()); SqlCommand cmd = new SqlCommand("SP_Provedor_Insert", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Nombre", obj.Nombre); cmd.Parameters.AddWithValue("@RFC", obj.RFC); cmd.Parameters.AddWithValue("@Direccion", obj.Direccion); cmd.Parameters.AddWithValue("@Telefono", obj.Telefono); con.Open(); if (cmd.ExecuteNonQuery() > 0) { con.Close(); return true; } else { con.Close(); return false; } }
public Provedor readOneProvedor(int idProvedor) { Provedor provedor = new Provedor(); using (SqlConnection con = new SqlConnection(Info.sqlSet())) { SqlCommand cmd = new SqlCommand("SP_Provedor_SelectRow", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IdProvedor", idProvedor); con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { // Loop through each record. while (reader.Read()) { Provedor tmp = new Provedor(); tmp.IdProvedor = (reader.GetValue(0) != DBNull.Value) ? Convert.ToInt32(reader.GetValue(0)) : tmp.IdProvedor; tmp.Nombre = (reader.GetValue(1) != DBNull.Value) ? Convert.ToString(reader.GetValue(1)) : tmp.Nombre; tmp.RFC = (reader.GetValue(2) != DBNull.Value) ? Convert.ToString(reader.GetValue(2)) : tmp.RFC; tmp.Direccion = (reader.GetValue(3) != DBNull.Value) ? Convert.ToString(reader.GetValue(3)) : tmp.Direccion; tmp.Telefono = (reader.GetValue(4) != DBNull.Value) ? Convert.ToString(reader.GetValue(4)) : tmp.Telefono; provedor = tmp; } } con.Close(); } return provedor; }
public List<Provedor> readProvedor() { List<Provedor> provedorList = new List<Provedor>(); using (SqlConnection con = new SqlConnection(Info.sqlSet())) { SqlCommand cmd = new SqlCommand("SP_Provedor_SelectAll", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { // Loop through each record. while (reader.Read()) { Provedor tmp = new Provedor(); tmp.IdProvedor = (reader.GetValue(0) != DBNull.Value) ? Convert.ToInt32(reader.GetValue(0)) : tmp.IdProvedor; tmp.Nombre = (reader.GetValue(1) != DBNull.Value) ? Convert.ToString(reader.GetValue(1)) : tmp.Nombre; tmp.RFC = (reader.GetValue(2) != DBNull.Value) ? Convert.ToString(reader.GetValue(2)) : tmp.RFC; tmp.Direccion = (reader.GetValue(3) != DBNull.Value) ? Convert.ToString(reader.GetValue(3)) : tmp.Direccion; tmp.Telefono = (reader.GetValue(4) != DBNull.Value) ? Convert.ToString(reader.GetValue(4)) : tmp.Telefono; provedorList.Add(tmp); } } con.Close(); } return provedorList; }