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