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