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);
}
public async Task <ModelResponseMessageRegisterUser> AddRegisterUserAsync(EntityRegisterUser entity_model)
{
ModelResponseMessageRegisterUser resp = new ModelResponseMessageRegisterUser();
var cultureInfo = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
var LicenseKey = GenerateToken.GetToken();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_register_user", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RegisterId", SqlDbType.VarChar, 100).Value = DateTime.Now.ToString("yyyyMMdd");
cmd.Parameters.Add("@LicenseKey", SqlDbType.NVarChar).Value = LicenseKey;
cmd.Parameters.Add("@UserId", SqlDbType.VarChar, 200).Value = entity_model.userid;
cmd.Parameters.Add("@Passw", SqlDbType.NVarChar, 500).Value = entity_model.passw;
cmd.Parameters.Add("@ConfirmPassw", SqlDbType.NVarChar, 500).Value = entity_model.confirmpassw;
cmd.Parameters.Add("@Email", SqlDbType.VarChar, 250).Value = entity_model.email;
cmd.Parameters.Add("@RegisterDate", SqlDbType.DateTime).Value = entity_model.register_date;
cmd.Parameters.Add("@ExpireDate", SqlDbType.DateTime).Value = entity_model.register_expire;
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;
SqlParameter rRegisterId = cmd.Parameters.Add("@rRegisterId", SqlDbType.VarChar, 100);
rRegisterId.Direction = ParameterDirection.Output;
await cmd.ExecuteNonQueryAsync();
if ((int)cmd.Parameters["@rStatus"].Value > 0)
{
resp.Status = true;
resp.RegisterId = cmd.Parameters["@rRegisterId"].Value.ToString();
}
else
{
resp.Message = cmd.Parameters["@rMessage"].Value.ToString();
}
}
conn.Close();
}
return(resp);
}
public async Task <ModelResponseMessageRegisterUser> AddRegisterUserAsync(ModelRegisterUser model)
{
ModelResponseMessageRegisterUser resp = new ModelResponseMessageRegisterUser();
if (model.passw == model.confirmpassw)
{
EntityRegisterUser entity_model = new EntityRegisterUser();
entity_model.userid = model.userid;
entity_model.passw = GenerateToken.GetPassword(model.passw);
entity_model.confirmpassw = GenerateToken.GetPassword(model.confirmpassw);
entity_model.email = model.email;
entity_model.register_date = DateTime.Now;
entity_model.register_expire = DateTime.Now.AddDays(3);
resp = await _IRegisterUserRepository.AddRegisterUserAsync(entity_model);
}
else
{
resp.Message = "Password no match.";
}
return(resp);
}
public async Task <ModelResponseMessageRegisterActive> AddRegisterActiveAsync(EntityRegisterUser model)
{
ModelResponseMessageRegisterActive resp = new ModelResponseMessageRegisterActive();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_register_active", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RegisterId", SqlDbType.VarChar, 100).Value = model.register_id;
cmd.Parameters.Add("@FirstName1", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.first_name_1);
cmd.Parameters.Add("@FirstName2", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.first_name_2);
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.first_name);
cmd.Parameters.Add("@FullName", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.full_name);
cmd.Parameters.Add("@Position", SqlDbType.VarChar, 2).Value = ParseDataHelper.ConvertDBNull(model.position);
cmd.Parameters.Add("@Faculty", SqlDbType.VarChar, 2).Value = ParseDataHelper.ConvertDBNull(model.faculty);
cmd.Parameters.Add("@WorkPhone", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.work_phone);
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("@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("@ConfirmDate", SqlDbType.DateTime).Value = model.confirm_date;
cmd.Parameters.Add("@MemberExpire", SqlDbType.DateTime).Value = model.member_expire;
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);
}
