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)); }