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