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) { }
}
