public async Task <ModelResponseC12Message> AddDocMenuC12Async(ModelMenuC12 model)
{
var cultureInfo = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
ModelResponseC12Message resp = new ModelResponseC12Message();
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_doc_menu_c1_2", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
string assigner_code = Encoding.UTF8.GetString(Convert.FromBase64String(model.assignercode));
cmd.Parameters.Add("@assigner_code", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(assigner_code);
cmd.Parameters.Add("@position_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.positionname);
cmd.Parameters.Add("@accept_type", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.accepttype);
cmd.Parameters.Add("@project_number", SqlDbType.VarChar, 20).Value = ParseDataHelper.ConvertDBNull(model.projectnumber);
cmd.Parameters.Add("@lab_type_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.labtypename);
cmd.Parameters.Add("@faculty_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.facultyname);
cmd.Parameters.Add("@board_code_array", SqlDbType.VarChar).Value = JsonConvert.SerializeObject(model.boardcodearray);
cmd.Parameters.Add("@speciallist_code_array", SqlDbType.VarChar).Value = JsonConvert.SerializeObject(model.speciallistcodearray);
cmd.Parameters.Add("@round_of_meeting", SqlDbType.Int).Value = model.roundofmeeting;
cmd.Parameters.Add("@year_of_meeting", SqlDbType.Int).Value = model.yearofmeeting;
cmd.Parameters.Add("@meeting_date", SqlDbType.DateTime).Value = Convert.ToDateTime(model.meetingdate);
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;
resp.EmailArray = await GetEmailUserC12Async(model);
}
else
{
resp.Message = (string)cmd.Parameters["@rMessage"].Value;
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(resp);
}
public async Task <ModelResponseC12Message> AddDocMenuC12Async(ModelMenuC12 model)
{
model.meetingdate = Convert.ToDateTime(model.meetingdate.Substring(0, 10)).ToString("yyyy-MM-dd");
var resp = await _IDocMenuC1Repository.AddDocMenuC12Async(model);
return(resp);
}
public async Task <string> GetEmailUserC12Async(ModelMenuC12 model)
{
if (model != null && model.boardcodearray != null && model.boardcodearray.Count > 0)
{
string register_id = string.Empty;
foreach (var item in model.boardcodearray)
{
register_id += Encoding.UTF8.GetString(Convert.FromBase64String(item.value)) + "','";
}
if (!string.IsNullOrEmpty(register_id))
{
register_id = register_id.Remove(register_id.Length - 3, 3).ToString();
}
string sql = "SELECT email FROM RegisterUser WHERE register_id IN('" + register_id + "')";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
string email_list = "";
while (await reader.ReadAsync())
{
email_list += reader["email"].ToString() + ",";
}
if (!string.IsNullOrEmpty(email_list))
{
email_list = email_list.Remove(email_list.Length - 1, 1).ToString();
}
return(email_list);
}
}
conn.Close();
}
}
return(string.Empty);
}
public async Task <IActionResult> AddDocMenuC12([FromBody] ModelMenuC12 model)
{
IActionResult _result = BadRequest();
ModelResponseC12Message e = await _IDocMenuCService.AddDocMenuC12Async(model);
if (e.Status == true)
{
_result = Ok(e);
//string serverip = Encoding.UTF8.GetString(Convert.FromBase64String(_EnvironmentConfig.Server));
//string linkactive = $"{serverip}/{"efilling/log_in"}";
//string mail_body = "<h3>เรื่อง ขอความร่วมมือพิจารณาห้องปฏิบัติการ</h3>" + Environment.NewLine +
// "<h2>ตามบันทึกไฟล์แนบ</h2></br>" + Environment.NewLine +
// "<h4>คุณสามารถดูเอกสารไฟล์แนบได้โดย <a href='" + linkactive + "'>คลิ้กเพื่อไปยังหน้าเพจ</a>.</h4>";
//await EmailHelper.SentGmail(e.EmailArray, "eFilling : ขอความร่วมมือพิจารณาห้องปฏิบัติการ", mail_body);
}
return(_result);
}
