/// <summary> /// Insertar, Editar y Eliminar Carta Dia /// </summary> /// <param name="ESGR_CartaDia">Objecto de la Entidad Carta Dia</param> public void TransCartaDia(ESGR_CartaDia ESGR_CartaDia) { try { var objCmpSql = new CmpSql(SGRVariables.ConectionString); objCmpSql.CommandProcedure("spSGR_SET_CartaDia"); objCmpSql.AddParameter("@Opcion", SqlDbType.VarChar, ESGR_CartaDia.Opcion); objCmpSql.AddParameter("@IdCartaDia", SqlDbType.Int, ESGR_CartaDia.IdCartaDia); objCmpSql.AddParameter("@IdEmpSucursal", SqlDbType.SmallInt, ESGR_CartaDia.ESGR_EmpresaSucursal.IdEmpSucursal); objCmpSql.AddParameter("@Fecha", SqlDbType.SmallDateTime, ESGR_CartaDia.Fecha.Value.ToShortDateString()); objCmpSql.AddParameter("@DetalleXML", SqlDbType.NText, ESGR_CartaDia.DetalleXML); objCmpSql.ExecuteNonQuery(); } catch (Exception) { throw; } }
/// <summary> /// Lista de Carta Dia Detalle /// </summary> /// <returns>Colección de las Cartas Dia Detalle</returns> public CmpObservableCollection <ESGR_CartaDiaDetalle> GetCollectionCartaDiaDetalle(ESGR_CartaDia ESGR_CartaDia) { try { var objCmpSql = new CmpSql(SGRVariables.ConectionString); var CollectionCartaDiaDetalle = new CmpObservableCollection <ESGR_CartaDiaDetalle>(); objCmpSql.CommandProcedure("spSGR_GET_BusquedaGeneral"); objCmpSql.AddParameter("@Opcion", SqlDbType.VarChar, "FiltrarCartaDiaDetalle"); objCmpSql.AddParameter("@Filtro", SqlDbType.VarChar, ""); objCmpSql.AddParameter("@ParameterId", SqlDbType.Int, ESGR_CartaDia.IdCartaDia); DataTable dt = objCmpSql.ExecuteDataTable(); for (int x = 0; x < dt.Rows.Count; x++) { CollectionCartaDiaDetalle.Add(new ESGR_CartaDiaDetalle { IdCartaDia = (dt.Rows[x]["IdCartaDia"] != DBNull.Value) ? Convert.ToInt32(dt.Rows[x]["IdCartaDia"]) : 0, Item = (dt.Rows[x]["Item"] != DBNull.Value) ? Convert.ToInt16(dt.Rows[x]["Item"]) : Convert.ToInt16(0), Cantidad = (dt.Rows[x]["Cantidad"] != DBNull.Value) ? Convert.ToInt16(dt.Rows[x]["Cantidad"]) : Convert.ToInt16(0), TempCantidad = (dt.Rows[x]["Cantidad"] != DBNull.Value) ? Convert.ToInt16(dt.Rows[x]["Cantidad"]) : Convert.ToInt16(0), Precio = (dt.Rows[x]["Precio"] != DBNull.Value) ? Convert.ToDecimal(dt.Rows[x]["Precio"]) : 0, Stock = (dt.Rows[x]["Stock"] != DBNull.Value) ? Convert.ToInt16(dt.Rows[x]["Stock"]) : Convert.ToInt16(0), TempStock = (dt.Rows[x]["Stock"] != DBNull.Value) ? Convert.ToInt16(dt.Rows[x]["Stock"]) : Convert.ToInt16(0), Observacion = (dt.Rows[x]["Observacion"] != DBNull.Value) ? Convert.ToString(dt.Rows[x]["Observacion"]) : string.Empty, ESGR_CartaDia = new ESGR_CartaDia() { IdCartaDia = (dt.Rows[x]["IdCartaDia"] != DBNull.Value) ? Convert.ToInt16(dt.Rows[x]["IdCartaDia"]) : Convert.ToInt16(0), }, ESGR_Producto = new ESGR_Producto() { IdProducto = (dt.Rows[x]["IdProducto"] != DBNull.Value) ? Convert.ToInt16(dt.Rows[x]["IdProducto"]) : Convert.ToInt16(0), Producto = (dt.Rows[x]["Producto"] != DBNull.Value) ? Convert.ToString(dt.Rows[x]["Producto"]) : string.Empty, ESGR_ProductoSubCategoria = new ESGR_ProductoSubCategoria() { IdSubCategoria = (dt.Rows[x]["IdSubCategoria"] != DBNull.Value) ? Convert.ToInt32(dt.Rows[x]["IdSubCategoria"]) : 0, SubCategoria = (dt.Rows[x]["SubCategoria"] != DBNull.Value) ? Convert.ToString(dt.Rows[x]["SubCategoria"]) : string.Empty, ESGR_ProductoCategoria = new ESGR_ProductoCategoria() { IdCategoria = (dt.Rows[x]["IdCategoria"] != DBNull.Value) ? Convert.ToInt32(dt.Rows[x]["IdCategoria"]) : 0, Categoria = (dt.Rows[x]["Categoria"] != DBNull.Value) ? Convert.ToString(dt.Rows[x]["Categoria"]) : string.Empty, } } }, }); } return(CollectionCartaDiaDetalle); } catch (Exception) { throw; } }