public CreateFirmResponse AddFirmSetting(CreateFirmRequest request) { var response = new CreateFirmResponse { ResponseStatus = ResponseStatus.Success }; var settingsProvider = new SettingsProvider(); try { if (request.ActionType == ActionType.Insert) { response.isSuccessful = settingsProvider.AddFirm(request); } else { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = "Not update action"; } } catch (Exception ex) { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = ex.Message; } return(response); }
internal bool AddFirm(CreateFirmRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.Insert_Firm", conn); AddInParameter(commandWrapper, "@FirmName", DbType.String, request.Firm.FirmName); AddInParameter(commandWrapper, "@ERROR", DbType.String, 1000); AddInParameter(commandWrapper, "@ERROR_CODE", DbType.String, 4); try { conn.Open(); int results = commandWrapper.ExecuteNonQuery(); var isProcedureSucced = Convert.ToBoolean(results); MakeDboLog(request.ToString(), isProcedureSucced.ToString(), "dbo.Insert_Firm"); var errorObject = GetParameterValue(commandWrapper, "@ERROR"); var errorCodeObject = GetParameterValue(commandWrapper, "@ERROR_CODE"); return(Convert.ToBoolean(results)); } finally { commandWrapper.Dispose(); conn.Close(); } }
public CreateFirmRequest GetCreateFirmRequest(Firm firm) { var request = new CreateFirmRequest() { Firm = firm, ActionType = Requests.ActionType.Insert }; return(request); }