public SingleFactura(Factura reg) { InitializeComponent(); txtIdProvedor.ItemsSource = Proveedores; factura = reg; ReadBC objRead = new ReadBC(); btnActualizar.Visibility = Visibility.Visible; btnGuardar.Visibility = Visibility.Collapsed; }
public bool CreateRecord(Factura obj) { SqlConnection con = new SqlConnection(Info.sqlSet()); SqlCommand cmd = new SqlCommand("SP_Factura_Insert", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IdProvedor", obj.IdProvedor); cmd.Parameters.AddWithValue("@NoFactura", obj.NoFactura); cmd.Parameters.AddWithValue("@Fecha", obj.Fecha); con.Open(); if (cmd.ExecuteNonQuery() > 0) { con.Close(); return true; } else { con.Close(); return false; } }
public Factura readOneFactura(int idFactura) { Factura factura = new Factura(); using (SqlConnection con = new SqlConnection(Info.sqlSet())) { SqlCommand cmd = new SqlCommand("SP_Factura_SelectRow", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IdFactura", idFactura); con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { // Loop through each record. while (reader.Read()) { Factura tmp = new Factura(); tmp.IdFactura = (reader.GetValue(0) != DBNull.Value) ? Convert.ToInt32(reader.GetValue(0)) : tmp.IdFactura; tmp.IdProvedor = (reader.GetValue(1) != DBNull.Value) ? Convert.ToInt32(reader.GetValue(1)) : tmp.IdProvedor; tmp.NoFactura = (reader.GetValue(2) != DBNull.Value) ? Convert.ToString(reader.GetValue(2)) : tmp.NoFactura; tmp.Fecha = (reader.GetValue(3) != DBNull.Value) ? Convert.ToDateTime(reader.GetValue(3)) : tmp.Fecha; factura = tmp; } } con.Close(); } return factura; }
public List<Factura> readFactura() { List<Factura> facturaList = new List<Factura>(); using (SqlConnection con = new SqlConnection(Info.sqlSet())) { SqlCommand cmd = new SqlCommand("SP_Factura_SelectAll", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { // Loop through each record. while (reader.Read()) { Factura tmp = new Factura(); tmp.IdFactura = (reader.GetValue(0) != DBNull.Value) ? Convert.ToInt32(reader.GetValue(0)) : tmp.IdFactura; tmp.IdProvedor = (reader.GetValue(1) != DBNull.Value) ? Convert.ToInt32(reader.GetValue(1)) : tmp.IdProvedor; tmp.NoFactura = (reader.GetValue(2) != DBNull.Value) ? Convert.ToString(reader.GetValue(2)) : tmp.NoFactura; tmp.Fecha = (reader.GetValue(3) != DBNull.Value) ? Convert.ToDateTime(reader.GetValue(3)) : tmp.Fecha; facturaList.Add(tmp); } } con.Close(); } return facturaList; }
public string Create(Factura 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(Factura obj, int idFactura) { UpdateDAC objDAC = new UpdateDAC(); if (objDAC.UpdateRecord(obj, idFactura) == true) return "Registro almacenado con éxito."; else return "No se pudo almacenar el regitro."; }
public void ViewModel(Factura model) { this.Model = model; }