public IHttpActionResult Put(VocationalTrainingProvider vocationalTrainingProvider, int vocationalTrainingProviderId = 0)
{
OperationStatus operationStatus = new OperationStatus()
{
ServiceMethod = "PUT", ServiceName = "UpdateVocationalTrainingProvider", RequestProcessed = false, RequestSuccessful = false
};
if (vocationalTrainingProvider != null)
{
if (vocationalTrainingProviderId > 0)
{
//Comment : Here set value of vocationalTrainingProviderId into DTO object and then call Update method
vocationalTrainingProvider.Id = vocationalTrainingProviderId;
operationStatus = GetVocationalTrainingProviderDbService().UpdateVocationalTrainingProvider(vocationalTrainingProvider);
}
else
{
operationStatus.Messages.Add(new Message()
{
DTOName = "VocationalTrainingProvider", DTOProperty = "", MessageType = MessageType.SystemError, Text = "Please use POST method to create object."
});
}
}
return(Ok(operationStatus));
}
private Int32 SubmitVocationalTrainingProvider(VocationalTrainingProvider data)
{
var parameterList = new List <System.Data.IDbDataParameter>
{
new SqlParameter()
{
ParameterName = "@VocationalTrainingProviderId", Value = data.Id, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@Code", Value = data.Code, SqlDbType = SqlDbType.VarChar, Size = 10
},
new SqlParameter()
{
ParameterName = "@Name", Value = data.Name, SqlDbType = SqlDbType.VarChar, Size = 500
},
new SqlParameter()
{
ParameterName = "@Description", Value = data.Description, SqlDbType = SqlDbType.VarChar, Size = 500
},
new SqlParameter()
{
ParameterName = "@CreatedBy", Value = data.CreatedBy, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@ModifiedBy", Value = data.ModifiedBy, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@IsActive", Value = data.IsActive, SqlDbType = SqlDbType.Bit
},
new SqlParameter()
{
ParameterName = "VocationalTrainingProviderId", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.ReturnValue
}
};
//Comment : Here get DbConnector object
var rowEffeted = GetDbConnector().ExecuteNonQuery("MaintainVocationalTrainingProvider", QueryCommandType.StoredProcedure, parameterList);
//if successfully executed
if (rowEffeted > 0)
{
Int32 jobRoleId = Convert.ToInt32(parameterList[parameterList.Count() - 1].Value);
return(jobRoleId);
}
else
{
//LoggingService.Instance.Fatal(string.Format("Unable to add user :{0}{1}", Environment.NewLine, object));
}
return(0);
}
public IHttpActionResult Post(VocationalTrainingProvider vocationalTrainingProvider)
{
OperationStatus operationStatus = new OperationStatus()
{
ServiceMethod = "POST", ServiceName = "AddVocationalTrainingProvider", RequestProcessed = false, RequestSuccessful = false
};
if (vocationalTrainingProvider != null)
{
if (vocationalTrainingProvider.Id == 0)
{
operationStatus = GetVocationalTrainingProviderDbService().AddVocationalTrainingProvider(vocationalTrainingProvider);
}
else
{
operationStatus.Messages.Add(new Message()
{
DTOName = "VocationalTrainingProvider", DTOProperty = "", MessageType = MessageType.SystemError, Text = "Please use PUT method to update state of object."
});
}
}
return(Ok(operationStatus));
}
OperationStatus IVocationalTrainingProviderDbService.AddVocationalTrainingProvider(VocationalTrainingProvider data)
{
OperationStatus operationStatus = new OperationStatus()
{
RequestProcessed = false, RequestSuccessful = false
};
#region Comment : Here Iterate all request for mapping
try
{
#region Supply data object for DB insertion
//Comment : Here record id which is being effected at db level
Int32 effectedRecordId = SubmitVocationalTrainingProvider(data);
//if successfully executed
if (effectedRecordId > 0)
{
//Comment : Here if data has been "successfully submitted" then capture those details
operationStatus.RequestProcessed = true;
operationStatus.RequestSuccessful = true;
operationStatus.ServiceName = "AddVocationalTrainingProvider";
operationStatus.ServiceMethod = "POST";
operationStatus.AffectedIds.Add(new AffectedId()
{
DTOName = "VocationalTrainingProvider", DTOProperty = "VocationalTrainingProviderId", IdValue = effectedRecordId.ToString(), OperationType = OperationType.POST
});
}
else
{
//LoggingService.Instance.Fatal(string.Format("Unable to add user :{0}{1}", Environment.NewLine, object));
}
#endregion
}
catch (Exception ex)
{
operationStatus.RequestProcessed = true;
operationStatus.RequestSuccessful = false;
operationStatus.Messages.Add(new Message()
{
DTOName = "VocationalTrainingProvider", DTOProperty = "", MessageType = MessageType.SystemError, Text = ex.Message
});
}
#endregion
return(operationStatus);
}
