protected void BtnCategoryAdd_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyWebsiteDB"].ConnectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("Insert into Tbl_Category(CategoryName)Values('" + TxtCategoryName.Text + "')", con);
cmd.ExecuteNonQuery();
Response.Write("<script> alert ('Kategori Eklendi'); </script>");
TxtCategoryName.Text = string.Empty;
con.Close();
TxtCategoryName.Focus();
BindCategoryRepeater();
Session["CategoryName"] = TxtCategoryName.Text;
}
}
private void BtnAdd_OnClick(object sender, RoutedEventArgs e)
{
TxtCategoryName.Focus();
}
private void WdwCategories_Loaded(object sender, RoutedEventArgs e)
{
TxtCategoryName.Focus();
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
try
{
//validation
if (TxtCategoryName.Text.Length <= 0)
{
lblmsg.Text = "Enter category name"; return;
}
string strCount = objDb.ExecuteScaler("select count(*) from ProductCategory where CatName='" + TxtCategoryName.Text + "' and CatCompanyID=" + Convert.ToString(Session["UserID"]));
string stractive = "0";
if (ChkActive.Checked == true)
{
stractive = "1";
}
else
{
stractive = "0";
}
string strqr = "";
if (Request.QueryString.Count > 0)
{
if (int.Parse(strCount) > 1)
{
lblmsg.Text = "Duplicate product category name are not allowed.";
TxtCategoryName.Focus();
return;
}
strqr = "update ProductCategory set CatName='" + TxtCategoryName.Text.Replace("'", "''") + "', CatActive= " + stractive + " where CatID=" + Convert.ToString(Request.QueryString["id"]);
}
else
{
if (int.Parse(strCount) >= 1)
{
lblmsg.Text = "Duplicate product category name are not allowed.";
TxtCategoryName.Focus();
return;
}
strqr = "insert into ProductCategory (CatName,CatCompanyID,CatActive) values ('" + TxtCategoryName.Text.Replace("'", "''") + "'," + Convert.ToString(Session["UserID"]) + "," + stractive + ")";
}
string ret = objDb.ExecuteInsertUpdate(strqr);
if (ret == "" || ret == null || ret == "0")
{
lblmsg.Text = "Error : " + objDb.returnMsg; return;
}
//Response.Redirect("ProductCategory.aspx");
this.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script language=\"javaScript\">" + "alert('Record Saved');" + "window.location.href='ProductCategory.aspx';" + "<" + "/script>");
}
catch (Exception ex)
{
lblmsg.Text = "Error : " + ex.Message.ToString();
}
}
