public async Task <IActionResult> AddDocMenuD2([FromBody] ModelMenuD2 model)
{
var requestUri = $"{_WebApiModel.BaseURL}/{"PrivateDocMenuD"}/{"AddDocMenuD2"}";
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 <ModelResponseD2Message> AddDocMenuD2Async(ModelMenuD2 model)
{
var cultureInfo = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
ModelResponseD2Message resp = new ModelResponseD2Message();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_doc_menu_d2", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@project_number", SqlDbType.VarChar, 20).Value = ParseDataHelper.ConvertDBNull(model.projectnumber);
cmd.Parameters.Add("@project_head_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.projectheadname);
cmd.Parameters.Add("@project_name_thai", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.projectnamethai);
cmd.Parameters.Add("@project_name_eng", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.projectnameeng);
cmd.Parameters.Add("@file_download_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.filedownloadname);
cmd.Parameters.Add("@agenda_number", SqlDbType.Int).Value = model.agendanumber;
cmd.Parameters.Add("@year_of_meeting", SqlDbType.Int).Value = model.yearofmeeting;
cmd.Parameters.Add("@agenda_meeting_date", SqlDbType.DateTime).Value = Convert.ToDateTime(model.agendameetingdate);
cmd.Parameters.Add("@suggestion", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.acceptTypeNameThai);
cmd.Parameters.Add("@remark_suggestion", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.remarkApproval);
cmd.Parameters.Add("@conclusion_date", SqlDbType.DateTime).Value = Convert.ToDateTime(model.conclusiondate);
cmd.Parameters.Add("@create_by", SqlDbType.VarChar, 50).Value = Encoding.UTF8.GetString(Convert.FromBase64String(model.createby));
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;
}
else
{
resp.Message = (string)cmd.Parameters["@rMessage"].Value;
}
}
conn.Close();
}
return(resp);
}
public async Task <IActionResult> AddDocMenuD2([FromBody] ModelMenuD2 model)
{
ModelResponseD2Message e = await _IDocMenuDService.AddDocMenuD2Async(model);
if (e.Status)
{
return(Ok(e));
}
else
{
return(BadRequest());
}
}
public async Task <ModelResponseD2Message> AddDocMenuD2Async(ModelMenuD2 model)
{
ModelResponseD2Message resp = new ModelResponseD2Message();
var cultureInfo = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
model.docdate = DateTime.Now;
model.agendameetingdate = Convert.ToDateTime(model.agendameetingdate.Substring(0, 10)).ToString("yyyy-MM-dd");
model.conclusiondate = DateTime.Now.ToString("yyyy-MM-dd");
resp = await _IDocMenuD2Repository.AddDocMenuD2Async(model);
return(resp);
}
