protected void btnsubmit_Click(object sender, EventArgs e) { try { //validation if (DdlProduct.Text == "-1") { lblmsg.Text = "Select product name"; return; } if (lblmsg3.Text == "0") { lblmsg.Text = "Product is not available for issue"; return; } if (TxtQty.Text.Length <= 0) { lblmsg.Text = "Enter issue quanity"; return; } if (objValidation.IsNumeric(TxtQty.Text) == false) { lblmsg.Text = "Enter issue quanity"; return; } if (int.Parse(TxtQty.Text) > int.Parse(lblmsg3.Text)) { lblmsg.Text = "Issue quanity can not be more than available qty."; return; } if (TxtTo.Text.Length <= 0) { lblmsg.Text = "Enter issue to"; return; } string strqr = "insert into IssueStock (IssueDate,IssueProductID,IssueQuantity,IssueTo,IssueBy) values (getdate()," + DdlProduct.Text + "," + TxtQty.Text + ",'" + TxtTo.Text.Replace("'", "''") + "'," + Convert.ToString(Session["UserID"]) + ")"; string ret = objDb.ExecuteInsertUpdate(strqr); if (ret == "" || ret == null || ret == "0") { lblmsg.Text = "Error : " + objDb.returnMsg; return; } this.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script language=\"javaScript\">" + "alert('Stock Issued');" + "window.location.href='default.aspx';" + "<" + "/script>"); } catch (Exception ex) { lblmsg.Text = "Error : " + ex.Message.ToString(); } }
protected void BtnAddProduct_Click(object sender, EventArgs e) { //validation if (DdlProduct.Text == "-1") { lblmsg.Text = "Select product"; return; } if (DdlWarehouse.Text == "--1") { lblmsg.Text = "Select warehouse"; return; } if (TxtQuantity.Text.Trim().Length <= 0) { lblmsg.Text = "Enter quantity"; return; } if (objValidation.IsNumeric(TxtQuantity.Text) == false) { lblmsg.Text = "Enter quantity"; return; } //add in datatable and re-bind grid dt = (DataTable)ViewState["dt"]; if (dt.Rows.Count == 1) { if (Convert.ToString(dt.Rows[0][0]) == "") { dt.Rows[0].Delete(); } } DataRow r1; r1 = dt.NewRow(); r1[0] = dt.Rows.Count + 1; r1[1] = DdlProduct.Text + "-" + objDb.ExecuteScaler("select ProductName from productmaster where productid=" + DdlProduct.Text); r1[2] = DdlWarehouse.Text + "-" + objDb.ExecuteScaler("select WarehouseName from WarehouseMaster where WarehouseID=" + DdlWarehouse.Text); r1[3] = TxtQuantity.Text; r1[4] = objDb.ExecuteScaler("select Price from productmaster where productid=" + DdlProduct.Text); dt.Rows.Add(r1); ViewState["dt"] = dt; Session["dt"] = dt; grv1.DataSource = dt; grv1.DataBind(); dt = (DataTable)ViewState["dt"]; //Response.Write(dt.Rows.Count); }
protected void btnsubmit_Click(object sender, EventArgs e) { //validate data try { if (TxtDisplayName.Text.Trim() == "") { lblmsg.Text = "Please enter name."; return; } if (objValidation.IsValideCharacter(TxtDisplayName.Text) == false) { lblmsg.Text = "Special characters not allowed in name."; return; } if (TxtMobile.Text.Trim() == "") { lblmsg.Text = "Please enter mobile no."; return; } if (objValidation.IsNumeric(TxtMobile.Text) == false) { lblmsg.Text = "Only enter numbers in mobile no."; return; } if (TxtWebsite.Text.Length > 0) { if (Uri.IsWellFormedUriString(TxtWebsite.Text, UriKind.Absolute) == false) { lblmsg.Text = "Invalid web site url."; return; } } //update user profile string strqry = ""; strqry = "update usermaster set displayname='" + TxtDisplayName.Text.Replace("'", "''") + "', mobileno='" + TxtMobile.Text + "',officeno='" + TxtOfficeNo.Text.Replace("'", "''") + "', Extension='" + TxtExt.Text.Replace("'", "''") + "', Address='" + TxtAddress.Text.Replace("'", "''") + "',website='" + TxtWebsite.Text.Replace("'", "''") + "' where emailid = '" + Convert.ToString(Session["EmailID"]) + "'"; string ret = objDb.ExecuteInsertUpdate(strqry); if (ret == "" || ret == null || ret == "0") { lblmsg.Text = "Error : " + objDb.returnMsg; return; } lblmsg.Text = "User profile updated successfully!."; } catch (Exception ex) { lblmsg.Text = "Error : " + ex.Message.ToString(); } }
protected void btnsubmit_Click(object sender, EventArgs e) { try { //validation if (TxtProductName.Text.Length <= 0) { lblmsg.Text = "Enter product name. "; return; } string strcount = objDb.ExecuteScaler("select count(*) from ProductMaster where ProductName='" + TxtProductName.Text + "' and ProductCompanyID=" + Convert.ToString(Session["UserID"])); if (DdlCategory.Text == "-1") { lblmsg.Text = "Select category. "; return; } if (objValidation.IsNumeric(TxtPrice.Text) == false) { lblmsg.Text = "Enter product price. "; return; } string strqr = ""; if (Request.QueryString.Count > 0) { if (int.Parse(strcount) > 1) { lblmsg.Text = "Duplicate product name are not allowed."; TxtProductName.Focus(); return; } strqr = "update ProductMaster set ProductName='" + TxtProductName.Text.Replace("'", "''") + "',ProductDescription='" + TxtDescription.Text.Replace("'", "''") + "', ProductCatId=" + DdlCategory.SelectedItem.Value + ", Price=" + TxtPrice.Text + " where ProductID=" + Convert.ToString(Request.QueryString["id"]); } else { if (int.Parse(strcount) >= 1) { lblmsg.Text = "Duplicate product name are not allowed."; TxtProductName.Focus(); return; } strqr = "insert into ProductMaster (ProductName,ProductDescription,ProductCatId,ProductCompanyID,Price) values ('" + TxtProductName.Text.Replace("'", "''") + "','" + TxtDescription.Text.Replace("'", "''") + "'," + DdlCategory.SelectedItem.Value + "," + Convert.ToString(Session["UserID"]) + "," + TxtPrice.Text + ")"; } string ret = objDb.ExecuteInsertUpdate(strqr); if (ret == "" || ret == null || ret == "0") { lblmsg.Text = "Error : " + objDb.returnMsg; return; } this.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script language=\"javaScript\">" + "alert('Record saved successfully!');" + "window.location.href='ProductMaster.aspx';" + "<" + "/script>"); //Response.Redirect("ProductMaster.aspx"); } catch (Exception ex) { lblmsg.Text = "Error : " + ex.Message.ToString(); } }
protected void btnsubmit_Click(object sender, EventArgs e) { lblmsg.Text = ""; try { // Validation Area if (TxtEmailID.Text.Trim() == "") { lblmsg.Text = "Please enter email id."; return; } if (objValidation.IsEmail(TxtEmailID.Text) == false) { lblmsg.Text = "Email id you have entered not in correct format."; return; } if (TxtEmailID.Text.Trim() != "") { string str = objDb.ExecuteScaler("select count(*) from usermaster where emailid='" + TxtEmailID.Text + "'"); if (str != "" && str != null && str != "0") { lblmsg.Text = "Email id already registered, please enter other email id."; TxtEmailID.Text = ""; TxtEmailID.Focus(); } } if (TxtPassword.Text.Trim() == "") { lblmsg.Text = "Please enter password."; return; } if (TxtPassword.Text != TxtPassword1.Text) { lblmsg.Text = "Passwords are not matched, please check."; return; } if (TxtDisplayName.Text.Trim() == "") { lblmsg.Text = "Please enter name."; return; } if (objValidation.IsValideCharacter(TxtDisplayName.Text) == false) { lblmsg.Text = "Special characters not allowed in name."; return; } if (TxtMobile.Text.Trim() == "") { lblmsg.Text = "Please enter mobile no."; return; } if (objValidation.IsNumeric(TxtMobile.Text) == false) { lblmsg.Text = "Only enter numbers in mobile no."; return; } if (TxtWebsite.Text.Length > 0) { if (Uri.IsWellFormedUriString(TxtWebsite.Text, UriKind.RelativeOrAbsolute) == false) { lblmsg.Text = "Invalid web site url."; return; } } //------------------ string strInsert = "Insert into usermaster (EmailID, TypeID,DisplayName,Password,MobileNo,OfficeNo,Extension,Address,Website,JoinDate,LastLoginDate,ChangePasswordDate,Active) " + "values ('" + TxtEmailID.Text + "'," + ddlUserType.SelectedItem.Value + ",'" + TxtDisplayName.Text.Replace("'", "''") + "','" + TxtPassword.Text + "','" + TxtMobile.Text.Replace("'", "''") + "','" + TxtOfficeNo.Text.Replace("'", "''") + "','" + TxtExt.Text.Replace("'", "''") + "','" + TxtAddress.Text.Replace("'", "''") + "','" + TxtWebsite.Text.Replace("'", "''") + "',getdate(),null,null,1)"; strInsert = objDb.ExecuteInsertUpdate(strInsert); if (strInsert == "" || strInsert == null || strInsert == "0") { lblmsg.Text = "Error : " + objDb.returnMsg; return; } this.ClientScript.RegisterStartupScript(this.GetType(), "Alert", "<script language=\"javaScript\">" + "alert('User registration done successfully!, please login!');" + "window.location.href='login.aspx';" + "<" + "/script>"); //lblmsg.Text = "User registration done successfully!."; //btnreset_Click(null, null); } catch (Exception ex) { lblmsg.Text = "Error in Submit : " + ex.Message.ToString(); } }