public async Task <IActionResult> UpdateDocMenuB1([FromBody] ModelMenuB1Edit model) { IActionResult _result = BadRequest(); ModelResponseMessageAddDocB1 e = await _IDocMenuBService.UpdateDocMenuB1Async(model); if (e.Status) { _result = Ok(e); try { await _IMailTemplateService.MailTemplate1Async(Convert.ToInt32(model.docid), e.filebase64); } catch (Exception ex) { //Keep } } else { _result = BadRequest(); } return(_result); }
public async Task <ModelResponseMessageAddDocB1> AddDocMenuB1Async(ModelMenuB1 model) { ModelResponseMessageAddDocB1 resp = new ModelResponseMessageAddDocB1(); if (string.IsNullOrWhiteSpace(model.projectid)) { 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"); resp = await _IDocMenuB1Repository.AddDocMenuB1Async(model); return(resp); }
public async Task <ModelResponseMessageAddDocB1> UpdateDocMenuB1Async(ModelMenuB1Edit model) { ModelResponseMessageAddDocB1 resp = new ModelResponseMessageAddDocB1(); try { var cultureInfo = new CultureInfo("en-GB"); CultureInfo.DefaultThreadCurrentCulture = cultureInfo; CultureInfo.DefaultThreadCurrentUICulture = cultureInfo; using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("sp_doc_menu_b1_edit", conn)) { cmd.CommandType = CommandType.StoredProcedure; string project_head = Encoding.UTF8.GetString(Convert.FromBase64String(model.projecthead)); 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("@accept_type", SqlDbType.VarChar, 2).Value = ParseDataHelper.ConvertDBNull(model.accepttype); cmd.Parameters.Add("@project_head", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(project_head); cmd.Parameters.Add("@project_id", SqlDbType.Int).Value = ParseDataHelper.ConvertDBNull(model.projectid); cmd.Parameters.Add("@project_name_thai", SqlDbType.NVarChar).Value = ParseDataHelper.ConvertDBNull(model.projectnamethai); cmd.Parameters.Add("@project_name_eng", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.projectnameeng); cmd.Parameters.Add("@acronyms", SqlDbType.VarChar, 3).Value = ParseDataHelper.ConvertDBNull(model.acronyms); cmd.Parameters.Add("@initial_result", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.initialresult); cmd.Parameters.Add("@file_download_name_title", SqlDbType.VarChar, 500).Value = ParseDataHelper.ConvertDBNull(model.filedownloadnametitle); 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("@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); 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; await cmd.ExecuteNonQueryAsync(); if ((int)cmd.Parameters["@rStatus"].Value > 0) { resp.Status = true; resp.DocNumber = (string)cmd.Parameters["@rMessage"].Value; model_rpt_8_file rpt = await _IDocMenuReportRepository.GetReportR8Async(Convert.ToInt32(model.docid)); resp.filename = rpt.filename; resp.filebase64 = rpt.filebase64; } else { resp.Message = (string)cmd.Parameters["@rMessage"].Value; } } conn.Close(); } } catch (Exception ex) { throw ex; } return(resp); }