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