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