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) { var requestUri = $"{_WebApiModel.BaseURL}/{"PrivateDocMenuB"}/{"AddDocMenuB2"}"; 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 <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); }