internal List <RegDetails> GetUser() { List <RegDetails> listUser = new List <RegDetails>(); using (SqlConnection con = new SqlConnection(ConnectSql.GetConnectionString())) { con.Open(); SqlCommand cmd = new SqlCommand("select*from OwnerRegistration", con); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { RegDetails User = new RegDetails(); User.FirstName = rdr["FirstName"].ToString(); User.LastName = rdr["LastName"].ToString(); User.Email = rdr["Email"].ToString(); User.Mobile = Convert.ToInt64(rdr["MobileNumber"]); User.UserName = rdr["UserName"].ToString(); listUser.Add(User); } } } return(listUser); }
public bool SaveData(RegDetails user) { try { using (SqlConnection con = new SqlConnection(ConnectSql.GetConnectionString())) { con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO OwnerRegistration (FirstName,LastName,Email,Mobile,UserName,Password) Values (@FirstName,@LastName,@Email,@Mobile,@UserName,@Password)", con); cmd.Parameters.AddWithValue("@FirstName", user.FirstName); cmd.Parameters.AddWithValue("@LastName", user.LastName); cmd.Parameters.AddWithValue("@Email", user.Email); cmd.Parameters.AddWithValue("@Mobile", user.Mobile); cmd.Parameters.AddWithValue("@UserName", user.UserName); cmd.Parameters.AddWithValue("@Password", user.Password); cmd.ExecuteNonQuery(); con.Close(); } return(true); } catch (Exception ex) { Log(ex.Message); return(false); } }
public bool UpdateUSerDetails(RegDetails ObjRegObject) { using (SqlConnection con = new SqlConnection(ConnectSql.GetConnectionString())) { try { con.Open(); SqlCommand cmd = new SqlCommand("UPDATE REGISTER SET FIRSTNAME=@FirstName,LASTNAME=@LastName,Email=@Email,Mobile=@Mobile,UserName=@UserName Where Email=@Email", con); cmd.Parameters.AddWithValue("@FirstName", ObjRegObject.FirstName); cmd.Parameters.AddWithValue("@LastName", ObjRegObject.LastName); cmd.Parameters.AddWithValue("@Email", ObjRegObject.Email); cmd.Parameters.AddWithValue("@Mobile", ObjRegObject.Mobile); cmd.Parameters.AddWithValue("@UserName", ObjRegObject.UserName); cmd.ExecuteNonQuery(); return(true); } catch { return(false); } finally { con.Close(); } } }
public bool UserVerifyUserDetails(RegDetails user) { if (user.FirstName.Length > 4 && user.LastName.Length > 4) { UserRegDomain domain = new UserRegDomain(); bool response = domain.SavetoDatabase(user); return(response); } else { return(false); } }
private void btnLoad_Click(object sender, EventArgs e) { RegDetails objRegObject = new RegDetails(); objRegObject.FirstName = UserGridView.SelectedRows[0].Cells["ColFirstName"].Value.ToString(); objRegObject.LastName = UserGridView.SelectedRows[0].Cells["ColLastName"].Value.ToString(); objRegObject.Email = UserGridView.SelectedRows[0].Cells["ColEmail"].Value.ToString(); objRegObject.Mobile = Convert.ToInt64(UserGridView.SelectedRows[0].Cells["ColMobile"].Value); objRegObject.UserName = UserGridView.SelectedRows[0].Cells["ColUserName"].Value.ToString(); UpdateDetails upobj = new UpdateDetails(objRegObject); upobj.Show(); this.Hide(); }
private void btnUpdate_Click(object sender, EventArgs e) { UpdateUserDetailsAppLayer objAppLayer = new UpdateUserDetailsAppLayer(); RegDetails objRegUSer = new RegDetails { FirstName = string.IsNullOrWhiteSpace(txtFirstName.Text) ? "NULL" : txtFirstName.Text, LastName = txtLastName.Text, Mobile = string.IsNullOrWhiteSpace(Convert.ToInt64(txtMobile.Text).ToString()) ? 0 : Convert.ToInt64(txtMobile.Text), Email = txtEmail.Text, UserName = txtUserName.Text }; string Result = objAppLayer.UpdateUser(objRegUSer); MessageBox.Show(Result); }
public string UserUpdateBusinessLayer(RegDetails ObjRegUSer) { UserUpdateDomain objUpdate = new UserUpdateDomain(); bool IsValidationOK = true; string ResponseMessage = ""; if (ObjRegUSer.Email.Length < 4) { IsValidationOK = false; ResponseMessage = "Email Id is less than requirent"; } else if (ObjRegUSer.FirstName == null || ObjRegUSer.FirstName == "NULL") { IsValidationOK = false; ResponseMessage = "invalid name"; } else if (ObjRegUSer.Mobile == 0 || ObjRegUSer.Mobile.ToString().Length < 10) { IsValidationOK = false; ResponseMessage = "MObile no is less than 10 digit"; } else { IsValidationOK = true; ResponseMessage = "Data updated successfully"; } if (IsValidationOK == true) { bool Response = objUpdate.UpdateUserDetails(ObjRegUSer); if (Response == true) { return(ResponseMessage); } else { return("Some thing wrong"); } } else { return(ResponseMessage); } }
public string UserVerifyUserDetails(RegDetails user) { string ResponseMessage = ""; bool IsValidationOK = false; if (!user.Email.Contains("@")) { IsValidationOK = false; ResponseMessage = "Email Id is not valid"; } else if (user.FirstName == null || user.FirstName == "NULL") { IsValidationOK = false; ResponseMessage = "invalid name"; } else if (user.Mobile == 0 || user.Mobile.ToString().Length < 10) { IsValidationOK = false; ResponseMessage = "MObile no is less than 10 digit"; } else if (UserAlreadyExists(user.Email)) { IsValidationOK = false; ResponseMessage = "User already exists"; } else { IsValidationOK = true; ResponseMessage = "Congrats!!! Your account is sucessfully registered"; } if (IsValidationOK == true) { UserRegDomain domain = new UserRegDomain(); bool response = domain.SavetoDatabase(user); } return(ResponseMessage); }
public bool SaveData(RegDetails user) { string EncryptedPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(user.Password, "SHA1"); try { using (SqlConnection con = new SqlConnection(ConnectSql.GetConnectionString())) { try { con.Open(); SqlCommand cmd = new SqlCommand("SpAddUser", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@FirstName", user.FirstName); cmd.Parameters.AddWithValue("@LastName", user.LastName); cmd.Parameters.AddWithValue("@Email", user.Email); cmd.Parameters.AddWithValue("@Mobile", user.Mobile); cmd.Parameters.AddWithValue("@UserName", user.UserName); cmd.Parameters.AddWithValue("@Password", EncryptedPassword); cmd.ExecuteNonQuery(); return(true); } catch (Exception) { throw; } finally { con.Close(); } } } catch (Exception ex) { Log(ex.Message); return(false); } }
private void btnRegister_Click(object sender, EventArgs e) { if (txtFirstName.Text == "") { WarningFN.Visible = true; WarningFN.Text = "First name is mandatory"; } else { RegDetails user = new RegDetails { FirstName = txtFirstName.Text, LastName = txtLastName.Text, Email = txtEmail.Text, Mobile = Convert.ToInt64(txtMobile.Text), UserName = txtUserName.Text, Password = txtPassword.Text, Confirm = txtConfirm.Text }; string Response = user.ImplementBusinessLogics(user); if (Response != "Congrats!!! Your account is sucessfully registered") { if (Response == "invalid name") { WarningFN.Visible = true; WarningFN.Text = "First name is mandatory"; } } MessageBox.Show(Response); if (Response == "Congrats!!! Your account is sucessfully registered") { this.Hide(); Login objLogin = new Login(); objLogin.Show(); } } }
private void btnRegister_Click(object sender, EventArgs e) { RegDetails user = new RegDetails { FirstName = txtFirstName.Text, LastName = txtLastName.Text, Email = txtEmail.Text, Mobile = Convert.ToInt64(txtMobile.Text), UserName = txtUserName.Text, Password = txtPassword.Text, Confirm = txtConfirm.Text }; bool Response = user.ImplementBusinessLogics(user); if (Response) { MessageBox.Show("Data saved sucessfully"); } else { MessageBox.Show("Failed to save data"); } }
public bool UpdateUserDetails(RegDetails ObjRegObject) { UserUpdateService objService = new UserUpdateService(); return(objService.UpdateUSerDetails(ObjRegObject)); }
public UpdateDetails(RegDetails ObjRegObject) { _ObjRegObject = ObjRegObject; InitializeComponent(); }
public bool SavetoDatabase(RegDetails user) { UserDataDetails data2 = new UserDataDetails(); return(data2.SaveData(user)); }