public DetallePedidoProduccion(int pidDetPedP, int pcant, PedidoProduccion pidPedProd, Mueble pidMue)
{
idDetPedProd = pidDetPedP;
cantidad = pcant;
idPedidoProd = pidPedProd;
idMueble = pidMue;
}
public static void Delete(Mueble pMueble)
{
SqlConnection connection = null;
SqlTransaction transaction = null;
try
{
connection = new SqlConnection(CONNECTION_STRING);
connection.Open();
transaction = connection.BeginTransaction();
DeleteMaterial(pMueble, connection);
DeleteMueble(pMueble, connection);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
connection.Close();
}
}
/// <summary>
/// GetAll
/// </summary>
/// <Author>hcmoreno</Author>
public static List<Mueble> GetAll()
{
SqlConnection connection = null;
SqlCommand cmd = new SqlCommand();
SqlDataReader reader = null;
try
{
connection = new SqlConnection(CONNECTION_STRING);
String sql =
"SELECT [id_mueble]"
+ ", [id_tipo_mueble]"
+ ", [denominacion]"
+ ", [características]"
+ ",[costo]"
+ ",[precio_venta]"
+ " FROM [Muebles].[dbo].[Muebles]";
cmd.CommandText = sql;
cmd.Connection = connection;
cmd.CommandType = CommandType.Text;
connection.Open();
reader = cmd.ExecuteReader();
List<Mueble> Muebles = new List<Mueble>();
while (reader.Read())
{
Mueble oMueble = new Mueble();
oMueble.IdMueble = (Int32)reader["idMueble"];
oMueble.Denominacion = (String)reader["Denominacion"];
oMueble.Caracteristicas = (String)reader["Caracteristicas"];
oMueble.Costo = (decimal?)reader["costo"];
TipoMueble tipoMueble = new TipoMueble();
oMueble.IdTipoMueble.IdTipoMueble = Convert.ToInt32(reader["idTipoMueble"]);
oMueble.PrecioVta = (decimal?)reader["PrecioVta"];
oMueble.MaterialesMueble = GetByIdMueble(oMueble);
Muebles.Add(oMueble);
}
return Muebles;
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
connection.Close();
reader.Close();
}
}
public static void Delete(int idMueble)
{
Mueble mueble = new Mueble();
mueble.IdMueble = idMueble;
Delete(mueble);
}
/// <summary>
/// Update
/// </summary>
/// <returns>void</returns>
/// <Date></Date>
/// <Author>hcmoreno</Author>
private static void UpdateMueble(Mueble pMueble, SqlConnection connection)
{
SqlCommand cmd = new SqlCommand();
try
{
String sql = "update Muebles set idTipoMueble =@idTipoMueble, denominacion = @denominacion, caracteristicas = @caracteristicas, "
+ "costo = @costo where idMueble=@idMueble";
cmd.CommandText = sql;
cmd.Connection = connection;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@idTipoMueble", pMueble.IdTipoMueble);
cmd.Parameters.AddWithValue("@denominacion", pMueble.Denominacion);
cmd.Parameters.AddWithValue("@caracteristicas", pMueble.Caracteristicas);
cmd.Parameters.AddWithValue("@costo", pMueble.Costo);
cmd.Parameters.AddWithValue("@precioVta", pMueble.PrecioVta);
cmd.Parameters.AddWithValue("@idMueble", pMueble.IdMueble);
cmd.ExecuteNonQuery();
}
finally
{
cmd.Dispose();
}
}
private static int InsertMueble(Mueble pMueble, SqlConnection connection)
{
SqlCommand cmd = new SqlCommand();
try
{
String sql = "insert into Muebles( idTipoMueble, denominacion, caracteristicas, costo, precioVta) OUTPUT Inserted.idMueble "
+ "values(@IdTipoMueble, @denominacion,@caracteristicas, @costo, @precioVta)";
cmd.CommandText = sql;
cmd.Connection = connection;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@IdTipoMueble", pMueble.IdTipoMueble);
cmd.Parameters.AddWithValue("@denominacion", pMueble.Denominacion);
cmd.Parameters.AddWithValue("@caracteristicas", pMueble.Caracteristicas);
cmd.Parameters.AddWithValue("@costo", pMueble.Costo);
cmd.Parameters.AddWithValue("@precioVta", pMueble.PrecioVta);
int idMagico = (int)cmd.ExecuteScalar();
return idMagico;
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
}
}
/// <summary>
/// Insert
/// </summary>
/// <param name="pmueble">objeto tipo mueble</param>
/// <returns>int</returns>
/// <Date>2013-10-13</Date>
/// <Author>fmartina</Author>
private static void InsertMateriales(Mueble pMueble, SqlConnection connection)
{
foreach (MaterialMueble materialMueble in pMueble.MaterialesMueble)
{
SqlCommand cmd = new SqlCommand();
try
{
String sql = "insert into Materiales_Muebles( idMueble, idMaterial, cantidad)values (@pIdMueble,@pIdMaterial,@pCantidad) ";
cmd.CommandText = sql;
cmd.Connection = connection;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@pIdMueble", pMueble.IdMueble);
cmd.Parameters.AddWithValue("@pIdMaterial", materialMueble.Material.IdMaterial);
cmd.Parameters.AddWithValue("@pCantidad", materialMueble.Cantidad);
connection.Open();
cmd.ExecuteNonQuery();
}
finally
{
cmd.Dispose();
}
}
}
/// <summary>
/// Delete
/// </summary>
/// <returns>void</returns>
/// <Date></Date>
/// <Author>hcmoreno</Author>
private static void DeleteMueble(Mueble pMueble, SqlConnection connection)
{
SqlCommand cmd = new SqlCommand();
SqlCommand cmdMaterial = new SqlCommand();
try
{
String sql = "delete from Muebles where idMueble=@idMueble";
cmdMaterial.CommandText = sql;
cmdMaterial.Connection = connection;
cmdMaterial.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@idMueble", pMueble.IdMueble);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
}
}
/// <summary>
/// Insert
/// </summary>
/// <param name="pmueble">objeto tipo mueble</param>
/// <returns>int</returns>
/// <Date>2013-10-13</Date>
/// <Author>fmartina</Author>
public static int Insert(Mueble pMueble)
{
SqlConnection connection = null;
SqlTransaction transaction = null;
try
{
connection = new SqlConnection(CONNECTION_STRING);
connection.Open();
transaction = connection.BeginTransaction();
pMueble.IdMueble = InsertMueble(pMueble, connection);
InsertMateriales(pMueble, connection);
transaction.Commit();
return pMueble.IdMueble.Value;
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
connection.Close();
}
}
public static List<MaterialMueble> GetByIdMueble(Mueble item)
{
SqlDataReader reader = null;
SqlConnection connection = null;
connection = new SqlConnection(MuebleDAO.CONNECTION_STRING);
string query = "SELECT m.id_material "
+ ",m.denominacion "
+ ",m.caracteristicas "
+ ",m.stock_minimo "
+ ",m.stock_real "
+ ",m.stock_asignado "
+ ",m.id_ud_medida "
+ ",mm.cantidad "
+ "From Materiales m, Materiales_Muebles mm "
+ "WHERE mm.idMueble = @idMueble ";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = connection;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@idMueble", item.IdMueble);
connection.Open();
reader = cmd.ExecuteReader();
List<MaterialMueble> materialMueble = new List<MaterialMueble>();
if (reader.Read())
{
MaterialDAO matDao = new MaterialDAO();
Material material = new Material();
material.IdMaterial = (int?)reader["id_material"];
material.Denominacion = (string)reader["denominacion"];
material.Caracteristicas = (string)reader["caracteristicas"];
material.StockMin = (Decimal)reader["stock_minimo"];
material.StockReal = (Decimal)reader["stock_real"];
material.StockAsign = (Decimal)reader["stock_asignado"];
int? idUnidadMedida = (int?)reader["id_ud_medida"];
if (idUnidadMedida != null)
{
material.UdMedida = UnidadMedidaDAO.GetById(idUnidadMedida.Value);
}
MaterialMueble mm = new MaterialMueble();
mm.Cantidad = (Int32)reader["cantidad"];
mm.Material = material;
materialMueble.Add(mm);
}
return materialMueble;
}
public static Mueble GetById(int? id)
{
SqlDataReader reader = null;
SqlConnection connection = null;
SqlCommand cmd = new SqlCommand();
try
{
connection = new SqlConnection(CONNECTION_STRING);
String sql = "select idMueble,denominacion, caracteristicas, costo, idtipomueble, preciovta from Muebles where id = @idMueble";
cmd.CommandText = sql;
cmd.Connection = connection;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@idMueble", id);
connection.Open();
reader = cmd.ExecuteReader();
Mueble Mueble = null;
if (reader.Read())
{
Mueble = new Mueble();
Mueble.IdMueble = (Int32)reader["idMueble"];
Mueble.Caracteristicas = (String)reader["Caracteristicas"];
Mueble.Costo = (decimal?)reader["costo"];
Mueble.Denominacion = (string )reader["Denominacion"];
TipoMueble tipoMueble = new TipoMueble();
Mueble.IdTipoMueble.IdTipoMueble = Convert.ToInt32(reader["idTipoMueble"]);
Mueble.PrecioVta = (decimal?)reader["PrecioVta"];
List<MaterialMueble> materialmueble = GetByIdMueble(Mueble);
Mueble.MaterialesMueble = materialmueble;
}
return Mueble;
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
connection.Close();
reader.Close();
}
}
private void ViewMueble(Mueble mueble)
{
FormEditable = false;
CargarFormulario(mueble);
pnlCrear.Visible = true;
divIdMaterial.Visible = true;
btnCancelar.Visible = false;
btnCerrar.Visible = true;
btnEditar.Visible = true;
btnEliminar.Visible = true;
btnGuardar.Visible = false;
btnCrear.Visible = false;
btnNuevo.Visible = false;
}
private Mueble ExtractFormData()
{
int? idMueble = (int?)ViewState["IdMueble"];
Mueble mueble = new Mueble();
mueble.IdMueble = idMueble;
mueble.Denominacion = txtNombre.Text;
mueble.Caracteristicas = txtCaracteristicas.Text;
decimal precio;
decimal.TryParse(txtPrecio.Text, out precio);
mueble.PrecioVta = precio;
TipoMueble tipoMueble = new TipoMueble();
int idTipoMueble;
int.TryParse(ddlTipoMueble.SelectedValue, out idTipoMueble);
tipoMueble.IdTipoMueble = idTipoMueble;
mueble.IdTipoMueble = tipoMueble;
return mueble;
}
protected void CargarFormulario(Mueble mueble)
{
showId.Text = "" + mueble.IdMueble;
txtNombre.Text = mueble.Denominacion;
showNombre.Text = mueble.Denominacion;
txtCaracteristicas.Text = mueble.Caracteristicas;
showCaracteristicas.Text = mueble.Caracteristicas;
txtPrecio.Text = (mueble.PrecioVta != null ? mueble.PrecioVta.ToString() : null);
showPrecio.Text = (mueble.PrecioVta != null ? mueble.PrecioVta.ToString() : null);
ddlTipoMueble.SelectedValue = (mueble.IdTipoMueble == null ? null : mueble.IdTipoMueble.IdTipoMueble.ToString());
showTipoMueble.Text = (mueble.IdTipoMueble == null ? null : mueble.IdTipoMueble.Descrip);
}