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