public async Task <ModelResponseMessage> AddDocMenuE1Async(ModelMenuE1 model) { ModelResponseMessage resp = new ModelResponseMessage(); using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("sp_doc_menu_e1", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@section_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.sectionName); cmd.Parameters.Add("@faculty", SqlDbType.Int).Value = model.faculty; cmd.Parameters.Add("@department_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.departmentName); cmd.Parameters.Add("@phone", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.phone); cmd.Parameters.Add("@fax", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.fax); cmd.Parameters.Add("@email", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.email); cmd.Parameters.Add("@group_1_genus", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group1genus); cmd.Parameters.Add("@group_1_species", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group1species); cmd.Parameters.Add("@group_1_risk_human", SqlDbType.Int).Value = model.group1riskHuman; cmd.Parameters.Add("@group_1_risk_animal", SqlDbType.Int).Value = model.group1riskAnimal; cmd.Parameters.Add("@group_1_pathogens", SqlDbType.Int).Value = model.group1pathogens; cmd.Parameters.Add("@group_1_virus", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group1virus); cmd.Parameters.Add("@group_1_bacteria", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group1bacteria); cmd.Parameters.Add("@group_1_parasit", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group1paraSit); cmd.Parameters.Add("@group_1_mold", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group1mold); cmd.Parameters.Add("@group_1_protein", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group1protein); cmd.Parameters.Add("@group_2_genus", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group2genus); cmd.Parameters.Add("@group_2_species", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group2species); cmd.Parameters.Add("@group_2_risk_human", SqlDbType.Int).Value = model.group2riskHuman; cmd.Parameters.Add("@group_2_risk_animal", SqlDbType.Int).Value = model.group2riskAnimal; cmd.Parameters.Add("@group_2_pathogens", SqlDbType.Int).Value = model.group2pathogens; cmd.Parameters.Add("@group_2_virus", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group2virus); cmd.Parameters.Add("@group_2_bacteria", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group2bacteria); cmd.Parameters.Add("@group_2_parasit", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group2paraSit); cmd.Parameters.Add("@group_2_mold", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group2mold); cmd.Parameters.Add("@group_2_protein", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.group2protein); 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; } else { resp.Message = (string)cmd.Parameters["@rMessage"].Value; } } conn.Close(); } return(resp); }
public async Task <IActionResult> AddDocMenuE1([FromBody] ModelMenuE1 model) { ModelResponseMessage e = await _IDocMenuEService.AddDocMenuE1Async(model); if (e.Status) { return(Ok(e)); } else { return(BadRequest()); } }
public async Task <ModelResponseMessage> AddDocMenuE1Async(ModelMenuE1 model) { ModelResponseMessage resp = new ModelResponseMessage(); var cultureInfo = new CultureInfo("en-GB"); CultureInfo.DefaultThreadCurrentCulture = cultureInfo; CultureInfo.DefaultThreadCurrentUICulture = cultureInfo; model.docDate = DateTime.Now; resp = await _IDocMenuE1Repository.AddDocMenuE1Async(model); return(resp); }