public IHttpActionResult Post(int syncId, [FromBody] LemHeader log)
{
try
{
using (SqlConnection sqlcon = new SqlConnection(WebCommon.WebConnection))
{
sqlcon.Open();
string sSQL = @"WS_FLEM_LogHeader_PostPut";
using (SqlCommand cmd = new SqlCommand(sSQL, sqlcon))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paraMatchId;
SqlParameter paraLemNum;
cmd.Parameters.Add(new SqlParameter("@SyncId", syncId));
cmd.Parameters.Add(new SqlParameter("@ContactId", log.CreatorId));
cmd.Parameters.Add(new SqlParameter("@CompanyId", log.CompanyId));
cmd.Parameters.Add(paraMatchId = new SqlParameter("@MatchId", log.MatchId)
{
Direction = ParameterDirection.InputOutput
});
cmd.Parameters.Add(new SqlParameter("@LogDate", log.LogDate));
cmd.Parameters.Add(new SqlParameter("@LogStatus", Enum.GetName(typeof(EnumLogStatus), log.LogStatus)));
cmd.Parameters.Add(new SqlParameter("@ProjectId", log.ProjectId));
cmd.Parameters.Add(paraLemNum = new SqlParameter("@LemNum", log.LemNum)
{
Direction = ParameterDirection.InputOutput, Size = 20
});
cmd.Parameters.Add(new SqlParameter("@BillAmount", log.BillAmount));
cmd.Parameters.Add(new SqlParameter("@Description", ConvertEx.DbNullable(log.Description)));
cmd.Parameters.Add(new SqlParameter("@EmailData", SqlDbType.VarBinary, log.EmailData?.Length ?? 0)).Value = ConvertEx.DbNullable(log.EmailData);
cmd.ExecuteNonQuery();
string[] returnData = new string[] { paraMatchId.Value.ToString(), paraLemNum.Value.ToString() };
return(Ok(returnData));
}
}
}
catch (Exception e)
{
SqlCommon.ReportInfo(e.Message);
return(BadRequest(e.Message));
}
}
