public async Task <ModelResponseMessageAddDocB2> AddDocMenuB2Async(ModelMenuB2 model)
{
ModelResponseMessageAddDocB2 resp = new ModelResponseMessageAddDocB2();
if (string.IsNullOrWhiteSpace(model.labNumber))
{
resp.Status = false;
resp.Message = "กรุณาเลือก ประเภทห้องปฏิบัติการ!";
return(resp);
}
if (string.IsNullOrWhiteSpace(model.meetingdate))
{
resp.Status = false;
resp.Message = "กรุณาระบุ กำหนดวันที่ประชุม!";
return(resp);
}
var cultureInfo = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
model.docdate = DateTime.Now;
model.meetingdate = Convert.ToDateTime(model.meetingdate.Substring(0, 10)).ToString("yyyy-MM-dd");
//model.projecthead = Encoding.UTF8.GetString(Convert.FromBase64String(model.projecthead));
resp = await _IDocMenuB2Repository.AddDocMenuB2Async(model);
return(resp);
}
public async Task <IActionResult> AddDocMenuB2([FromBody] ModelMenuB2 model)
{
ModelResponseMessageAddDocB2 e = await _IDocMenuBService.AddDocMenuB2Async(model);
if (e.Status)
{
return(Ok(e));
}
else
{
return(BadRequest());
}
}
public async Task <ModelResponseMessageAddDocB2> AddDocMenuB2Async(ModelMenuB2 model)
{
var cultureInfo = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
ModelResponseMessageAddDocB2 resp = new ModelResponseMessageAddDocB2();
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_doc_menu_b2", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@doc_date", SqlDbType.DateTime).Value = model.docdate.ToString("yyyy-MM-dd");
cmd.Parameters.Add("@accept_type", SqlDbType.VarChar, 2).Value = ParseDataHelper.ConvertDBNull(model.accepttype);
cmd.Parameters.Add("@project_id", SqlDbType.Int).Value = model.projectid;
char[] spearator = { ':' };
string[] lab_number = model.labNumber.Split(spearator, System.StringSplitOptions.RemoveEmptyEntries);
cmd.Parameters.Add("@lab_number", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(lab_number[0].ToString().Trim());
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("@initial_result", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.initialresult);
cmd.Parameters.Add("@file_download_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.filedownloadname);
cmd.Parameters.Add("@project_key_number", SqlDbType.VarChar, 20).Value = ParseDataHelper.ConvertDBNull(model.projectkeynumber);
cmd.Parameters.Add("@notes", SqlDbType.NVarChar).Value = ParseDataHelper.ConvertDBNull(model.notes);
cmd.Parameters.Add("@acronyms", SqlDbType.NVarChar).Value = ParseDataHelper.ConvertDBNull(model.acronyms);
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("@year_of_running", SqlDbType.Int).Value = model.defaultyear;
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;
SqlParameter rDocId = cmd.Parameters.Add("@rDocId", SqlDbType.Int);
rDocId.Direction = ParameterDirection.Output;
await cmd.ExecuteNonQueryAsync();
if ((int)cmd.Parameters["@rStatus"].Value > 0)
{
resp.Status = true;
resp.DocNumber = (string)cmd.Parameters["@rMessage"].Value;
}
else
{
resp.Message = (string)cmd.Parameters["@rMessage"].Value;
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(resp);
}
