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