public async Task <IActionResult> AddDocMenuD1([FromBody] ModelMenuD1 model)
{
var requestUri = $"{_WebApiModel.BaseURL}/{"PrivateDocMenuD"}/{"AddDocMenuD1"}";
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));
}
}
private async Task <ModelMenuD1> GetMenuD1DataEditAsync(string ProjectNumber, string userid, ModelPermissionPage permission)
{
string user_id = Encoding.UTF8.GetString(Convert.FromBase64String(userid));
string sql = "SELECT TOP(1) A.*, B.name_thai as accept_result_name, " +
"(CASE WHEN A.acceptCondition = 1 THEN 'แบบปีต่อปี' ELSE 'ไม่มีวันหมอายุ' END) as accept_condition_name " +
"FROM Doc_MenuD1 A " +
"LEFT OUTER JOIN MST_AcceptResult B ON A.acceptResult = B.id " +
"WHERE project_number = '" + ProjectNumber + "' ORDER BY doc_id DESC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
ModelMenuD1 e = new ModelMenuD1();
while (await reader.ReadAsync())
{
e.docid = reader["doc_id"].ToString();
e.projectnumber = reader["project_number"].ToString();
e.projectheadname = reader["project_head_name"].ToString();
e.facultyname = reader["faculty_name"].ToString();
e.advisorsnamethai = reader["advisorsNameThai"].ToString();
e.acceptprojectno = reader["acceptProjectNo"].ToString();
e.projectnamethai = reader["project_name_thai"].ToString();
e.projectnameeng = reader["project_name_eng"].ToString();
e.accepttypenamethai = reader["accept_type_name"].ToString();
e.acceptresult = Convert.ToInt16(reader["acceptResult"]);
e.acceptresultname = reader["accept_result_name"].ToString();
e.acceptcondition = Convert.ToInt16(reader["acceptCondition"]);
e.acceptconditionname = reader["accept_condition_name"].ToString();
e.acceptdate = Convert.ToDateTime(reader["AcceptDate"]).ToString("dd/MM/yyyy");
e.createby = reader["create_by"].ToString();
}
e.listRenewDate = new List <ModelMenuD1RenewTable>();
e.listRenewDate = await GetListRenewDateAsync(ProjectNumber);
//Default Edit False
e.editenable = false;
if (permission.edit == true)
{
if (user_id == e.createby)
{
e.editenable = true;
}
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <ModelResponseD1Message> UpdateDocMenuD1EditAsync(ModelMenuD1 model)
{
ModelResponseD1Message resp = new ModelResponseD1Message();
var cultureInfo = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
model.docdate = DateTime.Now;
resp = await _IDocMenuD1Repository.UpdateDocMenuD1EditAsync(model);
return(resp);
}
public async Task <IActionResult> AddDocMenuD1([FromBody] ModelMenuD1 model)
{
ModelResponseD1Message e = await _IDocMenuDService.AddDocMenuD1Async(model);
if (e.Status)
{
await _IMailTemplateService.MailTemplate2Async(model.projectnumber, e.filebase64);
return(Ok(e));
}
else
{
return(BadRequest());
}
}
public async Task <ModelResponseD1Message> UpdateDocMenuD1EditAsync(ModelMenuD1 model)
{
var cultureInfo = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
ModelResponseD1Message resp = new ModelResponseD1Message();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_doc_menu_d1_edit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@doc_id", SqlDbType.Int).Value = model.docid;
cmd.Parameters.Add("@doc_date", SqlDbType.DateTime).Value = model.docdate.ToString("yyyy-MM-dd");
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("@faculty_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.facultyname);
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("@accept_type_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.accepttypenamethai);
cmd.Parameters.Add("@advisorsNameThai", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.advisorsnamethai);
cmd.Parameters.Add("@acceptProjectNo", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.acceptprojectno);
cmd.Parameters.Add("@acceptResult", SqlDbType.Int).Value = model.acceptresult;
cmd.Parameters.Add("@acceptCondition", SqlDbType.Int).Value = model.acceptcondition;
cmd.Parameters.Add("@create_by", SqlDbType.VarChar, 50).Value = Encoding.UTF8.GetString(Convert.FromBase64String(model.createby));
// จริงๆไม่ต้องใช้แล้ว ------------------------------------------------------------------------------
cmd.Parameters.Add("@acceptDate", SqlDbType.DateTime).Value = Convert.ToDateTime(DateTime.Now);
cmd.Parameters.Add("@expireDate", SqlDbType.DateTime).Value = Convert.ToDateTime(DateTime.Now);
//---------------------------------------------------------------------------------------------
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;
model_rpt_9_file rpt = await _IDocMenuReportRepository.GetReportR9Async(Convert.ToInt32(model.docid));
resp.filename = rpt.filename;
resp.filebase64 = rpt.filebase64;
}
else
{
resp.Message = (string)cmd.Parameters["@rMessage"].Value;
}
}
conn.Close();
}
return(resp);
}
