public Categories isUserExisting(string Category)
{
DataTable dt = new DataTable("Category");
dt.Clear();
string query = "SELECT * FROM Categories where Category='" + Category + "'";
dt = DataAccess.DBAdapter.GetRecordSet(query);
Categories log = null;
if (dt.Rows.Count > 0)
{
log = new Categories(dt.Rows[0]);
}
return log;
}
public string insertCategory(Categories cats)
{
string Message = string.Empty;
int result = 0;
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO [Categories]([Category]) VALUES (@Category)", con);
cmd.Parameters.AddWithValue("@Category", cats.Category);
result = cmd.ExecuteNonQuery();
con.Close();
return Message;
}
private bool isUserExisting()
{
string userid = this.txtCategory.Text;
busCategories buscat = new busCategories();
Categories frmcat = new Categories();
frmcat = buscat.isUserExisting(userid);
//FrameWork.Employees log = busemp.isUserExisting(userid);
if (frmcat == null)
{
return false;
}
else if (userid.Equals(frmcat.Category))
{
return true;
}
else
{
return false;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
busCategories buscat = new busCategories();
Categories frmcat = new Categories();
frmcat.Category = this.txtCategory.Text;
isExisting = isUserExisting();
if (isExisting.Equals(true))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Category existing')", true);
}
else
{
buscat.insertCategory(frmcat);
}
DataTable dt = new DataTable("User");
dt = buscat.allCategories();
GridView1.DataSource = dt;
GridView1.DataBind();
}
