protected void btnUpdate_Click(object sender, EventArgs e) { string param = ""; string row_num = "0"; string sql = ""; DbCall objDB = new DbCall(); if (Request.QueryString["ROWNUM"] != null) { row_num = Request.QueryString["ROWNUM"].ToString(); param += row_num + "~"; param += cmbCat.SelectedItem.Text + "~"; param += txtUrl.Text + "~"; param += txtRem.Text + "~"; sql = "UPDATE URL_MASTER SET URL = '{2}', CATEGORY = '{1}', REMARKS = '{3}' WHERE URLID = {0}"; sql = String.Format(sql, param.Split('~')); int retval = objDB.ExecuteNonQuery(sql); if (retval == 1) { lblMessg.Text = "Url details updated successfully"; Response.Write("<script language='javascript'> alert('Url details updated successfully'); </script>"); FillGrid(); btnAdd.Enabled = false; } else { lblMessg.Text = "Error encountered, please try again"; Response.Write("<script language='javascript'> alert('Error encountered, please try again'); </script>"); } } else { lblMessg.Text = "Please select any item to be updated from grid below"; } }
protected void btnDel_Click(object sender, EventArgs e) { string param = ""; string row_num = "0"; string sql = ""; DbCall objDB = new DbCall(); if (Request.QueryString["ROWNUM"] != null) { row_num = Request.QueryString["ROWNUM"].ToString(); param += row_num + "~"; sql = "DELETE FROM CAT_MASTER WHERE CATID = {0}"; sql = String.Format(sql, param.Split('~')); int retval = objDB.ExecuteNonQuery(sql); if (retval == 1) { lblMessg.Text = "Category deleted successfully"; Response.Write("<script language='javascript'> alert('Category deleted successfully'); </script>"); FillGrid(); btnAdd.Enabled = false; } else { lblMessg.Text = "Error encountered, please try again"; Response.Write("<script language='javascript'> alert('Error encountered, please try again'); </script>"); } } else { lblMessg.Text = "Please select any item to be deleted from grid below"; } }
protected void btnAdd_Click(object sender, EventArgs e) { string param = ""; string row_num = "0"; string sql = ""; DbCall objDB = new DbCall(); if (Request.QueryString["ROWNUM"] == null) { row_num = "0"; sql = "SELECT * FROM CAT_MASTER WHERE CATEGORY = '" + txtCat.Text + "'"; DataSet dsDocs = objDB.ExecuteQuery(sql); if (dsDocs != null && dsDocs.Tables[0].Rows.Count > 0) { lblMessg.Text = "You have already added Category : " + txtCat.Text; return; } sql = "SELECT MAX(CATID)+1 FROM CAT_MASTER"; dsDocs = objDB.ExecuteQuery(sql); if (dsDocs != null && dsDocs.Tables[0].Rows.Count > 0) { row_num = dsDocs.Tables[0].Rows[0][0].ToString(); } else { row_num = "1"; } if (row_num == "") { row_num = "1"; } param += row_num + "~"; param += txtCat.Text + "~"; sql = "INSERT INTO CAT_MASTER (CATID, CATEGORY) VALUES({0}, '{1}')"; sql = String.Format(sql, param.Split('~')); int retval = objDB.ExecuteNonQuery(sql); if (retval == 1) { lblMessg.Text = "Category details added successfully"; Response.Write("<script language='javascript'> alert('Category details added successfully'); </script>"); FillGrid(); btnAdd.Enabled = false; } else { lblMessg.Text = "Error encountered, please try again"; Response.Write("<script language='javascript'> alert('Error encountered, please try again'); </script>"); } } }
protected void btnAdd_Click(object sender, EventArgs e) { string param = ""; string row_num = "0"; string sql = ""; DbCall objDB = new DbCall(); if (Request.QueryString["ROWNUM"] == null) { row_num = "0"; sql = "SELECT * FROM URL_MASTER WHERE CATEGORY = '" + cmbCat.SelectedItem.Text + "' AND URL = '" + txtUrl.Text + "'"; DataSet dsDocs = objDB.ExecuteQuery(sql); if (dsDocs != null && dsDocs.Tables[0].Rows.Count > 0) { lblMessg.Text = "You have already added Url: " + txtUrl.Text + " for category : " + cmbCat.SelectedItem.Text; return; } sql = "SELECT MAX(URLID)+1 FROM URL_MASTER"; dsDocs = objDB.ExecuteQuery(sql); if (dsDocs != null && dsDocs.Tables[0].Rows.Count > 0) { row_num = dsDocs.Tables[0].Rows[0][0].ToString(); } else { row_num = "1"; } if (row_num == "") { row_num = "1"; } param += row_num + "~"; param += cmbCat.SelectedItem.Text + "~"; param += txtUrl.Text + "~"; param += txtRem.Text + "~"; param += txtNam.Text + "~"; param += DateTime.Today.ToString("MM/dd/yyyy") + "~"; sql = "INSERT INTO URL_MASTER (URLID, CATEGORY, URL, REMARKS, ADDED_BY, ADDED_DATE) VALUES({0}, '{1}', '{2}', '{3}', '{4}', '{5}')"; sql = String.Format(sql, param.Split('~')); int retval = objDB.ExecuteNonQuery(sql); if (retval == 1) { lblMessg.Text = "Url details added successfully"; Response.Write("<script language='javascript'> alert('Url details added successfully'); </script>"); FillGrid(); btnAdd.Enabled = false; } else { lblMessg.Text = "Error encountered, please try again"; Response.Write("<script language='javascript'> alert('Error encountered, please try again'); </script>"); } } }