public string Category_Update(Category_Class obj)
{
if (obj.Active == "True")
{
obj.Active = "1";
}
else
{
obj.Active = "0";
}
SqlConnection con = new SqlConnection(objCon.ConnectionReturn());
SqlCommand cmd = new SqlCommand("Category_Update", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CategoryId", obj.CategoryId);
cmd.Parameters.AddWithValue("@CategoryName", obj.CategoryName);
cmd.Parameters.AddWithValue("@SearchKeyword", obj.SearchKeyword);
cmd.Parameters.AddWithValue("@MetaDescription", obj.MetaDescription);
//cmd.Parameters.AddWithValue("@SequenceNo", obj.SequenceNo);
cmd.Parameters.AddWithValue("@Active", obj.Active);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
string Return = "Data Update";
return(Return);
}
public string Category_Insert(Category_Class obj)
{
if (obj.Active == "True")
{
obj.Active = "1";
}
else
{
obj.Active = "0";
}
SqlConnection con = new SqlConnection(objCon.ConnectionReturn());
SqlCommand cmd = new SqlCommand("Category_Insert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CategoryName", obj.CategoryName);
cmd.Parameters.AddWithValue("@SearchKeyword", obj.SearchKeyword);
cmd.Parameters.AddWithValue("@MetaDescription", obj.MetaDescription);
//cmd.Parameters.AddWithValue("@SequenceNo", obj.SequenceNo);
cmd.Parameters.AddWithValue("@Active", obj.Active);
// cmd.Parameters.Add("@Return", SqlDbType.Int).Value = "";
// cmd.Parameters["@Return"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
string Return = "Record Insert";
return(Return);
}
public string Category_Update(Category_Class obj)
{
string Return = objModels.Category_Update(obj);
return(Return);
}
public string Category_Insert(Category_Class obj)
{
string Return = objModels.Category_Insert(obj);
return(Return);
}
