public ActionResult ChangePassword(EmployeePassword model)
{
try
{
if (string.IsNullOrEmpty(model.password))
{
ModelState.AddModelError("password", "Old password expected");
}
if (string.IsNullOrEmpty(model.nPassword))
{
ModelState.AddModelError("nPassword", "New password expected");
}
if (string.IsNullOrEmpty(model.aPassword))
{
ModelState.AddModelError("aPassword", "Password expected");
}
CatelogBLL.ChangePassword(model.Id, model.password, model.nPassword, model.aPassword);
return(RedirectToAction("Input/" + model.Id));
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message + ":" + ex.StackTrace);
return(View(model));
}
}
// Hàm để lưu thông tin password của nhân viên lấy từ database
public void AddEmployeePassToList()
{
using (SqlConnection connection = new SqlConnection(ConnectionString.connectionString)) // khởi tạo kết nối đến database
{
connection.Open(); // mở kết nối đến database
string passwordSelect = "Select * from MATKHAUNV";
SqlCommand passwordList = new SqlCommand(passwordSelect, connection); // Truy xuất dữ liệu từ database
SqlDataReader passwordReader = passwordList.ExecuteReader(); // biến để đọc dữ liệu truy xuất và lưu vào list
while (passwordReader.Read())
{
EmployeePassword employee = new EmployeePassword(); // biến để lưu trữ các thông tin được đọc ra và đưa vào list
employee.EmployeeUserName = (string)passwordReader["USERNAME"]; // đọc dữ liệu đã truy xuất
employee.EmployeePass = (string)passwordReader["PASS"];
employee.AccessLevel = (int)passwordReader["ACCESSLEVEL"];
employeesPassword.Add(employee); // Lưu dữ liệu đã đọc vào list
}
connection.Close(); // ngắt kết nối đến database
}
}
public bool IsPasswordSet(EmployeePassword employee)
{
try
{
string Query = "SELECT * FROM tb_EmployeePassword WHERE (EmployeeId = @EmployeeId)";
SqlCommand Command = new SqlCommand(Query, con);
con.Open();
Command.Parameters.Clear();
Command.Parameters.Add("EmployeeId", SqlDbType.Int);
Command.Parameters["EmployeeId"].Value = employee.EmployeeId;
SqlDataReader Reader = Command.ExecuteReader();
Reader.Read();
bool isExist = Reader.HasRows;
Reader.Close();
return(isExist);
}
catch (Exception exception)
{
throw new Exception("Unable to connect Server", exception);
}
finally
{
con.Close();
}
}
public bool IsPasswordSet(EmployeePassword employee)
{
try
{
const string query = "select * from EmployeePassword where (EmployeeId = @EmployeeId)";
var command = new SqlCommand(query, Connection);
Connection.Open();
command.Parameters.Clear();
command.Parameters.Add("EmployeeId", SqlDbType.Int);
command.Parameters["EmployeeId"].Value = employee.EmployeeId;
SqlDataReader reader = command.ExecuteReader();
reader.Read();
bool isExist = reader.HasRows;
reader.Close();
return(isExist);
}
catch (Exception exception)
{
throw new Exception("Unable to connect server", exception);
}
finally
{
Connection.Close();
}
}
public ActionResult EmployeePassword(EmployeePassword employeeInfo)
{
if (ModelState.IsValid)
{
try
{
if (superadminManager.IsPasswordSet(employeeInfo))
{
ViewBag.ShowMsg = "Password Was Already Set!";
}
else
{
int message = superadminManager.EmployeePassword(employeeInfo);
if (message > 0)
{
ViewBag.ShowMsg = "Employee Password Saved Successfully!";
}
else
{
ViewBag.ShowMsg = "Sorry! Data Not Saved! Please Try Again";
}
}
}
catch (Exception exception)
{
ViewBag.ShowMsg = exception.Message;
}
}
ViewBag.userType = superadminManager.GetUserType();
ViewBag.designations = superadminManager.GetDesignationList();
ViewBag.ListOfEmployees = superadminManager.ListOfEmployee();
return(View());
}
public ActionResult ChangePassword(EmployeePassword model)
{
try
{
if (string.IsNullOrEmpty(model.password))
{
ModelState.AddModelError("password", "Old password expected");
}
if (string.IsNullOrEmpty(model.nPassword))
{
ModelState.AddModelError("nPassword", "New password expected");
}
if (string.IsNullOrEmpty(model.nlPassword))
{
ModelState.AddModelError("nlPassword", "Password expected");
}
model.password = MD5Helper.EncodeMD5(model.password);
model.nPassword = MD5Helper.EncodeMD5(model.nPassword);
model.nlPassword = MD5Helper.EncodeMD5(model.nlPassword);
EmployeeBLL.ChangePassword(model.Id, model.password, model.nPassword, model.nlPassword);
return(RedirectToAction("Index", "Dashboard"));
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message + ":" + ex.StackTrace);
return(View(model));
}
}
public async Task <ActionResult> ChangePassword(EmployeePassword employeePassword)
{
if (!ModelState.IsValid)
{
return(View(new EmployeePassword()));
}
if (!employeePassword.Password.Equals(employeePassword.ConfirmPassword))
{
ModelState.AddModelError("", _DataLocalizer["Password and confirmation not matches"]);
return(View(employeePassword));
}
var currentUser = await _UserManager.GetUserAsync(User);
var result = await _UserManager.ChangePasswordAsync(currentUser, employeePassword.OldPassword, employeePassword.Password);
if (!result.Succeeded)
{
foreach (var error in result.Errors)
{
ModelState.AddModelError(error.Code, error.Description);
}
return(View(new EmployeePassword()));
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult SetEmployeePassword(EmployeePassword employee)
{
if (ModelState.IsValid)
{
try
{
if (_passwordAndDesignation.IsPasswordSet(employee))
{
ViewBag.ShowMsg = "Password set alrady.";
}
else
{
int message = _passwordAndDesignation.SetEmployeePassword(employee);
if (message > 0)
{
ViewBag.ShowMsg = "Password Saved Successfully!";
}
else
{
ViewBag.ShowMsg = "Opps! Data Not Saved! Try Again Please";
}
}
}
catch (Exception exception)
{
ViewBag.ShowMsg = exception.Message;
}
}
ViewBag.userType = _passwordAndDesignation.GetUserType();
ViewBag.ListOfEmployees = _passwordAndDesignation.ListOfEmployee();
return(View());
}
public async Task <ActionResult <EmployeePassword> > PostEmployeePassword(EmployeePassword employeePassword)
{
_context.EmployeePasswords.Add(employeePassword);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetEmployeePassword", new { id = employeePassword.Id }, employeePassword));
}
public async Task <IActionResult> PutEmployeePassword(int id, EmployeePassword employeePassword)
{
if (id != employeePassword.Id)
{
return(BadRequest());
}
_context.Entry(employeePassword).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeePasswordExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult ChangePassword(string Id = "")
{
EmployeePassword accountPassword = new EmployeePassword()
{
Id = Convert.ToInt32(Id)
};
ViewBag.Title = "ChangePassword";
return(View(accountPassword));
}
public HttpResponseMessage PostEmployeePassword(EmployeePassword employee)
{
var messages = _passwordAndDesignation.SetEmployeePassword(employee);
if (messages != null)
{
var message = Request.CreateResponse(HttpStatusCode.Created, messages);
return(message);
}
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Category not created"));
}
public string SetEmployeePassword(EmployeePassword employee)
{
if (_passwordAndDesignation.IsPasswordSet(employee))
{
return("Password set alrady.");
}
if (_passwordAndDesignation.SetEmployeePassword(employee) > 0)
{
return("Password Saved Successfully!");
}
return("Password Save Faild");
// return _passwordAndDesignation.SetEmployeePassword(employee);
}
public int SetEmployeePassword(EmployeePassword employee)
{
string query = "INSERT INTO EmployeePassword (EmployeeId,Password) VALUES ('" + employee.EmployeeId + "','" + employee.Password + "')";
try
{
var command = new SqlCommand(query, Connection);
Connection.Open();
int rowAffected = command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
catch (Exception exception)
{
throw new Exception("Unable to connect Server", exception);
}
finally
{
Connection.Close();
}
}
public string Post([FromBody] EmployeePassword employeePassword)
{
try
{
var filteredData = _db.tbEmployee.AsQueryable();
List <tbEmployee> tbEmployee = null;
SHA256 sha256; //建立一個SHA256
byte[] source; //將字串轉為Byte[]
byte[] crypto; //進行SHA256加密
string result; //把加密後的字串從Byte[]轉為字串
filteredData = filteredData.Where(b => b.EmployeeNo == employeePassword.EmployeeNo);
tbEmployee = filteredData.ToList();
if (tbEmployee.Count == 1)
{
sha256 = new SHA256CryptoServiceProvider(); //建立一個SHA256
source = Encoding.Default.GetBytes(employeePassword.NewPassword); //將字串轉為Byte[]
crypto = sha256.ComputeHash(source); //進行SHA256加密
result = Convert.ToBase64String(crypto); //把加密後的字串從Byte[]轉為字串
tbEmployee[0].PassWord = result;
_db.SaveChanges();
}
else
{
return("無法取得該員工資訊!!");
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("success");
}
public int SetEmployeePassword(EmployeePassword employee)
{
string query = @"INSERT INTO [dbo].[tb_EmployeePassword]
([EmployeeId]
,[Password])
VALUES
('" + employee.EmployeeId + "','" + employee.Password + "')";
try
{
SqlCommand command = new SqlCommand(query, con);
con.Open();
int rowAffected = command.ExecuteNonQuery();
return(rowAffected);
}
catch (Exception exception)
{
throw new Exception("Unable to connect Server", exception);
}
finally
{
con.Close();
}
}
public static void Initialize(HindsiteContext context)
{
if (context.Clients.Any())
{
return;
}
//Clients
var clients = new Client[]
{
new Client
{
CompanyName = "Jonah Energy",
Location = "Jonah Energy LLC, 83 Luman Road Pinedale, WY 82941, Boulder, WY 82923"
},
new Client
{
CompanyName = "Linn Energy",
Location = "E Oklahoma Ave, Ulysses, KS 67880"
}
};
foreach (Client c in clients)
{
context.Clients.Add(c);
}
context.SaveChanges();
// Client Password Table
var clientPasswords = new ClientPassword[]
{
new ClientPassword
{
ClientUserName = "******",
ClientPasswords = "Password"
}
};
foreach (ClientPassword p in clientPasswords)
{
context.ClientPasswords.Add(p);
}
context.SaveChanges();
// Employee's
var employees = new Employee[]
{
new Employee
{
FirstName = "David",
LastName = "Jones"
},
new Employee
{
FirstName = "Nolan",
LastName = "Jones"
}
};
foreach (Employee e in employees)
{
context.Employees.Add(e);
}
context.SaveChanges();
// Employee Passwords Table
var employeePasswords = new EmployeePassword[]
{
new EmployeePassword
{
EmployeeUserName = "******",
EmployeePasswords = "Password"
}
};
foreach (EmployeePassword ep in employeePasswords)
{
context.EmployeePasswords.Add(ep);
}
context.SaveChanges();
// Gps Info table
var gpsInfos = new GpsInfo[]
{
new GpsInfo
{
GpsFile = "file address",
Locations = "SHB 101",
Date = DateTime.Parse("2019-07-10")
}
};
foreach (GpsInfo g in gpsInfos)
{
context.GpsInfoes.Add(g);
}
context.SaveChanges();
}
public bool IsPasswordSet(EmployeePassword employee)
{
return(_superadminGateway.IsPasswordSet(employee));
}
public int SetEmployeePassword(EmployeePassword employee)
{
return(_passwordAndDesignation.SetEmployeePassword(employee));
}
public bool IsPasswordSet(EmployeePassword employee)
{
return(_passwordAndDesignation.IsPasswordSet(employee));
}
public int EmployeePassword(EmployeePassword employee)
{
return(_superadminGateway.SetEmployeePassword(employee));
}
public ActionResult SetEmployeePassword(EmployeePassword employee)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:32331");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var response = client.PostAsJsonAsync("api/Password/PostEmployeePassword", employee).Result;
if (response.IsSuccessStatusCode)
{
string msg = response.Content.ReadAsStringAsync().Result;
var records = JsonConvert.DeserializeObject(msg); // JSON.Net
ViewBag.ShowMsg = records;
}
}
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:32331");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = client.GetAsync("api/Password/").Result;
string res = "";
using (HttpContent content = response.Content)
{
// ... Read the string.
Task <string> result = content.ReadAsStringAsync();
res = result.Result;
var records = JsonConvert.DeserializeObject <List <UserType> >(res); // JSON.Net
foreach (UserType record in records)
{
var category = (string.Format("Id: {0}, UserTypeName: {1}", record.Id, record.UserTypeName));
}
ViewBag.userType = records;
}
}
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:32331");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = client.GetAsync("api/Whouse/").Result;
string res = "";
using (HttpContent content = response.Content)
{
// ... Read the string.
Task <string> result = content.ReadAsStringAsync();
res = result.Result;
var records = JsonConvert.DeserializeObject <List <Employee> >(res); // JSON.Net
foreach (Employee record in records)
{
var category = (string.Format("Id: {0}, EmployeeName: {1}", record.Id, record.EmployeeName));
}
ViewBag.ListOfEmployees = records;
}
}
return(View());
}
