void SendResultInfoAsJson(UpdateEmployeeResponse res)
{
string strJson = JsonConvert.SerializeObject(res);
Response.ContentType = "application/json; charset=utf-8";
Response.Write(strJson);
Response.End();
}
void SendResultInfoAsJson(UpdateEmployeeResponse res)
{
string strJson = JsonConvert.SerializeObject(res);
Response.ContentType = "application/json; charset=utf-8";
Response.AppendHeader("Access-Control-Allow-Origin", "*");
Response.Write(strJson);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
UpdateEmployeeRequest req;
UpdateEmployeeResponse res = new UpdateEmployeeResponse();
res.error = String.Empty;
// 1. Deserialize the incoming Json.
try
{
req = GetRequestInfo();
}
catch (Exception ex)
{
res.error = ex.Message.ToString();
// Return the results as Json.
SendResultInfoAsJson(res);
return;
}
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
try
{
connection.Open();
string getUserInfo = "SELECT EmployeeID,UserName,Password,FirstName,LastName,Email,Phone,StoreID,JobType,Status FROM Employee WHERE EmployeeID = @EmployeeID";
SqlCommand getUserInfoCommand = new SqlCommand(getUserInfo, connection);
getUserInfoCommand.Parameters.Add("@EmployeeID", SqlDbType.Int);
getUserInfoCommand.Parameters["@EmployeeID"].Value = req.EmployeeID;
SqlDataReader reader = getUserInfoCommand.ExecuteReader();
if (!reader.HasRows)
{
res.error = "Employee not found";
SendResultInfoAsJson(res);
return;
}
else
{
reader.Read();
if (req.Password == null)
{
req.Password = Convert.ToString(reader["Password"]);
}
if (req.FirstName == null)
{
req.FirstName = Convert.ToString(reader["FirstName"]);
}
if (req.LastName == null)
{
req.LastName = Convert.ToString(reader["LastName"]);
}
if (req.Email == null)
{
req.Email = Convert.ToString(reader["Email"]);
}
if (req.Phone == null)
{
req.Phone = Convert.ToString(reader["Phone"]);
}
if (req.JobType == -1)
{
req.JobType = Convert.ToInt32(reader["JobType"]);
}
if (req.Status == -1)
{
req.Status = Convert.ToInt32(reader["Status"]);
}
}
reader.Close();
string sql = "UPDATE Employee SET Password = @Password, FirstName = @FirstName, LastName = @LastName, Email = @Email, Phone = @Phone, JobType = @JobType, Status = @Status WHERE EmployeeID = @EmployeeID";
SqlCommand updateEmp = new SqlCommand(sql, connection);
updateEmp.Parameters.Add("@EmployeeID", SqlDbType.Int);
updateEmp.Parameters.Add("@Password", SqlDbType.NVarChar);
updateEmp.Parameters.Add("@FirstName", SqlDbType.NVarChar);
updateEmp.Parameters.Add("@LastName", SqlDbType.NVarChar);
updateEmp.Parameters.Add("@Email", SqlDbType.NVarChar);
updateEmp.Parameters.Add("@Phone", SqlDbType.NVarChar);
updateEmp.Parameters.Add("@JobType", SqlDbType.Int);
updateEmp.Parameters.Add("@Status", SqlDbType.Int);
updateEmp.Parameters["@EmployeeID"].Value = req.EmployeeID;
updateEmp.Parameters["@Password"].Value = req.Password;
updateEmp.Parameters["@FirstName"].Value = req.FirstName;
updateEmp.Parameters["@LastName"].Value = req.LastName;
updateEmp.Parameters["@Email"].Value = req.Email;
updateEmp.Parameters["@Phone"].Value = req.Phone;
updateEmp.Parameters["@JobType"].Value = req.JobType;
updateEmp.Parameters["@Status"].Value = req.Status;
updateEmp.ExecuteNonQuery();
}
catch (Exception ex)
{
res.error = ex.Message.ToString();
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
// Return the results as Json.
SendResultInfoAsJson(res);
}
public UpdateEmployeeResponse UpdateEmployee(UpdateEmployeeRequest updateEmployeeRequest)
{
UpdateEmployeeResponse response = new UpdateEmployeeResponse();
try
{
var employee = this.employeeRepository.FindById(updateEmployeeRequest.Id);
if (employee != null)
{
Gender gender;
Gender.TryParse(updateEmployeeRequest.EmployeePorperties.Gender, out gender);
employee.UpdateEmployeeData(updateEmployeeRequest.EmployeePorperties.FirstName,
updateEmployeeRequest.EmployeePorperties.LastName,
updateEmployeeRequest.EmployeePorperties.BirthDate,
gender
);
}
}
catch (Exception ex)
{
response.Exception = ex;
}
this.employeeRepository.Save();
return response;
}
