private static SqlParameter[] SplitItemToParameter2(ClsKit ArtKit) { try { SqlParameter[] Parameters; Parameters = new SqlParameter[1]; if (ArtKit.IdArticulo != 0) { Parameters[0] = new SqlParameter(); Parameters[0].Direction = ParameterDirection.Input; Parameters[0].SqlDbType = SqlDbType.Int; Parameters[0].ParameterName = "@IdArticulo"; Parameters[0].Value = ArtKit.IdArticulo; } if (ArtKit.IdArticulo == 0) { Parameters[0] = new SqlParameter(); Parameters[0].Direction = ParameterDirection.Input; Parameters[0].SqlDbType = SqlDbType.Int; Parameters[0].ParameterName = "@IdArticulo"; Parameters[0].Value = null; } return(Parameters); } catch (Exception EX) { throw new Exception(EX.Message, EX.InnerException); } }
//Agrega los articulos que pertenecen al KIT private static SqlParameter[] SplitItemToParamArti_Kit(ClsKit Kit, int Opcion, int IdKit) { try { SqlParameter[] Parameters; Parameters = new SqlParameter[2]; Parameters[0] = new SqlParameter(); Parameters[0].Direction = ParameterDirection.Input; Parameters[0].SqlDbType = SqlDbType.Int; Parameters[0].ParameterName = "@Opcion"; Parameters[0].Value = Opcion; Parameters[1] = new SqlParameter(); Parameters[1].Direction = ParameterDirection.Input; Parameters[1].SqlDbType = SqlDbType.Int; Parameters[1].ParameterName = "@IdKit"; Parameters[1].Value = IdKit; return(Parameters); } catch (Exception EX) { throw new Exception(EX.Message, EX.InnerException); } }
//Inserto los Articulos del Kit public static void AddArti_Kit(ClsKit Kit, int Opcion, int IdKit) { try { Data DataAccess = new Data(System.Configuration.ConfigurationManager.ConnectionStrings["SISCOC_FEL.Properties.Settings.SISCOC_CON"].ToString()); DataAccess.ExecuteSPNonQuery(SplitItemToParamArti_Kit(Kit, Opcion, IdKit), "Sp_Insert_Kit"); DataAccess.CloseConnection(); } catch (Exception EX) { throw new Exception(EX.Message, EX.InnerException); } }
//Borra los registros de la tabla de paso. public static void DeleteartKit(ClsKit ArtKit) { try { Data DataAccess = new Data(System.Configuration.ConfigurationManager.ConnectionStrings["SISCOC_FEL.Properties.Settings.SISCOC_CON"].ToString()); DataAccess.ExecuteSPNonQuery(SplitItemToParameter2(ArtKit), "Sp_Delete_TempKitArticulo"); DataAccess.CloseConnection(); } catch (Exception EX) { throw new Exception(EX.Message, EX.InnerException); } }
//Regresa el numero del Kit y el Nombre del Kit private static ClsKit FillKit(DataRow Row) { ClsKit Kit = new ClsKit(); try { Kit.IdKit = Convert.ToInt32(Row["IdKit"]); Kit.NomKit = Convert.ToString(Row["Kit"]); Kit.PrecioU = Convert.ToDouble(Row["PrecioU"]); return(Kit); } catch (Exception EX) { throw new Exception(EX.Message, EX.InnerException); } }
//Regresa los Articulos. private static ClsKit FillArtKit(DataRow Row) { ClsKit ArtiKit = new ClsKit(); try { ArtiKit.IdArticulo = Convert.ToInt32(Row["IdArticulo"]); ArtiKit.Articulo = Convert.ToString(Row["Articulo"]); ArtiKit.Descripcion = Convert.ToString(Row["Descripcion"]); ArtiKit.PrecioU = Convert.ToDouble(Row["PrecioU"]); ArtiKit.Cantidad = Convert.ToDouble(Row["Cantidad"]); return(ArtiKit); } catch (Exception EX) { throw new Exception(EX.Message, EX.InnerException); } }
private static SqlParameter[] SplitItemToParameter(ClsKit ArtKit, int Opcion, int IdKit) { try { SqlParameter[] Parameters; Parameters = new SqlParameter[7]; Parameters[0] = new SqlParameter(); Parameters[0].Direction = ParameterDirection.Input; Parameters[0].SqlDbType = SqlDbType.Int; Parameters[0].ParameterName = "@IdArticulo"; Parameters[0].Value = ArtKit.IdArticulo; Parameters[1] = new SqlParameter(); Parameters[1].Direction = ParameterDirection.Input; Parameters[1].SqlDbType = SqlDbType.VarChar; Parameters[1].ParameterName = "@Articulo"; Parameters[1].Value = ArtKit.Articulo; Parameters[2] = new SqlParameter(); Parameters[2].Direction = ParameterDirection.Input; Parameters[2].SqlDbType = SqlDbType.VarChar; Parameters[2].ParameterName = "@Descripcion"; Parameters[2].Value = ArtKit.Descripcion; Parameters[3] = new SqlParameter(); Parameters[3].Direction = ParameterDirection.Input; Parameters[3].SqlDbType = SqlDbType.Decimal; Parameters[3].ParameterName = "@Cantidad"; Parameters[3].Value = ArtKit.Cantidad; Parameters[4] = new SqlParameter(); Parameters[4].Direction = ParameterDirection.Input; Parameters[4].SqlDbType = SqlDbType.Decimal; Parameters[4].ParameterName = "@PrecioU"; Parameters[4].Value = ArtKit.PrecioU; Parameters[5] = new SqlParameter(); Parameters[5].Direction = ParameterDirection.Input; Parameters[5].SqlDbType = SqlDbType.Int; Parameters[5].ParameterName = "@Opcion"; Parameters[5].Value = Opcion; if (Opcion > 1) { Parameters[6] = new SqlParameter(); Parameters[6].Direction = ParameterDirection.Input; Parameters[6].SqlDbType = SqlDbType.Int; Parameters[6].ParameterName = "@IdKit"; Parameters[6].Value = IdKit; } if (Opcion <= 1) { Parameters[6] = new SqlParameter(); Parameters[6].Direction = ParameterDirection.Input; Parameters[6].SqlDbType = SqlDbType.Int; Parameters[6].ParameterName = "@IdKit"; Parameters[6].Value = IdKit; } return(Parameters); } catch (Exception EX) { throw new Exception(EX.Message, EX.InnerException); } }