public async Task <ModelRegisterActive> GetRegisterUserActiveAsync(string RegisterId)
{
var register_user = await _IRegisterUserRepository.GetRegisterUserActiveAsync(RegisterId);
if (register_user != null && !string.IsNullOrEmpty(register_user.register_id))
{
ModelRegisterActive model = new ModelRegisterActive();
model.registerid = register_user.register_id;
model.userid = register_user.userid;
model.passw = register_user.passw;
model.confirmpassw = register_user.confirmpassw;
model.email = register_user.email;
model.registerdate = register_user.register_date;
model.registerexpire = register_user.register_expire;
model.firstname1 = register_user.first_name_1;
model.firstname2 = register_user.first_name_2;
model.firstname = register_user.first_name;
model.fullname = register_user.full_name;
model.faculty = register_user.faculty;
model.position = register_user.position;
model.workphone = register_user.work_phone;
model.mobile = register_user.mobile;
model.fax = register_user.fax;
model.education = register_user.education;
model.character = register_user.character;
model.note1 = register_user.mobile;
model.note2 = register_user.note2;
model.note3 = register_user.note3;
model.isactive = register_user.isactive;
return(model);
}
return(null);
}
public async Task <IActionResult> RegisterActive([FromBody] ModelRegisterActive model)
{
var requestUri = $"{_WebApiModel.BaseURL}/{"PrivateRegister"}/{"RegisterActive"}";
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 <ModelRegisterActive> GetUserAccountInfoByRegisterId(string RegisterId)
{
//string register_id = Encoding.UTF8.GetString(Convert.FromBase64String(RegisterId));
string sql = "SELECT * FROM RegisterUser WHERE register_id ='" + RegisterId + "'";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
ModelRegisterActive item = new ModelRegisterActive();
while (await reader.ReadAsync())
{
item.registerid = reader["register_id"].ToString();
item.email = reader["email"].ToString();
}
return(item);
}
}
conn.Close();
}
return(null);
}
public async Task <IActionResult> GetFullRegisterUserById(string RegisterId)
{
string registerId = Encoding.UTF8.GetString(Convert.FromBase64String(RegisterId));
ModelRegisterActive e = await _IRegisterUserService.GetFullRegisterUserByIdAsync(registerId);
if (e != null)
{
return(Ok(e));
}
return(BadRequest());
}
public async Task <ModelRegisterActive> GetFullRegisterUserByIdAsync(string RegisterId)
{
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 " +
"LEFT OUTER JOIN MST_Position B ON A.position = B.id " +
"LEFT OUTER JOIN MST_Faculty C ON A.faculty = C.id " +
"LEFT OUTER JOIN MST_Education D ON A.education = D.id " +
"LEFT OUTER JOIN MST_Character E ON A.character = E.id " +
"WHERE A.IsActive = '1' AND register_id ='" + RegisterId + "' 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)
{
ModelRegisterActive item = new ModelRegisterActive();
while (await reader.ReadAsync())
{
item.registerid = System.Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(reader["register_id"].ToString()));
item.confirmpassw = reader["full_name"].ToString();
item.email = reader["email"].ToString();
item.firstname = reader["first_name"].ToString();
item.fullname = reader["full_name"].ToString();
item.faculty = reader["faculty"].ToString();
item.facultyname = reader["faculty_name_thai"].ToString();
item.position = reader["position"].ToString();
item.positionname = reader["position_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 = (bool)reader["isactive"];
}
return(item);
}
}
conn.Close();
}
return(null);
}
public async Task <IActionResult> RegisterActive([FromBody] ModelRegisterActive model)
{
IActionResult _result = BadRequest();
CancellationTokenSource source = new CancellationTokenSource();
var tasks = Task.Run(async delegate
{
ModelResponseMessageRegisterActive e = await _IRegisterUserService.AddRegisterActiveAsync(model);
if (e.Status == true)
{
_result = Ok(e);
string serverip = Encoding.UTF8.GetString(Convert.FromBase64String(_EnvironmentConfig.Server));
string register_id = Encoding.UTF8.GetString(Convert.FromBase64String(model.registerid));
string linkactive = $"{serverip}/{"efilling/log_in"}";
string mail_body = "<h3>คุณได้ลงทะเบียนเสร็จสิ้นตามขั้นตอนแล้ว</h3>" + Environment.NewLine +
"<h2>อ้างอิงหมายเลข " + register_id + "</h2>" + Environment.NewLine +
"<h4>ทั้งนี้คุณสามารถเข้าใช้งานระบบ ขอให้ท่านสนุกกับการใช้งาน! <a href='" + linkactive + "'>คลิ้กเพื่อเข้าสู่ระบบ</a>.</h4>";
await _EmailHelper.SentGmail(model.email, "eFilling : แจ้งผลการยืนยันลงทะเบียน", mail_body, "");
}
return(_result);
});
source.Cancel();
try
{
tasks.Wait();
}
catch (AggregateException ae)
{
foreach (var e in ae.InnerExceptions)
{
Console.WriteLine("{0}: {1}", e.GetType().Name, e.Message);
}
}
if (tasks.Status == TaskStatus.RanToCompletion)
{
source.Dispose();
}
return(_result);
}
public async Task <ModelRegisterActive> GetRegisterUserInActiveAsync(string RegisterId)
{
var register_user = await _IRegisterUserRepository.GetRegisterUserInActiveAsync(RegisterId);
if (register_user != null && !string.IsNullOrEmpty(register_user.register_id))
{
ModelRegisterActive model = new ModelRegisterActive();
model.registerid = register_user.register_id;
model.userid = register_user.userid;
model.email = register_user.email;
model.registerdate = register_user.register_date;
model.registerexpire = register_user.register_expire;
return(model);
}
return(null);
}
public async Task <ModelResponseMessageRegisterActive> AddRegisterActiveAsync(ModelRegisterActive model)
{
ModelResponseMessageRegisterActive resp = new ModelResponseMessageRegisterActive();
EntityRegisterUser entity_model = new EntityRegisterUser();
entity_model.register_id = Encoding.UTF8.GetString(Convert.FromBase64String(model.registerid));
entity_model.first_name_1 = model.firstname1;
entity_model.first_name_2 = model.firstname2;
entity_model.first_name = model.firstname;
entity_model.full_name = model.fullname;
entity_model.position = model.position;
entity_model.work_phone = model.workphone;
entity_model.faculty = model.faculty;
entity_model.mobile = model.mobile;
entity_model.fax = model.fax;
entity_model.education = model.education;
entity_model.character = model.character;
entity_model.note1 = model.note1;
entity_model.note2 = model.note2;
entity_model.note3 = model.note3;
entity_model.confirm_date = DateTime.Now;
entity_model.member_expire = DateTime.Now.AddYears(10);
resp = await _IRegisterUserRepository.AddRegisterActiveAsync(entity_model);
return(resp);
}
