//----------------------------------------------------------------
/// Insert record: Marker
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand( "InsertMarker");
_db.AddOutParameter(_dbCommand, ds.Marker.Marker_IDColumn.ToString(), DbType.Int32,20);
_db.AddInParameter(_dbCommand, ds.Marker.Marker_TagColumn.ToString(), DbType.String,ds.Marker.Rows[0][ds.Marker.Marker_TagColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.AddressColumn.ToString(), DbType.String,ds.Marker.Rows[0][ds.Marker.AddressColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.CityColumn.ToString(), DbType.String,ds.Marker.Rows[0][ds.Marker.CityColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.StateColumn.ToString(), DbType.String,ds.Marker.Rows[0][ds.Marker.StateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.CountryColumn.ToString(), DbType.String,ds.Marker.Rows[0][ds.Marker.CountryColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.LatitudeColumn.ToString(), DbType.Decimal,ds.Marker.Rows[0][ds.Marker.LatitudeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.LongitudeColumn.ToString(), DbType.Decimal,ds.Marker.Rows[0][ds.Marker.LongitudeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Is_Recurring_EventColumn.ToString(), DbType.Boolean,ds.Marker.Rows[0][ds.Marker.Is_Recurring_EventColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Daily_CountColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Daily_CountColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Monthly_CountColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Monthly_CountColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Yearly_CountColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Yearly_CountColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Daily_Count_TrendColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Daily_Count_TrendColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Monthly_Count_TrendColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Monthly_Count_TrendColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Yearly_Count_TrendColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Yearly_Count_TrendColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Daily_Count_PercentageColumn.ToString(), DbType.Decimal,ds.Marker.Rows[0][ds.Marker.Current_Daily_Count_PercentageColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Yearly_Count_Trend_PercentageColumn.ToString(), DbType.Decimal,ds.Marker.Rows[0][ds.Marker.Current_Yearly_Count_Trend_PercentageColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Monthly_Count_Trend_PercentageColumn.ToString(), DbType.Decimal,ds.Marker.Rows[0][ds.Marker.Current_Monthly_Count_Trend_PercentageColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Daily_RankColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Daily_RankColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Monthly_RankColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Monthly_RankColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Yearly_RankColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Yearly_RankColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Daily_Rank_TrendColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Daily_Rank_TrendColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Monthly_Rank_TrendColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Monthly_Rank_TrendColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Yearly_Rank_TrendColumn.ToString(), DbType.Int32,ds.Marker.Rows[0][ds.Marker.Current_Yearly_Rank_TrendColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Daily_Rank_Trend_PercentageColumn.ToString(), DbType.Decimal,ds.Marker.Rows[0][ds.Marker.Current_Daily_Rank_Trend_PercentageColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Monthly_Rank_Trend_PercentageColumn.ToString(), DbType.Decimal,ds.Marker.Rows[0][ds.Marker.Current_Monthly_Rank_Trend_PercentageColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Marker.Current_Yearly_Rank_Trend_PercentageColumn.ToString(), DbType.Decimal,ds.Marker.Rows[0][ds.Marker.Current_Yearly_Rank_Trend_PercentageColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
_ID = System.Int32.Parse( _db.GetParameterValue(_dbCommand, "@Marker_ID").ToString() );
return dr;
}
//----------------------------------------------------------------
/// Insert record: Marker_Type
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand("InsertMarker_Type");
_db.AddInParameter(_dbCommand, ds.Marker_Type.Marker_TypeColumn.ToString(), DbType.String, ds.Marker_Type.Rows[0][ds.Marker_Type.Marker_TypeColumn.ToString()]);
IDataReader dr = _db.ExecuteReader(_dbCommand, _transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Insert record: Event_Item
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand("InsertEvent_Item");
_db.AddInParameter(_dbCommand, ds.Event_Item.Event_Item_IDColumn.ToString(), DbType.Int32, ds.Event_Item.Rows[0][ds.Event_Item.Event_Item_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Item.Event_IDColumn.ToString(), DbType.Int32, ds.Event_Item.Rows[0][ds.Event_Item.Event_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Item.Event_ItemColumn.ToString(), DbType.String, ds.Event_Item.Rows[0][ds.Event_Item.Event_ItemColumn.ToString()]);
IDataReader dr = _db.ExecuteReader(_dbCommand, _transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Insert record: Company_Product_Type
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand( "InsertCompany_Product_Type");
_db.AddInParameter(_dbCommand, ds.Company_Product_Type.Company_IDColumn.ToString(), DbType.Int32,ds.Company_Product_Type.Rows[0][ds.Company_Product_Type.Company_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Company_Product_Type.Product_Type_IDColumn.ToString(), DbType.Int32,ds.Company_Product_Type.Rows[0][ds.Company_Product_Type.Product_Type_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Company_Product_Type.Category_IDColumn.ToString(), DbType.Int32,ds.Company_Product_Type.Rows[0][ds.Company_Product_Type.Category_IDColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Insert record: Company
//----------------------------------------------------------------
public override IDataReader Insert( DSParameter ds )
{
_dbCommand = _db.GetStoredProcCommand( "InsertCompany");
_db.AddOutParameter(_dbCommand, ds.Company.Company_IDColumn.ToString(), DbType.Int32,20);
_db.AddInParameter(_dbCommand, ds.Company.CompanyColumn.ToString(), DbType.String,ds.Company.Rows[0][ds.Company.CompanyColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
_ID = System.Int32.Parse( _db.GetParameterValue(_dbCommand, "@Company_ID").ToString() );
return dr;
}
//----------------------------------------------------------------
/// Insert record: Activity_Type
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds )
{
_dbCommand = _db.GetStoredProcCommand( "InsertActivity_Type");
_db.AddOutParameter(_dbCommand, ds.Activity_Type.Activity_Type_IDColumn.ToString(), DbType.Int32, 20);
_db.AddInParameter(_dbCommand, ds.Activity_Type.Activity_TypeColumn.ToString(), DbType.String,ds.Activity_Type.Rows[0][ds.Activity_Type.Activity_TypeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Activity_Type.Has_IDColumn.ToString(), DbType.Boolean,ds.Activity_Type.Rows[0][ds.Activity_Type.Has_IDColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
_ID = Int32.Parse(_db.GetParameterValue(_dbCommand, "@Activity_Type_ID").ToString());
return dr;
}
//----------------------------------------------------------------
/// Insert record: Connotation_Keyword
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds )
{
_dbCommand = _db.GetStoredProcCommand( "InsertConnotation_Keyword");
_db.AddInParameter(_dbCommand, ds.Connotation_Keyword.DayColumn.ToString(), DbType.Int32,ds.Connotation_Keyword.Rows[0][ds.Connotation_Keyword.DayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Connotation_Keyword.MonthColumn.ToString(), DbType.Int32,ds.Connotation_Keyword.Rows[0][ds.Connotation_Keyword.MonthColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Connotation_Keyword.YearColumn.ToString(), DbType.Int32,ds.Connotation_Keyword.Rows[0][ds.Connotation_Keyword.YearColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Connotation_Keyword.Marker_Connotation_IDColumn.ToString(), DbType.Int32,ds.Connotation_Keyword.Rows[0][ds.Connotation_Keyword.Marker_Connotation_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Connotation_Keyword.Source_IDColumn.ToString(), DbType.Int32,ds.Connotation_Keyword.Rows[0][ds.Connotation_Keyword.Source_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Connotation_Keyword.DateColumn.ToString(), DbType.DateTime,ds.Connotation_Keyword.Rows[0][ds.Connotation_Keyword.DateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Connotation_Keyword.MentionColumn.ToString(), DbType.Int32,ds.Connotation_Keyword.Rows[0][ds.Connotation_Keyword.MentionColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Insert record: Event_Marker
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand( "InsertEvent_Marker");
_db.AddOutParameter(_dbCommand, ds.Event_Marker.Event_Marker_IDColumn.ToString(), DbType.Int32,20);
_db.AddInParameter(_dbCommand, ds.Event_Marker.Marker_IDColumn.ToString(), DbType.Int32,ds.Event_Marker.Rows[0][ds.Event_Marker.Marker_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Marker.Period_In_DaysColumn.ToString(), DbType.Int32,ds.Event_Marker.Rows[0][ds.Event_Marker.Period_In_DaysColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Marker.Start_DateColumn.ToString(), DbType.DateTime,ds.Event_Marker.Rows[0][ds.Event_Marker.Start_DateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Marker.Start_YearColumn.ToString(), DbType.Int32,ds.Event_Marker.Rows[0][ds.Event_Marker.Start_YearColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Marker.End_YearColumn.ToString(), DbType.Int32,ds.Event_Marker.Rows[0][ds.Event_Marker.End_YearColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
_ID = System.Int32.Parse( _db.GetParameterValue(_dbCommand, "@Event_Marker_ID").ToString() );
return dr;
}
//----------------------------------------------------------------
/// Insert record: Event
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand("InsertEvent");
_db.AddOutParameter(_dbCommand, ds.Event.Event_IDColumn.ToString(), DbType.Int32, 20);
_db.AddInParameter(_dbCommand, ds.Event.EventColumn.ToString(), DbType.String, ds.Event.Rows[0][ds.Event.EventColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event.Has_Event_ItemColumn.ToString(), DbType.Boolean, ds.Event.Rows[0][ds.Event.Has_Event_ItemColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event.DateColumn.ToString(), DbType.DateTime, ds.Event.Rows[0][ds.Event.DateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event.LatitudeColumn.ToString(), DbType.Decimal, ds.Event.Rows[0][ds.Event.LatitudeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event.LongitudeColumn.ToString(), DbType.Decimal, ds.Event.Rows[0][ds.Event.LongitudeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event.Company_IDColumn.ToString(), DbType.Int32, ds.Event.Rows[0][ds.Event.Company_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event.Event_DaysColumn.ToString(), DbType.Int32, ds.Event.Rows[0][ds.Event.Event_DaysColumn.ToString()]);
IDataReader dr = _db.ExecuteReader(_dbCommand, _transaction);
dr.Close();
_ID = Int32.Parse(_db.GetParameterValue(_dbCommand, "@Event_ID").ToString());
return dr;
}
public DSParameter GetParamerter()
{
//DataSet ds = new DataSet();
DSParameter ds = new DSParameter();
_base = new DataAccessLayer.Marker.Marker();
_base.SetConnection();
_db = _base.GetDatabase();
ds.EnforceConstraints = false;
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Marker);
_base.Dispose();
return ds;
}
public abstract IDataReader Update(DSParameter ds);
//----------------------------------------------------------------
/// Update: Event_Marker
//----------------------------------------------------------------
public override IDataReader Update(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand( "UpdateEvent_Marker");
_db.AddInParameter(_dbCommand, ds.Event_Marker.Event_Marker_IDColumn.ToString(), DbType.Int32,ds.Event_Marker.Rows[0][ds.Event_Marker.Event_Marker_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Marker.Marker_IDColumn.ToString(), DbType.Int32,ds.Event_Marker.Rows[0][ds.Event_Marker.Marker_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Marker.Period_In_DaysColumn.ToString(), DbType.Int32,ds.Event_Marker.Rows[0][ds.Event_Marker.Period_In_DaysColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Marker.Start_DateColumn.ToString(), DbType.DateTime,ds.Event_Marker.Rows[0][ds.Event_Marker.Start_DateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Marker.Start_YearColumn.ToString(), DbType.Int32,ds.Event_Marker.Rows[0][ds.Event_Marker.Start_YearColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Event_Marker.End_YearColumn.ToString(), DbType.Int32,ds.Event_Marker.Rows[0][ds.Event_Marker.End_YearColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
public DSParameter GetParamerter()
{
//DataSet ds = new DataSet();
DSParameter ds = new DSParameter();
_base = new DataAccessLayer.Attribute.Attribute();
_base.SetConnection();
_db = _base.GetDatabase();
ds.EnforceConstraints = false;
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Attribute);
_base = new DataAccessLayer.Attribute.Attribute_Variant(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Attribute_Variant);
_base = new DataAccessLayer.Attribute.Product_Type_Attribute(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Product_Type_Attribute);
_base = new DataAccessLayer.Distributor.Distributor(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Distributor);
_base = new DataAccessLayer.Parameter.Category(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Category);
_base = new DataAccessLayer.Parameter.Company(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Company);
_base = new DataAccessLayer.Parameter.Company_Product_Type(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Company_Product_Type);
_base = new DataAccessLayer.Parameter.Product_Attribute(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Product_Attribute);
_base = new DataAccessLayer.Parameter.Product_Type_Attribute(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Product_Type_Attribute);
_base = new DataAccessLayer.Product.Product(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Product);
_base = new DataAccessLayer.Product_Distributor(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Product_Distributor);
_base = new DataAccessLayer.Product_Type.Product_Type(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Product_Type);
_base = new DataAccessLayer.Product_Type_Attribute(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Product_Type_Attribute);
_base = new DataAccessLayer.Product_Type_Relationship(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Product_Type_Relationship);
_base = new DataAccessLayer.Activity.Activity_Type(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Activity_Type);
_base = new DataAccessLayer.Event.Event(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Event);
_base = new DataAccessLayer.Event.Event_Item(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Event_Item);
_base = new DataAccessLayer.Parameter.Secret_Question(_db);
ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Secret_Question);
//_base = new DataAccessLayer.Customer.Customer(_db);
//ds.Load(_base.GetAllItem(), LoadOption.OverwriteChanges, ds.Customer);
_base.Dispose();
return ds;
}
//----------------------------------------------------------------
/// Insert record: Customer
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand("InsertCustomer");
_db.AddOutParameter(_dbCommand, ds.Customer.IDColumn.ToString(), DbType.Int32, 20);
_db.AddInParameter(_dbCommand, ds.Customer.Is_ActiveColumn.ToString(), DbType.Boolean, ds.Customer.Rows[0][ds.Customer.Is_ActiveColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Customer_IDColumn.ToString(), DbType.Int32, ds.Customer.Rows[0][ds.Customer.Customer_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.CustomerColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.CustomerColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.CityColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.CityColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.StateColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.StateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.AddressColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.AddressColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.LatitudeColumn.ToString(), DbType.Decimal, ds.Customer.Rows[0][ds.Customer.LatitudeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.LongitudeColumn.ToString(), DbType.Decimal, ds.Customer.Rows[0][ds.Customer.LongitudeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.EmailColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.EmailColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Zip_CodeColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.Zip_CodeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.BuildingAppartmentColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.BuildingAppartmentColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Street_NoColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.Street_NoColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Street_NameColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.Street_NameColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.CountryColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.CountryColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Phone1Column.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.Phone1Column.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Phone2Column.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.Phone2Column.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Email2Column.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.Email2Column.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.WebsiteColumn.ToString(), DbType.String, ds.Customer.Rows[0][ds.Customer.WebsiteColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Is_Email1_DisplayColumn.ToString(), DbType.Boolean, ds.Customer.Rows[0][ds.Customer.Is_Email1_DisplayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Is_Email2_DisplayColumn.ToString(), DbType.Boolean, ds.Customer.Rows[0][ds.Customer.Is_Email2_DisplayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Is_Phone1_DisplayColumn.ToString(), DbType.Boolean, ds.Customer.Rows[0][ds.Customer.Is_Phone1_DisplayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Is_Phone2_DisplayColumn.ToString(), DbType.Boolean, ds.Customer.Rows[0][ds.Customer.Is_Phone2_DisplayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Customer.Is_Website_DisplayColumn.ToString(), DbType.Boolean, ds.Customer.Rows[0][ds.Customer.Is_Website_DisplayColumn.ToString()]);
IDataReader dr = _db.ExecuteReader(_dbCommand, _transaction);
dr.Close();
_ID = System.Int32.Parse(_db.GetParameterValue(_dbCommand, "@ID").ToString());
return dr;
}
//----------------------------------------------------------------
/// Insert record: Product
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds )
{
_dbCommand = _db.GetStoredProcCommand( "InsertProduct");
_db.AddOutParameter(_dbCommand, ds.Product.Product_IDColumn.ToString(), DbType.Int32,20);
_db.AddInParameter(_dbCommand, ds.Product.ProductColumn.ToString(), DbType.String,ds.Product.Rows[0][ds.Product.ProductColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Product_Code_To_DisplayColumn.ToString(), DbType.String,ds.Product.Rows[0][ds.Product.Product_Code_To_DisplayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Product_CodeColumn.ToString(), DbType.String,ds.Product.Rows[0][ds.Product.Product_CodeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Company_IDColumn.ToString(), DbType.Int32,ds.Product.Rows[0][ds.Product.Company_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Product_Type_IDColumn.ToString(), DbType.Int32,ds.Product.Rows[0][ds.Product.Product_Type_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Category_IDColumn.ToString(), DbType.Int32,ds.Product.Rows[0][ds.Product.Category_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Entered_DateColumn.ToString(), DbType.DateTime,ds.Product.Rows[0][ds.Product.Entered_DateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.DescriptionColumn.ToString(), DbType.String,ds.Product.Rows[0][ds.Product.DescriptionColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Is_ActiveColumn.ToString(), DbType.Boolean,ds.Product.Rows[0][ds.Product.Is_ActiveColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Product_Image_LinkColumn.ToString(), DbType.String,ds.Product.Rows[0][ds.Product.Product_Image_LinkColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Product_Brand_Image_LinkColumn.ToString(), DbType.String,ds.Product.Rows[0][ds.Product.Product_Brand_Image_LinkColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Product_HeadingColumn.ToString(), DbType.String,ds.Product.Rows[0][ds.Product.Product_HeadingColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product.Heading_LinkColumn.ToString(), DbType.String,ds.Product.Rows[0][ds.Product.Heading_LinkColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
_ID = System.Int32.Parse( _db.GetParameterValue(_dbCommand, "@Product_ID").ToString() );
return dr;
}
//----------------------------------------------------------------
/// Update: Product_Type
//----------------------------------------------------------------
public override IDataReader Update(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand( "UpdateProduct_Type");
_db.AddInParameter(_dbCommand, ds.Product_Type.Product_Type_IDColumn.ToString(), DbType.Int32,ds.Product_Type.Rows[0][ds.Product_Type.Product_Type_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product_Type.Product_TypeColumn.ToString(), DbType.String,ds.Product_Type.Rows[0][ds.Product_Type.Product_TypeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product_Type.Category_IDColumn.ToString(), DbType.Int32,ds.Product_Type.Rows[0][ds.Product_Type.Category_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product_Type.Entered_DateColumn.ToString(), DbType.DateTime,ds.Product_Type.Rows[0][ds.Product_Type.Entered_DateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product_Type.DescriptionColumn.ToString(), DbType.String,ds.Product_Type.Rows[0][ds.Product_Type.DescriptionColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product_Type.Is_ActiveColumn.ToString(), DbType.Boolean,ds.Product_Type.Rows[0][ds.Product_Type.Is_ActiveColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Update: Activity_Type
//----------------------------------------------------------------
public override IDataReader Update( DSParameter ds )
{
_dbCommand = _db.GetStoredProcCommand( "UpdateActivity_Type");
_db.AddInParameter(_dbCommand, ds.Activity_Type.Activity_Type_IDColumn.ToString(), DbType.Int32, ds.Activity_Type.Rows[0][ds.Activity_Type.Activity_Type_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Activity_Type.Activity_TypeColumn.ToString(), DbType.String,ds.Activity_Type.Rows[0][ds.Activity_Type.Activity_TypeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Activity_Type.Has_IDColumn.ToString(), DbType.Boolean,ds.Activity_Type.Rows[0][ds.Activity_Type.Has_IDColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Insert record: ZipCodes
//----------------------------------------------------------------
public override IDataReader Insert( DSParameter ds )
{
_dbCommand = _db.GetStoredProcCommand( "InsertZipCodes");
_db.AddInParameter(_dbCommand, ds.ZipCodes.CountryColumn.ToString(), DbType.String,ds.ZipCodes.Rows[0][ds.ZipCodes.CountryColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.ZipCodes.ZipCodeColumn.ToString(), DbType.String,ds.ZipCodes.Rows[0][ds.ZipCodes.ZipCodeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.ZipCodes.CityColumn.ToString(), DbType.String,ds.ZipCodes.Rows[0][ds.ZipCodes.CityColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.ZipCodes.STATEColumn.ToString(), DbType.String,ds.ZipCodes.Rows[0][ds.ZipCodes.STATEColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.ZipCodes.StateAbbreviationColumn.ToString(), DbType.String,ds.ZipCodes.Rows[0][ds.ZipCodes.StateAbbreviationColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.ZipCodes.CountyColumn.ToString(), DbType.String,ds.ZipCodes.Rows[0][ds.ZipCodes.CountyColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.ZipCodes.LatitudeColumn.ToString(), DbType.Decimal,ds.ZipCodes.Rows[0][ds.ZipCodes.LatitudeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.ZipCodes.LongitudeColumn.ToString(), DbType.Decimal,ds.ZipCodes.Rows[0][ds.ZipCodes.LongitudeColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Update: Product_Attribute
//----------------------------------------------------------------
public override IDataReader Update( DSParameter ds )
{
_dbCommand = _db.GetStoredProcCommand( "UpdateProduct_Attribute");
_db.AddInParameter(_dbCommand, ds.Product_Attribute.Product_IDColumn.ToString(), DbType.Int32,ds.Product_Attribute.Rows[0][ds.Product_Attribute.Product_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product_Attribute.Attribute_IDColumn.ToString(), DbType.Int32,ds.Product_Attribute.Rows[0][ds.Product_Attribute.Attribute_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product_Attribute.Attribute_Variant_IDColumn.ToString(), DbType.Int32,ds.Product_Attribute.Rows[0][ds.Product_Attribute.Attribute_Variant_IDColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Update: Distributor
//----------------------------------------------------------------
public override IDataReader Update(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand( "UpdateDistributor");
_db.AddInParameter(_dbCommand, ds.Distributor.IDColumn.ToString(), DbType.Int32,ds.Distributor.Rows[0][ds.Distributor.IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Is_ActiveColumn.ToString(), DbType.Boolean,ds.Distributor.Rows[0][ds.Distributor.Is_ActiveColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Distributor_IDColumn.ToString(), DbType.Int32,ds.Distributor.Rows[0][ds.Distributor.Distributor_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.DistributorColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.DistributorColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.CityColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.CityColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.StateColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.StateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.AddressColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.AddressColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.LatitudeColumn.ToString(), DbType.Decimal,ds.Distributor.Rows[0][ds.Distributor.LatitudeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.LongitudeColumn.ToString(), DbType.Decimal,ds.Distributor.Rows[0][ds.Distributor.LongitudeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.EmailColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.EmailColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Zip_CodeColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.Zip_CodeColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.BuildingAppartmentColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.BuildingAppartmentColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Street_NoColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.Street_NoColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Street_NameColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.Street_NameColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.CountryColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.CountryColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Phone1Column.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.Phone1Column.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Phone2Column.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.Phone2Column.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Email2Column.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.Email2Column.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.WebsiteColumn.ToString(), DbType.String,ds.Distributor.Rows[0][ds.Distributor.WebsiteColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Is_Email1_DisplayColumn.ToString(), DbType.Boolean,ds.Distributor.Rows[0][ds.Distributor.Is_Email1_DisplayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Is_Email2_DisplayColumn.ToString(), DbType.Boolean,ds.Distributor.Rows[0][ds.Distributor.Is_Email2_DisplayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Is_Phone1_DisplayColumn.ToString(), DbType.Boolean,ds.Distributor.Rows[0][ds.Distributor.Is_Phone1_DisplayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Is_Phone2_DisplayColumn.ToString(), DbType.Boolean,ds.Distributor.Rows[0][ds.Distributor.Is_Phone2_DisplayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Distributor.Is_Website_DisplayColumn.ToString(), DbType.Boolean,ds.Distributor.Rows[0][ds.Distributor.Is_Website_DisplayColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
public abstract IDataReader Insert(DSParameter ds);
protected BaseParameter()
: base()
{
_DSParam = new DSParameter();
}
//----------------------------------------------------------------
/// Update: Keyword
//----------------------------------------------------------------
public override IDataReader Update(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand( "UpdateKeyword");
_db.AddInParameter(_dbCommand, ds.Keyword.DayColumn.ToString(), DbType.Int32, ds.Keyword.Rows[_index][ds.Keyword.DayColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Keyword.MonthColumn.ToString(), DbType.Int32, ds.Keyword.Rows[_index][ds.Keyword.MonthColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Keyword.YearColumn.ToString(), DbType.Int32, ds.Keyword.Rows[_index][ds.Keyword.YearColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Keyword.Source_IDColumn.ToString(), DbType.Int32, ds.Keyword.Rows[_index][ds.Keyword.Source_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Keyword.Marker_IDColumn.ToString(), DbType.Int32, ds.Keyword.Rows[_index][ds.Keyword.Marker_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Keyword.Count_Type_IDColumn.ToString(), DbType.Int32, ds.Keyword.Rows[_index][ds.Keyword.Count_Type_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Keyword.Rank_Type_IDColumn.ToString(), DbType.Int32, ds.Keyword.Rows[_index][ds.Keyword.Rank_Type_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Keyword.DateColumn.ToString(), DbType.DateTime, ds.Keyword.Rows[_index][ds.Keyword.DateColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Keyword.MentionColumn.ToString(), DbType.Int32, ds.Keyword.Rows[_index][ds.Keyword.MentionColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Keyword.RankColumn.ToString(), DbType.Int32, ds.Keyword.Rows[_index][ds.Keyword.RankColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Update: Company
//----------------------------------------------------------------
public override IDataReader Update(DSParameter ds)
{
_dbCommand = _db.GetStoredProcCommand( "UpdateCompany");
_db.AddInParameter(_dbCommand, ds.Company.Company_IDColumn.ToString(), DbType.Int32,ds.Company.Rows[0][ds.Company.Company_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Company.CompanyColumn.ToString(), DbType.String,ds.Company.Rows[0][ds.Company.CompanyColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
//----------------------------------------------------------------
/// Insert record: Product_Distributor
//----------------------------------------------------------------
public override IDataReader Insert(DSParameter ds )
{
_dbCommand = _db.GetStoredProcCommand( "InsertProduct_Distributor");
_db.AddInParameter(_dbCommand, ds.Product_Distributor.Product_IDColumn.ToString(), DbType.Int32,ds.Product_Distributor.Rows[0][ds.Product_Distributor.Product_IDColumn.ToString()]);
_db.AddInParameter(_dbCommand, ds.Product_Distributor.Distributor_IDColumn.ToString(), DbType.Int32,ds.Product_Distributor.Rows[0][ds.Product_Distributor.Distributor_IDColumn.ToString()]);
IDataReader dr = _db.ExecuteReader( _dbCommand,_transaction);
dr.Close();
return dr;
}
