protected void btnInsert_Click(object sender, EventArgs e)
{
checkitemdata();
if (String.IsNullOrEmpty(lblEmailIdEx.Text.ToString()))
{
{
try
{
List <SqlParameter> sqlp = new List <SqlParameter>();
sqlp.Add(new SqlParameter("@user_fname", txtFirstName.Text.ToString().Trim()));
sqlp.Add(new SqlParameter("@user_lname", txtLastName.Text.ToString().Trim()));
sqlp.Add(new SqlParameter("@dob", txtDob.Text.ToString().Trim()));
sqlp.Add(new SqlParameter("@emailid", txtEmailID.Text.ToString().ToLower().Trim()));
if (radiofemale.Checked == true)
{
sqlp.Add(new SqlParameter("@gender", "0"));
}
else
if (radiomale.Checked == true)
{
sqlp.Add(new SqlParameter("@gender", "1"));
}
if (ViewState["UserType"].ToString() == "GUEST")
{
sqlp.Add(new SqlParameter("@usertype", "GUEST"));
}
else
{
sqlp.Add(new SqlParameter("@usertype", "NEW"));
}
sqlp.Add(new SqlParameter("@password", dbCommon.HashPassword(txtPassword.Text.ToString().Trim())));
DataTable dt = new DataTable();
dt = dbCommon.DisplayData(sqlp, "SP_User_Registration").Tables[0];
if (dt != null)
{
SentMail(dt.Rows[0]["userid"].ToString());
}
}
catch (Exception)
{ }
}
}
}
protected void btnEnquiry_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(lblEmailIdEx.Text.ToString()))
{
List <SqlParameter> sqlp = new List <SqlParameter>();
if (Session["LoginUserId"] != null)
{
sqlp.Add(new SqlParameter("@userid", Session["LoginUserId"].ToString()));
sqlp.Add(new SqlParameter("@user_fname", ""));
sqlp.Add(new SqlParameter("@user_lname", ""));
sqlp.Add(new SqlParameter("@email_id", ""));
}
else
{
sqlp.Add(new SqlParameter("@userid", "0"));
sqlp.Add(new SqlParameter("@user_fname", txtfname.Text.ToString()));
sqlp.Add(new SqlParameter("@user_lname", txtlname.Text.ToString()));
sqlp.Add(new SqlParameter("@email_id", txtemail.Text.ToString().Trim().ToLower()));
}
if (txtDate.Text == "")
{
sqlp.Add(new SqlParameter("@packagedate", DBNull.Value));
}
else
{
sqlp.Add(new SqlParameter("@packagedate", txtDate.Text));
}
sqlp.Add(new SqlParameter("@primaryphone", txtphnno.Text.ToString().Trim()));
sqlp.Add(new SqlParameter("@packageid", dbCommon.GetUpdateId("packageId")));
sqlp.Add(new SqlParameter("@packagehotelid", ddhoteltype.SelectedValue.ToString()));
sqlp.Add(new SqlParameter("@adultmember", txtadult.Text.ToString()));
sqlp.Add(new SqlParameter("@childmember", txtchild.Text.ToString()));
sqlp.Add(new SqlParameter("@infantmember", txtinfant.Text.ToString()));
sqlp.Add(new SqlParameter("@studentmember", txtstudent.Text.ToString()));
sqlp.Add(new SqlParameter("@seniormember", txtsenior.Text.ToString()));
decimal.TryParse(lbltotalprice.Text.ToString(), out totalRate);
sqlp.Add(new SqlParameter("@totalpayment", totalRate.ToString()));
decimal.TryParse(lblTotDiscount.Text.ToString(), out totalDiscount);
sqlp.Add(new SqlParameter("@discountAmount", totalDiscount.ToString()));
DataTable dt = new DataTable();
dt = dbCommon.DisplayData(sqlp, "SP_PackageEnquiry").Tables[0];
if (dt != null)
{
List <PackageActivityEnquiry> actList = null;
if (Session["activityList"] != null)
{
actList = (List <PackageActivityEnquiry>)Session["activityList"];
if (actList.Count > 0)
{
string sqlQry = "";
for (int i = 0; i < actList.Count; i++)
{
sqlQry += " insert into bookpackageactivity " +
"(bookpackageactivityid,bookpackageid,packageitinerary_activityid) " +
"values(ISNULL((Select MAX(bookpackageactivityid) from bookpackageactivity),1)+1," +
" '" + dt.Rows[0]["bookpackageid"].ToString() + "', " +
"'" + actList[i].iActivityId.ToString() + "');";
}
if (dbCommon.boolInsertData(sqlQry) == true)
{
Response.Write("<script language='javascript'>window.alert('Enquiry submited.');window.location='HomePage.aspx';</script>");
}
}
else
{
Response.Write("<script language='javascript'>window.alert('Enquiry submited.');window.location='HomePage.aspx';</script>");
}
}
else
{
Response.Write("<script language='javascript'>window.alert('Enquiry submited.');window.location='HomePage.aspx';</script>");
}
}
else
{
Response.Write("<script language='javascript'>window.alert('Enquiry fail. Please try again.');</script>");
}
}
}
protected void ValidateUser()
{
DBConnectionClass conLoginUser = new DBConnectionClass();
string ipv4 = "", ipv6 = "";
List <SqlParameter> sqlp = new List <SqlParameter>();
sqlp.Add(new SqlParameter("@UserLoginName", txtLoginId.Text.ToString()));
sqlp.Add(new SqlParameter("@Password", conLoginUser.HashPassword(txtPassword.Text.ToString())));
List <SqlParameter> sqlULogin = new List <SqlParameter>();
string result = conLoginUser.checkUserLogin(sqlp);
string status = "";
string browsertype = Request.Browser.Type;
string browsername = Request.Browser.Browser;
string browserversion = Request.Browser.Version;
string browserplatform = Request.Browser.Platform;
string osname = "", osversion = "";
try
{
OperatingSystem os = Environment.OSVersion;
osname = os.ToString();
osversion = os.Version.ToString();
}
catch (Exception) { }
try
{
if (Dns.GetHostAddresses(Dns.GetHostName()).Length > 0)
{
ipv6 = Dns.GetHostAddresses(Dns.GetHostName())[0].ToString();
}
ipv4 = GetLocalIPv4(NetworkInterfaceType.Ethernet).ToString();
}
catch (Exception) { }
switch (result)
{
case "InValidId":
sqlULogin.Clear();
sqlULogin.Add(new SqlParameter("@IPAddress", ipv6));
sqlULogin.Add(new SqlParameter("@UnBrowser", browsername));
sqlULogin.Add(new SqlParameter("@UnOS", osname));
sqlULogin.Add(new SqlParameter("@BType", browsertype));
sqlULogin.Add(new SqlParameter("@BVersion", browserversion));
sqlULogin.Add(new SqlParameter("@BPlateForm", browserplatform));
sqlULogin.Add(new SqlParameter("@OSVersion", osversion));
sqlULogin.Add(new SqlParameter("@IUserName", txtLoginId.Text));
sqlULogin.Add(new SqlParameter("@IPV4", ipv4));
conLoginUser.SaveData(sqlULogin, "AddUnknownUserLogin");
status = "Invalid User Name Or Password.";
break;
case "Guest":
status = "You need to register with use to login.";
break;
case "InPass":
sqlULogin.Clear();
sqlULogin.Add(new SqlParameter("@emailid", txtLoginId.Text.ToString()));
sqlULogin.Add(new SqlParameter("@IPAddress", ipv6));
sqlULogin.Add(new SqlParameter("@TBrowser", browsername));
sqlULogin.Add(new SqlParameter("@BOS", osname));
sqlULogin.Add(new SqlParameter("@BType", browsertype));
sqlULogin.Add(new SqlParameter("@BVersion", browserversion));
sqlULogin.Add(new SqlParameter("@BPlateForm", browserplatform));
sqlULogin.Add(new SqlParameter("@OSVersion", osversion));
sqlULogin.Add(new SqlParameter("@IPV4", ipv4));
conLoginUser.SaveData(sqlULogin, "InvalidLoginAdd");
status = "Invalid User Name Or Password.";
break;
case "InActive":
sqlULogin.Clear();
sqlULogin.Add(new SqlParameter("@emailid", txtLoginId.Text.ToString()));
sqlULogin.Add(new SqlParameter("@UserPassword", conLoginUser.HashPassword(txtPassword.Text.ToString())));
DataTable dtUserIn = new DataTable();
dtUserIn = conLoginUser.DisplayData(sqlULogin, "MstUserView").Tables[0];
string userId = "";
foreach (DataRow drUserIn in dtUserIn.Rows)
{
userId = drUserIn["UserId"].ToString();
if (drUserIn["designationid"].ToString() == "4")
{
status = "Your account is De-Activate please check you email and confirm your Email-id.";
}
else
{
status = "Your account is De-Active. Contect Admin.";
}
break;
}
sqlULogin.Clear();
sqlULogin.Add(new SqlParameter("@UserId", userId));
sqlULogin.Add(new SqlParameter("@IPAddress", ipv6));
sqlULogin.Add(new SqlParameter("@TBrowser", browsername));
sqlULogin.Add(new SqlParameter("@BType", browsertype));
sqlULogin.Add(new SqlParameter("@BVersion", browserversion));
sqlULogin.Add(new SqlParameter("@BPlateForm", browserplatform));
sqlULogin.Add(new SqlParameter("@OSVersion", osversion));
sqlULogin.Add(new SqlParameter("@BOS", osname));
sqlULogin.Add(new SqlParameter("@IPV4", ipv4));
sqlULogin.Add(new SqlParameter("@LoginType", "I"));
conLoginUser.SaveData(sqlULogin, "TraceLoginAdd");
break;
case "Valid":
Configuration config = WebConfigurationManager.OpenWebConfiguration("~/Web.Config");
SessionStateSection section = (SessionStateSection)config.GetSection("system.web/sessionState");
Session.Timeout = 60 * 60;
sqlULogin.Clear();
sqlULogin.Add(new SqlParameter("@emailid", txtLoginId.Text.ToString()));
sqlULogin.Add(new SqlParameter("@UserPassword", conLoginUser.HashPassword(txtPassword.Text.ToString())));
DataTable dtUserInfo = new DataTable();
dtUserInfo = conLoginUser.DisplayData(sqlULogin, "MstUserView").Tables[0];
foreach (DataRow drUserInfo in dtUserInfo.Rows)
{
Session["LoginUserName"] = drUserInfo["user_fname"].ToString() + " " + drUserInfo["user_lname"].ToString();
Session["LoginUserId"] = drUserInfo["UserId"].ToString();
Session["LoginUserRole"] = drUserInfo["usertype"].ToString();
Session["LoginUserDesignation"] = drUserInfo["designationid"].ToString();
Response.Cookies["CookieLoginUserId"].Value = drUserInfo["UserId"].ToString();
Response.Cookies["CookieLoginUserId"].Expires = DateTime.Now.AddDays(30);
sqlULogin.Clear();
sqlULogin.Add(new SqlParameter("@UserId", drUserInfo["UserId"].ToString()));
sqlULogin.Add(new SqlParameter("@IPAddress", ipv6));
sqlULogin.Add(new SqlParameter("@TBrowser", browsername));
sqlULogin.Add(new SqlParameter("@BType", browsertype));
sqlULogin.Add(new SqlParameter("@BVersion", browserversion));
sqlULogin.Add(new SqlParameter("@BPlateForm", browserplatform));
sqlULogin.Add(new SqlParameter("@OSVersion", osversion));
sqlULogin.Add(new SqlParameter("@BOS", osname));
sqlULogin.Add(new SqlParameter("@LoginType", "A"));
sqlULogin.Add(new SqlParameter("@IPV4", ipv4));
conLoginUser.SaveData(sqlULogin, "TraceLoginAdd");
Response.Cookies["LoginSessionId"].Value = conLoginUser.CheckDuplicateByQuery("select MAX(TraceId) from TraceLogin where UserId='" + drUserInfo["UserId"].ToString() + "'").ToString();
Response.Cookies["LoginSessionId"].Expires = DateTime.Now.AddDays(30);
switch (Session["LoginUserRole"].ToString())
{
case "ADMIN":
Session["LoginUserDesignationType"] = drUserInfo["designation"].ToString();
Session["UserImage"] = drUserInfo["profileimg"].ToString();
Response.Redirect("../Admin/UserProfile.aspx");
break;
case "USER":
Response.Redirect("../User/HomePage.aspx");
break;
}
}
break;
}
spanDisplay.InnerHtml = status;
}
