public void checkitemdataemail() { int i = 0; List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Add(new SqlParameter("@fieldvalue", txtemailid.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@fieldvaluename", "emailid")); sqlp.Add(new SqlParameter("@tablename", "user_details")); if (btnadduser.Text == "Update") { sqlp.Add(new SqlParameter("@fieldid", dbCommon.GetUpdateId("editid"))); sqlp.Add(new SqlParameter("@fieldidname", "userid")); sqlp.Add(new SqlParameter("@mode", "edit")); } else { sqlp.Add(new SqlParameter("@fieldid", "0")); sqlp.Add(new SqlParameter("@fieldidname", "userid")); sqlp.Add(new SqlParameter("@mode", "add")); } i = dbCommon.CheckDuplicate(sqlp, "checkduplicatedata"); if (i >= 1) { lblErrorMsg.Text = "* This Email id already exist."; lblErrorMsg.Visible = true; } else { lblErrorMsg.Text = ""; lblErrorMsg.Visible = false; } }
public void checkitemdata() { int i = 0; List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Add(new SqlParameter("@fieldvalue", txtHotelType.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@fieldvaluename", "hoteltypename")); sqlp.Add(new SqlParameter("@tablename", "hoteltype")); if (btnSubmit.Text == "Update") { sqlp.Add(new SqlParameter("@fieldid", dbCommon.GetUpdateId("editid"))); sqlp.Add(new SqlParameter("@fieldidname", "hoteltypeid")); sqlp.Add(new SqlParameter("@mode", "edit")); } else { sqlp.Add(new SqlParameter("@fieldid", "0")); sqlp.Add(new SqlParameter("@fieldidname", "hoteltypeid")); sqlp.Add(new SqlParameter("@mode", "add")); } i = dbCommon.CheckDuplicate(sqlp, "checkduplicatedata"); if (i >= 1) { lblErrorMsg.Text = "* This hotel type exist."; lblErrorMsg.Visible = true; } else { lblErrorMsg.Text = ""; lblErrorMsg.Visible = false; } }
public void checkItemData() { int i = 0; List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Add(new SqlParameter("@FieldValue", txtcn.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@FieldValueName", "countryname")); sqlp.Add(new SqlParameter("@TableName", "country")); if (btncn.Text == "Update") { sqlp.Add(new SqlParameter("@FieldId", dbCommon.GetUpdateId("editId"))); sqlp.Add(new SqlParameter("@FieldIdName", "countryid")); sqlp.Add(new SqlParameter("@Mode", "EDIT")); } else { sqlp.Add(new SqlParameter("@FieldId", "0")); sqlp.Add(new SqlParameter("@FieldIdName", "countryid")); sqlp.Add(new SqlParameter("@Mode", "ADD")); } i = dbCommon.CheckDuplicate(sqlp, "CheckDuplicateData"); if (i >= 1) { lblErrorMsg.Text = "*This Country Is Exist."; lblErrorMsg.Visible = true; } else { lblErrorMsg.Text = ""; lblErrorMsg.Visible = false; } }
public void checkitemdata() { int i = 0; List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Add(new SqlParameter("@fieldvalue", txtEmailID.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@fieldvaluename", "emailid")); sqlp.Add(new SqlParameter("@tablename", "user_details")); sqlp.Add(new SqlParameter("@fieldid", "0")); sqlp.Add(new SqlParameter("@fieldidname", "userid")); sqlp.Add(new SqlParameter("@mode", "add")); i = dbCommon.CheckDuplicate(sqlp, "checkduplicatedata"); if (i >= 1) { lblEmailIdEx.Text = ""; lblEmailIdEx.Visible = false; } else { lblEmailIdEx.Text = "* This Email Id does not exist."; lblEmailIdEx.Visible = true; } }
protected void txtArea_TextChanged(object sender, EventArgs e) { int i = 0; DBConnectionClass conD = new DBConnectionClass("CheckDuplicateData"); List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Clear(); sqlp.Add(new SqlParameter("@TableName", "LAS_area")); sqlp.Add(new SqlParameter("@FieldName", "area_name")); sqlp.Add(new SqlParameter("@FieldValue", txtArea.Text.ToString().Trim())); i = conD.CheckDuplicate(sqlp); if (i >= 1) { if (btnSubmit.Text == "Update" && txtArea.Text.ToUpper().Trim() != ViewState["description"].ToString().ToUpper().Trim()) { lblDErrorMsg.Text = "* This Area Exist."; } else { lblDErrorMsg.Text = ""; } if (btnSubmit.Text == "Save") { lblDErrorMsg.Text = "* This Area Exist."; } } else { lblDErrorMsg.Text = ""; } }
protected void txttitle_TextChanged(object sender, EventArgs e) { int i = 0; DBConnectionClass conD = new DBConnectionClass("CheckDuplicateData"); List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Clear(); sqlp.Add(new SqlParameter("@TableName", "service")); sqlp.Add(new SqlParameter("@FieldName", "sname")); sqlp.Add(new SqlParameter("@FieldValue", txttitle.Text.ToString().Trim())); i = conD.CheckDuplicate(sqlp); if (i >= 1) { if (btnSubmit.Text == "Update" && txtDescription.Text.ToUpper().Trim() != ViewState["description"].ToString().ToUpper().Trim()) { lblDErrorMsg.Text = "* This service exist."; lblDErrorMsg.Visible = true; } else { lblDErrorMsg.Text = ""; lblDErrorMsg.Visible = false; } if (btnSubmit.Text == "Submit") { lblDErrorMsg.Text = "* This service exist."; lblDErrorMsg.Visible = true; } } else { lblDErrorMsg.Text = ""; lblDErrorMsg.Visible = false; } }
protected void OldPassword_Match() { try { DBConnectionClass conCheckDuplicate = new DBConnectionClass(); List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Add(new SqlParameter("@UserId", Session["LoginUserId"].ToString())); sqlp.Add(new SqlParameter("@UserPassword", conCheckDuplicate.HashPassword(txtoldpwd.Text.ToString()))); int i = conCheckDuplicate.CheckDuplicate(sqlp, "MatchOldPassword"); if (i == 0) { ViewState["OldPass"] = "******"; lblErrorMsg.Text = "*Old Password Does Not Match."; txtoldpwd.Focus(); } else { lblErrorMsg.Text = ""; ViewState["OldPass"] = "******"; } } catch (Exception) { } }