public int AddRequest(int _requestid, int _itemid, int _serviceid, int _devices, double _hours, int _status, int _number, string _se_dsn)
{
RequestItems oRequestItem = new RequestItems(user, dsn);
Services oService = new Services(user, dsn);
ServiceEditor oServiceEditor = new ServiceEditor(user, _se_dsn);
Applications oApplication = new Applications(user, dsn);
ResourceRequest oResourceRequest = new ResourceRequest(user, dsn);
ServiceDetails oServiceDetail = new ServiceDetails(user, dsn);
if (_hours == 0.00 && _serviceid > 0)
{
double _quantity = 1.00;
if (oService.Get(_serviceid, "quantity_is_device") == "1")
{
DataSet dsSelected = oService.GetSelected(_requestid);
if (dsSelected.Tables[0].Rows.Count > 0)
{
_quantity = double.Parse(dsSelected.Tables[0].Rows[0]["quantity"].ToString());
}
}
_hours = oServiceDetail.GetHours(_serviceid, _quantity);
}
int _application = oRequestItem.GetItemApplication(_itemid);
int intPlatform = Int32.Parse(oApplication.Get(_application, "platform_approve"));
int intAccepted = (oService.Get(_serviceid, "rejection") == "1" ? 0 : 1);
int intResource = oResourceRequest.Add(_requestid, _itemid, _serviceid, _number, "", _devices, _hours, _status, 1, intAccepted, (intPlatform == 1 ? 0 : 1));
DataSet dsServiceEditor = oServiceEditor.GetRequestFirstData2(_requestid, _serviceid, _number, 0, dsn);
if (dsServiceEditor.Tables[0].Rows.Count > 0)
{
oResourceRequest.UpdateName(intResource, dsServiceEditor.Tables[0].Rows[0]["title"].ToString());
}
// See if any approver has been configured. If so, add them.
// Get approval fields.
DataSet dsApprovals = oServiceEditor.GetApprovals(_serviceid);
if (dsApprovals.Tables[0].Rows.Count > 0)
{
// If exist, send approval...
oResourceRequest.DeleteApproval(_requestid, _serviceid, _number);
}
return(intResource);
}
