/// <summary>
/// This Method is used to Delete data into tbl_Features table
/// </summary>
/// <param name="objFeatures">ID and Action</param>
/// <returns>1 for success and -1 for fail</returns>
public string DeleteFeatures(PropFeatures objFeatures, string userName)
{
if (userName != null && userName != "")
{
SqlCommand cmd = new SqlCommand("proc_subCategoryFeatures", objCon.Con);
cmd.CommandType = CommandType.StoredProcedure;
objCon.Con.Open();
try
{
cmd.Parameters.AddWithValue("@ID", objFeatures.ID);
cmd.Parameters.AddWithValue("@Action", "Delete");
return(cmd.ExecuteNonQuery().ToString());
}
catch (Exception showError)
{
throw showError;
}
finally
{
cmd.Dispose();
objCon.Con.Close();
objCon.Con.Dispose();
}
}
else
{
return("Not Valid");
}
}
/// <summary>
/// This Method is used to Select data from tbl_Features table
/// </summary>
/// <param name="objFeatures">Action</param>
/// <returns>1 for success and -1 for fail</returns>
public string SelectFeatures(PropFeatures objFeatures, string userName)
{
if (userName != null && userName != "")
{
SqlCommand cmd = new SqlCommand("proc_subCategoryFeatures", objCon.Con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Select");
cmd.Parameters.AddWithValue("@status", objFeatures.flag);
SqlDataAdapter adpt = new SqlDataAdapter();
DataSet ds = new DataSet();
if (objCon.Con.State == ConnectionState.Open)
{
}
else
{
objCon.Con.Open();
}
cmd.Connection = objCon.Con;
adpt.SelectCommand = cmd;
adpt.Fill(ds, "Features");
objCon.Con.Close();
return(ds.GetXml());
}
else
{
return("Not Valid");
}
}
public string SelectCatFeatures(int flag, int SubCategoryid)
{
string str = string.Empty;
PropFeatures propFeatures = new PropFeatures();
propFeatures.flag = flag;
propFeatures.SubCategory = SubCategoryid;
BllFeatures objFeatures = new BllFeatures();
str = objFeatures.subCategoryWiseSelect(propFeatures);
return(str);
}
public string SelectFeatures(int flag)
{
string str = string.Empty;
if (Session["admin"] != "" || Session["admin"].ToString() != null)
{
PropFeatures propFeatures = new PropFeatures();
propFeatures.flag = flag;
BllFeatures objFeatures = new BllFeatures();
str = objFeatures.RecordSelect(propFeatures, Session["admin"].ToString());
return(str);
}
else
{
return("Error in Authentication");
}
}
/// <summary>
/// This Method is used to Select data
/// </summary>
/// <param name="objCategory">Action</param>
/// <returns>1 for success and -1 for fail</returns>
public string RecordSelect(PropFeatures objProperty, string UserName)
{
DllFeatures objDal = new DllFeatures();
try
{
return(objDal.SelectFeatures(objProperty, UserName));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
/// <summary>
/// This Method is used to Select data
/// </summary>
/// <param name="objCategory">Action</param>
/// <returns>1 for success and -1 for fail</returns>
public string subCategoryWiseSelect(PropFeatures objProperty)
{
DllFeatures objDal = new DllFeatures();
try
{
return(objDal.SubCategorywiseFeatures(objProperty));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
public string InsertFeatures(int SubCategoryID, string Features)
{
string str = string.Empty;
if (Session["admin"] != "" || Session["admin"].ToString() != null)
{
PropFeatures proFeatures = new PropFeatures();
proFeatures.Features = Features;
proFeatures.SubCategory = SubCategoryID;
BllFeatures objFeatures = new BllFeatures();
str = objFeatures.RecordInsert(proFeatures, Session["admin"].ToString());
return(str);
}
else
{
return("Error in Authentication");
}
}
public string DeleteFeatures(int ID, int Status)
{
string str = string.Empty;
if (Session["admin"] != "" || Session["admin"].ToString() != null)
{
PropFeatures proFeatures = new PropFeatures();
proFeatures.ID = ID;
proFeatures.flag = Status;
BllFeatures objFeatures = new BllFeatures();
str = objFeatures.RecordDelete(proFeatures, Session["admin"].ToString());
return(str);
}
else
{
return("Error in Authentication");
}
}
public string UpdateFeatures(string Name, int ID, int SubCategoryID)
{
string str = string.Empty;
if (Session["admin"] != "" || Session["admin"].ToString() != null)
{
PropFeatures proFeatures = new PropFeatures();
proFeatures.Features = Name;
proFeatures.ID = ID;
proFeatures.SubCategory = SubCategoryID;
BllFeatures objFeatures = new BllFeatures();
str = objFeatures.RecordUpdate(proFeatures, Session["admin"].ToString());
return(str);
}
else
{
return("Error in Authentication");
}
}
/// <summary>
/// This Method is used to Select data from tbl_Features table
/// </summary>
/// <param name="objFeatures">Action</param>
/// <returns>1 for success and -1 for fail</returns>
public string SubCategorywiseFeatures(PropFeatures objFeatures)
{
SqlCommand cmd = new SqlCommand("proc_subCategoryFeatures", objCon.Con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Option");
cmd.Parameters.AddWithValue("@status", objFeatures.flag);
cmd.Parameters.AddWithValue("@SubCategoryId", objFeatures.SubCategory);
SqlDataAdapter adpt = new SqlDataAdapter();
DataSet ds = new DataSet();
if (objCon.Con.State == ConnectionState.Open)
{
}
else
{
objCon.Con.Open();
}
cmd.Connection = objCon.Con;
adpt.SelectCommand = cmd;
adpt.Fill(ds, "SubcategoryFeatures");
objCon.Con.Close();
return(ds.GetXml());
}
