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); }