public static string UserActiveDeActive(string eid, string uid) { try { DBConnectionClass con = new DBConnectionClass(); bool i; if (eid.ToString() == "0") { i = con.boolInsertData("update LAS_login set active_flag=0 where login_id='" + uid.ToString().Trim() + "'"); } else { i = con.boolInsertData("update LAS_login set active_flag=1 where login_id='" + uid.ToString().Trim() + "'"); } if (i == true) { return("true"); } else { return("false"); } } catch (Exception) { return("false"); } }
protected void txtCountry_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_country")); sqlp.Add(new SqlParameter("@FieldName", "country_name")); sqlp.Add(new SqlParameter("@FieldValue", txtCountry.Text.ToString().Trim())); i = conD.CheckDuplicate(sqlp); if (i >= 1) { if (btnSubmit.Text == "Update" && txtCountry.Text.ToUpper().Trim() != ViewState["description"].ToString().ToUpper().Trim()) { lblDErrorMsg.Text = "* This country exist."; } else { lblDErrorMsg.Text = ""; } if (btnSubmit.Text == "Save") { lblDErrorMsg.Text = "* This country 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 btnSubmit_Click(object sender, EventArgs e) { if (lblDErrorMsg.Text != "") { } else { Byte[] bytes = null; String ext = imgCategoryImage.PostedFile.ContentType; try { if (ext.ToLower() == "image/jpeg" || ext.ToLower() == "image/jpg" || ext.ToLower() == "image/png") { if (imgCategoryImage.PostedFile.ContentLength > 0) { Stream fs = imgCategoryImage.PostedFile.InputStream; BinaryReader br = new BinaryReader(fs); bytes = br.ReadBytes((Int32)fs.Length); } } else if (Session["imageupdate"] != null) { bytes = (Byte[])Session["imageupdate"]; } else { bytes = new byte[] { 0x20, 0x20, 0x20, 0x20, 0x20, 0x20, 0x20 }; } List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Add(new SqlParameter("@photo_src", bytes)); sqlp.Add(new SqlParameter("@item_name", txtItem.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@item_type", cmbItemtype.SelectedValue.ToString())); sqlp.Add(new SqlParameter("@price", txtPrice.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@description", txtDescription.Text.ToString().Trim())); if (btnSubmit.Text == "Submit") { DBConnectionClass dbSp = new DBConnectionClass("insertItem"); if (dbSp.SaveData(sqlp) == true) { Response.Redirect("item.aspx"); } } else { DBConnectionClass dbSp = new DBConnectionClass("updateItem"); sqlp.Add(new SqlParameter("@item_id", ViewState["id"].ToString())); if (dbSp.SaveData(sqlp) == true) { Response.Redirect("item.aspx"); } } } catch (Exception) { } } }
protected void btnchangepwd_Click(object sender, EventArgs e) { if (Page.IsValid) { OldPassword_Match(); if (ViewState["OldPass"].ToString().Equals("True")) { try { DBConnectionClass conPassUpdate = new DBConnectionClass(); List <SqlParameter> sqlpPassUpdate = new List <SqlParameter>(); sqlpPassUpdate.Add(new SqlParameter("@UserId", Session["LoginUserId"].ToString())); sqlpPassUpdate.Add(new SqlParameter("@OldUserPassword", conPassUpdate.HashPassword(txtoldpwd.Text.ToString()))); sqlpPassUpdate.Add(new SqlParameter("@NewUserPassword", conPassUpdate.HashPassword(txtnewpwd.Text.ToString()))); bool i = conPassUpdate.SaveData(sqlpPassUpdate, "UpdatePassword"); if (i == true) { this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Successful!',' Password Update Successfully.', 'success');", true); ViewState["OldPass"] = null; } } catch (Exception) { ViewState["OldPass"] = null; } } else { this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Warning!',' Password Not Updated.', 'warning');", true); ViewState["OldPass"] = null; } } }
// Get area list public List <AreaList> GetAreaList(string areaOf) { List <AreaList> areaLists = new List <AreaList>(); try { DBConnectionClass dBConnection = new DBConnectionClass { DatabaseName = "StayInEatIn" }; string Col_Area = areaOf; if (dBConnection.IsConnect()) { var cmd = new SqlCommand("SIEI_AREA_GetAreaList", dBConnection.Connection); SqlDataAdapter reader = new SqlDataAdapter(cmd); reader.SelectCommand.CommandType = CommandType.StoredProcedure; reader.SelectCommand.Parameters.AddWithValue("@H_T", Col_Area); reader.SelectCommand = cmd; if (reader != null) { DataTable dt = new DataTable(); reader.Fill(dt); foreach (DataRow areas in dt.Rows) { AreaList d = new AreaList(); d.Area = (string)areas["Area"]; areaLists.Add(d); } return(areaLists); } else { System.Diagnostics.Debug.WriteLine("Empty Reader"); } dBConnection.Close(); return(null); } else { System.Diagnostics.Debug.WriteLine("Conn Failed"); return(null); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Unsuccessful Query Excution"); throw e; } finally { } }
// Save hostel details public void SaveHostelDetails(HostelDetails hostelDetails) { try { DBConnectionClass dBConnection = new DBConnectionClass { DatabaseName = "StayInEatIn" }; string Col_Name = hostelDetails.Name; string Col_Area = hostelDetails.Area; string Col_Address = hostelDetails.Address; string Col_City = hostelDetails.City; string Col_Pin = hostelDetails.Pin; string Col_Mobile1 = hostelDetails.Mobile1; string Col_Mobile2 = hostelDetails.Mobile2; string Col_RoomFor = hostelDetails.RoomFor; int Col_Type = hostelDetails.Type; int Col_Furnished = hostelDetails.Furnished; string Col_StartingPrice = hostelDetails.StartingPrice; int Col_FoodAvail = hostelDetails.FoodAvail; if (dBConnection.IsConnect()) { var cmd = new SqlCommand("SIEI_HOST_SaveHostelDetails", dBConnection.Connection); cmd.Parameters.AddWithValue("@Col_Name", Col_Name); cmd.Parameters.AddWithValue("@Col_Area", Col_Area); cmd.Parameters.AddWithValue("@Col_Address", Col_Address); cmd.Parameters.AddWithValue("@Col_City", Col_City); cmd.Parameters.AddWithValue("@Col_Pin", Col_Pin); cmd.Parameters.AddWithValue("@Col_Mobile1", Col_Mobile1); cmd.Parameters.AddWithValue("@Col_Mobile2", Col_Mobile2); cmd.Parameters.AddWithValue("@Col_RoomFor", Col_RoomFor); cmd.Parameters.AddWithValue("@Col_Furnished", Col_Furnished); cmd.Parameters.AddWithValue("@Col_StartingPrice", Col_StartingPrice); cmd.Parameters.AddWithValue("@Col_FoodAvail", Col_FoodAvail); string value = cmd.ExecuteNonQuery().ToString(); dBConnection.Close(); //return value; } else { System.Diagnostics.Debug.WriteLine("Conn Failed"); //return null; } } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Unsuccessful Query Excution"); throw e; } }
protected void ClearHistory() { DBConnectionClass dbCon = new DBConnectionClass(); dbCon.EmptyUpdateId("editId"); dbCon.EmptyUpdateId("imageAddId"); Response.Cookies["LoginSessionId"].Expires = DateTime.Now.AddDays(-1); Response.Cookies["CookieLoginUserId"].Expires = DateTime.Now.AddDays(-1); Session.RemoveAll(); Session.Clear(); Session.Abandon(); Response.Redirect("../User/Login.aspx"); }
/// <summary> /// Authenticate user credentials. /// Compares the user entered credentials against /// the local database user table. /// Inherited from the IUserValidator interface /// ///Christopher K. Dierolf /// </summary> /// <returns>Returns true if credentials are authenticated. False if failed</returns> public bool AuthenticateUser(string userName, string password) { DBConnectionClass db = new DBConnectionClass(); if (db.FindLoginData(userName, password)) { return(true); } else { return(false); } }
public bool ValidateUserAccount(string email, string username) { DBConnectionClass db = new DBConnectionClass(); { if (db.DoesUserExist(email, username)) { return(true); } else { return(false); } } }
protected void Page_Load(object sender, EventArgs e) { DBConnectionClass dbclass = new DBConnectionClass(); dbclass.conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = dbclass.conn; cmd.CommandText = "select COURSE_NAME from course"; cmd.CommandType = System.Data.CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); dr.Read(); Label1.Text = dr.GetString(0); dbclass.conn.Close(); }
public void fillTable() { DBConnectionClass sp3 = new DBConnectionClass("displayData"); string sqlP = "select a.login_id,a.user_type,a.first_name,a.last_name,a.email_id,a.active_flag,a.mobile_no, c.description " + " from LAS_Login a, LAS_lawyer_profile b " + " Left Join LAS_specialization c On c.specialization_id = b.specialization_id " + " where a.login_id = b.login_id order by a.create_date desc "; DataTable dt = new DataTable(); dt = sp3.DisplayDataQuery(sqlP).Tables[0]; StringBuilder html = new StringBuilder(); foreach (DataRow dr in dt.Rows) { if (dr["user_type"].ToString() != "ADMIN") { html.Append("<tr>"); html.Append("<td>" + dr["first_name"] + " " + dr["last_name"] + "</td>"); html.Append("<td>" + dr["email_id"] + "</td>"); html.Append("<td>" + dr["mobile_no"] + "</td>"); html.Append("<td>" + dr["description"] + "</td>"); if (dr["active_flag"].ToString() == "0") { html.Append("<td align='center' width='4%'>Active</td>"); } else { html.Append("<td align='center' width='4%'>Deactive</td>"); } if (dr["active_flag"].ToString() == "0") { html.Append("<td align='center' width='4%'><a href='Javascript:deletefunction(1," + dr["login_id"].ToString() + ");'>Deactive</a></td>"); } else { html.Append("<td align='center' width='4%'><a href='Javascript:deletefunction(0," + dr["login_id"].ToString() + ");'>Active</a></td>"); } html.Append("</tr>"); } } displayLawyer.InnerHtml = html.ToString(); }
public static List <string> SearchDestination(string prefixText) { DBConnectionClass dbClass = new DBConnectionClass(); List <string> locations = new List <string>(); DataTable dt = new DataTable(); dt = dbClass.DisplayDataParam(" area a, city b, country c ", " " + " TOP 10 a.areaname,b.cityname,c.countryname ", " a.cityid=b.cityid and b.countryid=c.countryid " + " and (a.areaname like '%" + prefixText + "%' " + " or b.cityname like '%" + prefixText + "%' " + " or c.countryname like '%" + prefixText + "%')" + " order by a.areaname, b.cityname, c.countryname "); foreach (DataRow dr in dt.Rows) { locations.Add(dr["areaname"].ToString() + ", " + dr["cityname"].ToString() + ", " + dr["countryname"].ToString()); } return(locations); }
public void fillTable() { DBConnectionClass sp3 = new DBConnectionClass("displayData"); string sqlP = "select * from LAS_country "; DataTable dt = new DataTable(); dt = sp3.DisplayDataQuery(sqlP).Tables[0]; StringBuilder html = new StringBuilder(); foreach (DataRow dr in dt.Rows) { html.Append("<tr>"); html.Append("<td>" + dr["country_name"] + "</td>"); html.Append("<td align='center' width='4%'><a href='country.aspx?eid=" + dr["country_id"].ToString() + "'><i class='fa fa-1x fa-pencil'></i></a></td>"); html.Append("<td align='center' width='4%'><a href='Javascript:deletefunction(" + dr["country_id"].ToString() + ");'><i class='fa fa-1x fa-trash-o'></i></a></td>"); html.Append("</tr>"); } displayCountry.InnerHtml = html.ToString(); }
public static string Deletecity(string eid) { try { DBConnectionClass con = new DBConnectionClass(); bool i = con.boolInsertData("delete from LAS_city where city_id='" + eid.ToString().Trim() + "'"); if (i == true) { return("true"); } else { return("false"); } } catch (Exception) { return("false"); } }
public static string Deleteappointment(string eid) { try { DBConnectionClass con = new DBConnectionClass(); bool i = con.boolInsertData("update LAS_appointment set a_status='1' where appointment_id='" + eid.ToString().Trim() + "'"); if (i == true) { return("true"); } else { return("false"); } } catch (Exception) { return("false"); } }
protected void txtService_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_service")); //sqlp.Add(new SqlParameter("@FieldName", "description")); //sqlp.Add(new SqlParameter("@FieldValue", txtService.Text.ToString().Trim())); string sqlStr = ""; sqlStr = "select * from LAS_service where description='" + txtService.Text.ToString().Trim() + "' and login_id='" + Session["Slogin_id"].ToString() + "' "; if (btnSubmit.Text == "Update") { sqlStr = sqlStr + " and service_id!='" + ViewState["id"].ToString() + "' "; } i = conD.CheckDuplicateByQuery(sqlStr); if (i >= 1) { if (btnSubmit.Text == "Update") { lblDErrorMsg.Text = "* This service exist."; } else { lblDErrorMsg.Text = ""; } if (btnSubmit.Text == "Submit") { lblDErrorMsg.Text = "* This service exist."; } } else { lblDErrorMsg.Text = ""; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (lblEmail_V.Text == "") { DBConnectionClass con = new DBConnectionClass("createNewUser"); List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Add(new SqlParameter("@first_name", txtFName.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@last_name", txtLName.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@email_id", txtEmail.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@mobile_no", txtMobile.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@password", con.HashId(txtPassword.Text.ToString()))); sqlp.Add(new SqlParameter("@user_type", cmbUserType.SelectedValue.ToString())); if (con.SaveData(sqlp) == true) { Response.Redirect("login.aspx"); } else { } } }
public void fillTable() { DBConnectionClass sp3 = new DBConnectionClass("displayData"); string sqlP = "select * from LAS_office where login_id='" + Session["Slogin_id"].ToString() + "'"; DataTable dt = new DataTable(); dt = sp3.DisplayDataQuery(sqlP).Tables[0]; StringBuilder html = new StringBuilder(); foreach (DataRow dr in dt.Rows) { html.Append("<tr>"); html.Append("<td>" + dr["office_name"] + "</td>"); html.Append("<td>" + dr["address"] + "</td>"); html.Append("<td>" + dr["email_id"] + "</td>"); html.Append("<td align='center' width='4%'><a href='office_info.aspx?eid=" + dr["office_id"].ToString() + "'><i class='fa fa-1x fa-pencil'></i></a></td>"); html.Append("<td align='center' width='4%'><a href='Javascript:deletefunction(" + dr["office_id"].ToString() + ");'><i class='fa fa-1x fa-trash-o'></i></a></td>"); html.Append("</tr>"); } displayOffice.InnerHtml = html.ToString(); }
protected void btnSubmit_Click(object sender, EventArgs e) { DBConnectionClass conD = new DBConnectionClass("creteNewUserAndCompany"); List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Clear(); sqlp.Add(new SqlParameter("@company_name", txtCompanyName.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@company_address_l1", txtCompanyAddressL1.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@company_address_l2", txtCompanyAddressL2.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@company_address_l3", txtCompanyAddressL3.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@company_phone", txtCompanyPhone.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@password", dbCommon.HashId(txtPassword.Text.ToString().Trim()))); sqlp.Add(new SqlParameter("@fname", txtfname.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@lname", txtlname.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@email", txtEmail.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@mobile", txtMobile.Text.ToString().Trim())); bool i = conD.SaveData(sqlp); if (i == true) { Response.Redirect("login.aspx"); } }
// Dev Decoste private void btnEditMovie_Click(object sender, RoutedEventArgs e) { movie.MovieTitle = apiTitleText.Text; movie.ReleaseYear = apiYearText.Text; movie.Actors = apiActorstext.Text; movie.RunTime = apiRunTimeText.Text; movie.Plot = apiPlotText.Text; movie.Genre = apiGenreText.Text; movie.Awards = apiAwards.Text; movie.Director = apiDirector.Text; DBConnectionClass db = new DBConnectionClass(); if (db.UpdateMovie(movie) == true) { MessageBox.Show("Movie updated!"); this.Close(); } else { MessageBox.Show("Something went wrong"); } }
protected void btnchangepwd_Click(object sender, EventArgs e) { if (Page.IsValid) { OldPassword_Match(); if (ViewState["OldPass"].ToString().Equals("True")) { try { DBConnectionClass conPassUpdate = new DBConnectionClass(); List <SqlParameter> sqlpPassUpdate = new List <SqlParameter>(); sqlpPassUpdate.Add(new SqlParameter("@UserId", Session["LoginUserId"].ToString())); sqlpPassUpdate.Add(new SqlParameter("@OldUserPassword", conPassUpdate.HashPassword(txtoldpwd.Text.ToString()))); sqlpPassUpdate.Add(new SqlParameter("@NewUserPassword", conPassUpdate.HashPassword(txtnewpwd.Text.ToString()))); bool i = conPassUpdate.SaveData(sqlpPassUpdate, "UpdatePassword"); if (i == true) { Response.Write("<script>"); Response.Write("alert('Password Updated Successfully.');"); Response.Write("</script>"); ViewState["OldPass"] = null; } } catch (Exception) { ViewState["OldPass"] = null; } } else { Response.Write("<script>"); Response.Write("alert('Password Not Updated;');"); Response.Write("</script>"); ViewState["OldPass"] = null; } } }
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) { } }
// Dev Decoste /// <summary> /// Submit the movie data to the database. /// Requires at least a title. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_Click(object sender, RoutedEventArgs e) { DBConnectionClass db = new DBConnectionClass(); if (txtMovieTitle == null || txtMovieTitle.Text == "") { MessageBox.Show("No movie data to add. Ensure there is at least a title."); } else { Movie movie = new Movie(txtMovieTitle.Text, txtReleaseYear.Text, txtPlot.Text, txtActors.Text, txtGenre.Text, txtRunTime.Text, txtAwards.Text, txtDirector.Text); if (db.AddMovie(movie)) { string message = "The movie has been added!"; MessageBox.Show(message); this.Close(); } else { string message = "There was an error. Please try again!"; MessageBox.Show(message); } } }
// Christopher Dierolf // Method to refresh the movie list. private void RefreshMovies() { DBConnectionClass db = new DBConnectionClass(); movies = db.GetMovies(); // Get the movies from the database. }
protected void btnSubmit_Click(object sender, EventArgs e) { if (lblDErrorMsg.Text != "") { } else { Byte[] bytes = null; String ext = imgCategoryImage.PostedFile.ContentType; try { if (ext.ToLower() == "image/jpeg" || ext.ToLower() == "image/jpg" || ext.ToLower() == "image/png") { if (imgCategoryImage.PostedFile.ContentLength > 0) { Stream fs = imgCategoryImage.PostedFile.InputStream; BinaryReader br = new BinaryReader(fs); bytes = br.ReadBytes((Int32)fs.Length); } } else if (Session["imageupdate"] != null) { bytes = (Byte[])Session["imageupdate"]; } else { bytes = new byte[] { 0x20, 0x20, 0x20, 0x20, 0x20, 0x20, 0x20 }; } List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Add(new SqlParameter("@profile_src", bytes)); sqlp.Add(new SqlParameter("@password", dbCommon.HashId("admin"))); sqlp.Add(new SqlParameter("@fname", txtFName.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@lname", txtLName.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@email", txtEmail.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@designation_id", cmbItemtype.SelectedValue.ToString().Trim())); sqlp.Add(new SqlParameter("@address", txtAddress.Text.ToString().Trim())); if (btnSubmit.Text == "Submit") { DBConnectionClass dbSp = new DBConnectionClass("insertAdminUser"); if (dbSp.SaveData(sqlp) == true) { Response.Redirect("register_user.aspx"); } } else { DBConnectionClass dbSp = new DBConnectionClass("updateAdminUser"); sqlp.Add(new SqlParameter("@login_id", ViewState["id"].ToString())); if (dbSp.SaveData(sqlp) == true) { Response.Redirect("register_user.aspx"); } } } catch (Exception) { } } }
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; }
protected void btnsubmit_Click(object sender, EventArgs e) { Byte[] bytes = null; String ext = imgCategoryImage.PostedFile.ContentType; try { if (ext.ToLower() == "image/jpeg" || ext.ToLower() == "image/jpg" || ext.ToLower() == "image/png") { if (imgCategoryImage.PostedFile.ContentLength > 0) { Stream fs = imgCategoryImage.PostedFile.InputStream; BinaryReader br = new BinaryReader(fs); bytes = br.ReadBytes((Int32)fs.Length); } } else if (Session["imageupdate"] != null) { bytes = (Byte[])Session["imageupdate"]; } else { bytes = new byte[] { 0x20, 0x20, 0x20, 0x20, 0x20, 0x20, 0x20 }; } List <SqlParameter> sqlp = new List <SqlParameter>(); sqlp.Add(new SqlParameter("@profie_photo", bytes)); sqlp.Add(new SqlParameter("@description", txtDescription.Text.ToString())); sqlp.Add(new SqlParameter("@speci_id", cmbSpec.SelectedValue.ToString())); sqlp.Add(new SqlParameter("@license_no", txtLicenseNo.Text.ToString())); sqlp.Add(new SqlParameter("@issued_on", DateTime.Parse(txtIssuedOn.Text.ToString()).ToString("yyyy-MM-dd"))); sqlp.Add(new SqlParameter("@date_of_birth", DateTime.Parse(txtbirthdate.Text.ToString()).ToString("yyyy-MM-dd"))); sqlp.Add(new SqlParameter("@address_line1", txtaddress1.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@address_line2", txtaddress2.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@address_line3", txtaddress3.Text.ToString().Trim())); sqlp.Add(new SqlParameter("@login_id", Session["Slogin_id"].ToString())); if (dbCommon.boolInsertData("Update LAS_login set first_name='" + txtFirstName.Text.ToString().Trim() + "', " + " last_name='" + txtLastName.Text.ToString().Trim() + "', mobile_no='" + txtMobile.Text.ToString().Trim() + "' " + " where login_id='" + Session["Slogin_id"].ToString() + "' ") == true) { if (btnsubmit.Text == "Submit") { DBConnectionClass dbSp = new DBConnectionClass("insertLawyerProfile"); if (dbSp.SaveData(sqlp) == true) { Response.Redirect("profile.aspx"); } } else { DBConnectionClass dbSp = new DBConnectionClass("updateLawyerProfile"); if (dbSp.SaveData(sqlp) == true) { Response.Redirect("profile.aspx"); } } } } catch (Exception) { } }