public async Task <ModelRegisterEdit> GetEditDataByRegisterId(string UserId)
{
string sql = "SELECT A.*, (B.name_thai) AS position_name_thai, " +
"(C.name_thai) AS faculty_name_thai, (D.name_thai) AS education_name_thai, " +
"(E.name_thai) AS character_name_thai " +
"FROM RegisterUser A " +
"INNER JOIN MST_Position B ON A.position = B.id " +
"INNER JOIN MST_Faculty C ON A.faculty = C.id " +
"INNER JOIN MST_Education D ON A.education = D.id " +
"INNER JOIN MST_Character E ON A.character = E.id " +
"WHERE register_id ='" + UserId + "' ORDER BY full_name ASC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
ModelRegisterEdit item = new ModelRegisterEdit();
while (await reader.ReadAsync())
{
item.registerid = reader["register_id"].ToString();
item.email = reader["email"].ToString();
item.userid = reader["userid"].ToString();
item.passw = reader["passw"].ToString();
item.confirmpassw = reader["confirmpassw"].ToString();
item.firstname1 = reader["first_name_1"].ToString();
item.firstname2 = reader["first_name_2"].ToString();
item.firstname = reader["first_name"].ToString();
item.fullname = reader["full_name"].ToString();
item.position = reader["position"].ToString();
item.positionname = reader["position_name_thai"].ToString();
item.faculty = reader["faculty"].ToString();
item.facultyname = reader["faculty_name_thai"].ToString();
item.workphone = reader["work_phone"].ToString();
item.mobile = reader["mobile"].ToString();
item.fax = reader["fax"].ToString();
item.education = reader["education"].ToString();
item.educationname = reader["education_name_thai"].ToString();
item.character = reader["character"].ToString();
item.charactername = reader["character_name_thai"].ToString();
item.note1 = reader["note1"].ToString();
item.note2 = reader["note2"].ToString();
item.note3 = reader["note3"].ToString();
item.isactive = Convert.ToBoolean(reader["isActive"]);
}
return(item);
}
}
conn.Close();
}
return(null);
}
public async Task <IActionResult> UpdateUserRegisterAsync(ModelRegisterEdit model)
{
ModelResponseMessageUpdateUserRegister e = await _IDocMenuFService.UpdateUserRegisterAsync(model);
if (e.Status)
{
return(Ok());
}
else
{
return(BadRequest());
}
}
public async Task<IActionResult> UpdateUserRegister(ModelRegisterEdit model)
{
var requestUri = $"{_WebApiModel.BaseURL}/{"PrivateDocMenuF"}/{"UpdateUserRegister"}";
string authHeader = HttpContext.Request?.Headers["Authorization"];
if (authHeader != null && authHeader.StartsWith("Bearer"))
{
BearerToken = authHeader.Substring("Bearer ".Length).Trim();
}
var response = await HttpRequestFactory.Post(requestUri, BearerToken, model);
switch (response.StatusCode)
{
case HttpStatusCode.Unauthorized:
return Unauthorized(response.ContentAsString());
case HttpStatusCode.BadRequest:
return BadRequest(response.ContentAsString());
case HttpStatusCode.OK:
return Ok(response.ContentAsString());
default:
return StatusCode(500);
}
}
public async Task <ModelResponseMessageUpdateUserRegister> UpdateUserRegisterAsync(ModelRegisterEdit model)
{
ModelResponseMessageUpdateUserRegister resp = new ModelResponseMessageUpdateUserRegister();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_update_user_register", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RegisterId", SqlDbType.VarChar, 100).Value = model.registerid;
cmd.Parameters.Add("@Email", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.email);
cmd.Parameters.Add("@FirstName1", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.firstname1);
cmd.Parameters.Add("@FirstName2", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.firstname2);
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.firstname);
cmd.Parameters.Add("@FullName", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.fullname);
cmd.Parameters.Add("@WorkPhone", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.workphone);
cmd.Parameters.Add("@Mobile", SqlDbType.VarChar, 20).Value = ParseDataHelper.ConvertDBNull(model.mobile);
cmd.Parameters.Add("@Fax", SqlDbType.VarChar, 20).Value = ParseDataHelper.ConvertDBNull(model.fax);
cmd.Parameters.Add("@Position", SqlDbType.VarChar, 2).Value = model.position;
cmd.Parameters.Add("@Faculty", SqlDbType.VarChar, 2).Value = model.faculty;
cmd.Parameters.Add("@Education", SqlDbType.VarChar, 2).Value = model.education;
cmd.Parameters.Add("@Character", SqlDbType.VarChar, 2).Value = model.character;
cmd.Parameters.Add("@Note1", SqlDbType.NVarChar).Value = ParseDataHelper.ConvertDBNull(model.note1);
cmd.Parameters.Add("@Note2", SqlDbType.NVarChar).Value = ParseDataHelper.ConvertDBNull(model.note2);
cmd.Parameters.Add("@Note3", SqlDbType.NVarChar).Value = ParseDataHelper.ConvertDBNull(model.note3);
cmd.Parameters.Add("@IsActive", SqlDbType.Bit).Value = model.isactive;
SqlParameter rStatus = cmd.Parameters.Add("@rStatus", SqlDbType.Int);
rStatus.Direction = ParameterDirection.Output;
SqlParameter rMessage = cmd.Parameters.Add("@rMessage", SqlDbType.NVarChar, 500);
rMessage.Direction = ParameterDirection.Output;
await cmd.ExecuteNonQueryAsync();
if ((int)cmd.Parameters["@rStatus"].Value > 0)
{
resp.Status = true;
}
else
{
resp.Message = (string)cmd.Parameters["@rMessage"].Value;
}
}
conn.Close();
}
return(resp);
}
public async Task <ModelResponseMessageUpdateUserRegister> UpdateUserRegisterAsync(ModelRegisterEdit model)
{
return(await _IDocMenuF1Repository.UpdateUserRegisterAsync(model));
}
