//--------------------------------- public void addFeatureB(FeatureBrands FeatB) { try { Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = DataBase; //Procedure Name. cmd.CommandText = "Add_FeaturedBrands"; cmd.CommandType = CommandType.StoredProcedure; //Procedure Parameters. cmd.Parameters.Add("@SiteId", SqlDbType.Int); cmd.Parameters.Add("@ContId", SqlDbType.Int); cmd.Parameters.Add("@TitleID", SqlDbType.Int); cmd.Parameters.Add("@FeatFile", SqlDbType.VarChar, 250, "FeatFile"); cmd.Parameters.Add("@FeatOrdPos", SqlDbType.Int); cmd.Parameters.Add("@FeatState", SqlDbType.Bit); //Setting values to Parameters. cmd.Parameters[0].Value = FeatB.intSiteId; cmd.Parameters[1].Value = FeatB.intContId; cmd.Parameters[2].Value = FeatB.intTitleID; cmd.Parameters[3].Value = FeatB.strFeatFile; cmd.Parameters[4].Value = FeatB.intFeatOrdPos; cmd.Parameters[5].Value = FeatB.blFeatState; cmd.ExecuteNonQuery(); Close(); } catch (SqlException oSqlExp) { //Console.WriteLine("" + oSqlExp.Message); } catch (Exception oEx) { //Console.WriteLine("" + oEx.Message); } }
//--------------------------------- protected string updateFeatureBrands(FeatureBrands FeatB) { SqlCommand cmd = new SqlCommand(); cmd.Connection = DataBase; //Procedure Name. cmd.CommandText = "Upd_FeaturedBrands"; cmd.CommandType = CommandType.StoredProcedure; //Procedure Parameters. cmd.Parameters.Add("@SiteId", SqlDbType.Int); cmd.Parameters.Add("@ContId", SqlDbType.Int); cmd.Parameters.Add("@TitleID", SqlDbType.VarChar, 250, "FeatTitle"); cmd.Parameters.Add("@FeatOrdPos", SqlDbType.VarChar, 250, "FeatFile"); cmd.Parameters.Add("@FeatState", SqlDbType.VarChar, 250, "FeatLink"); //Setting values to Parameters. cmd.Parameters[0].Value = FeatB.intSiteId; cmd.Parameters[1].Value = FeatB.intContId; cmd.Parameters[3].Value = FeatB.intTitleID; cmd.Parameters[4].Value = FeatB.intFeatOrdPos; cmd.Parameters[5].Value = FeatB.blFeatState; string ids = ""; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ids = dr["id"].ToString(); } } dr.Close(); dr.Dispose(); return ids; }
public DataSet getbrandTitle(int title) { FeatureBrands feat = new FeatureBrands(); return feat.getFeatureBrandsById(title); }
//------------------------------------------------------------ private void SaveFeatureProducts(int count) { string vsub; int isub; string search = Convert.ToString(Request["txtPosition"]); if (validationpos(search) == true ) { for (int i = 0; i <= count; i++) { vsub = Request["chk" + i]; isub = Convert.ToInt32(vsub); if (vsub != null ) { if (validateId(isub) == false) { FeatureBrands feat = new FeatureBrands(Convert.ToInt32(Session["siteId"]), Convert.ToInt32(Session["contId"]), isub,hidePath.Value,Convert.ToInt32(search), true); addFeatureB(feat); Response.Redirect("mnt_FeaturedBrands.aspx"); } else { lbPositionError.Text = "**This product is already feature product**"; lbPositionError.Visible = true; } } } } else { lbPositionError.Text = "**"+search+"is an invalid position**"; lbPositionError.Visible = true; } }
public DataSet getallFeaturebrands(int siteid, int contid) { FeatureBrands feat = new FeatureBrands(); return feat.getAllFeatureBrands(siteid, contid); }