public async Task <ModelResponseC22Message> AddDocMenuC22Async(ModelMenuC22 model)
{
var cultureInfo = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
ModelResponseC22Message resp = new ModelResponseC22Message();
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_doc_menu_c2_2", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
string assigner_code = Encoding.UTF8.GetString(Convert.FromBase64String(model.assignercode));
cmd.Parameters.Add("@assigner_code", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(assigner_code);
cmd.Parameters.Add("@position_name", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.positionname);
cmd.Parameters.Add("@assigner_seq", SqlDbType.Int).Value = ParseDataHelper.ConvertDBNull(model.assignerseq);
cmd.Parameters.Add("@project_number", SqlDbType.VarChar, 20).Value = ParseDataHelper.ConvertDBNull(model.projectnumber);
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("@safety_type", SqlDbType.VarChar, 2).Value = ParseDataHelper.ConvertDBNull(model.safetytype);
cmd.Parameters.Add("@approval_type", SqlDbType.VarChar, 2).Value = ParseDataHelper.ConvertDBNull(model.approvaltype);
cmd.Parameters.Add("@comment_consider", SqlDbType.VarChar).Value = ParseDataHelper.ConvertDBNull(model.commentconsider);
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();
}
}
catch (Exception ex)
{
throw ex;
}
return(resp);
}
public async Task <IActionResult> AddDocMenuC22([FromBody] ModelMenuC22 model)
{
IActionResult _result = BadRequest();
ModelResponseC22Message e = await _IDocMenuCService.AddDocMenuC22Async(model);
if (e.Status)
{
return(Ok());
}
else
{
return(BadRequest(e));
}
}
