public Model.Employee Authenticate(string emailId, string password) { Model.Employee employee=new Model.Employee(); SqlConnection con = new SqlConnection("Data Source=TRAINING12;Initial Catalog=Employee;User ID=sa;Password=test123!@#"); con.Open(); SqlCommand cmd = new SqlCommand("Authenticate", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@emailId",emailId)); cmd.Parameters.Add(new SqlParameter("@password",password)); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { EmployeeStorage storageObject= new EmployeeStorage(); employee = storageObject.Get(dr[0].ToString(), "1"); return employee; } con.Close(); return null; }
public bool UpdatePassword(string oldPassword,string newPassword,string emailId) { EmployeeStorage storageObject = new EmployeeStorage(); var employee =storageObject.Authenticate(emailId,oldPassword); if (employee == null) { return false; } SqlConnection con = new SqlConnection("Data Source=TRAINING12;Initial Catalog=Employee;User ID=sa;Password=test123!@#"); con.Open(); SqlCommand cmd = new SqlCommand("UpdatePassword", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Password", newPassword)); cmd.Parameters.Add(new SqlParameter("@Id", employee.Id)); cmd.ExecuteNonQuery(); con.Close(); return true; }