public IHttpActionResult GetSearchedBatchMaster([FromUri] SearchBatchMasterRequestParams searchParams)
{
if (searchParams == null)
{
searchParams = new SearchBatchMasterRequestParams();
}
return(Ok(GetBatchMasterDbService().SearchBatchMaster(searchParams)));
}
/// <summary>
/// Return list of BatchMaster details based on supplied Search-Parameters
/// </summary>
/// <returns></returns>
BatchMasterResponse IBatchMasterDbService.SearchBatchMaster(SearchBatchMasterRequestParams request)
{
BatchMasterResponse batchMasterResponse = new BatchMasterResponse();
try
{
var dbSet = GetDbConnector().LoadDataSet("SearchBatchMaster", QueryCommandType.StoredProcedure,
new List <System.Data.IDbDataParameter>
{
new SqlParameter()
{
ParameterName = "@BatchId", Value = request.BatchId, SqlDbType = SqlDbType.VarChar, Size = 10
},
new SqlParameter()
{
ParameterName = "@BatchName", Value = request.BatchName, SqlDbType = SqlDbType.VarChar, Size = 100
},
new SqlParameter()
{
ParameterName = "@SchemeId", Value = request.SchemeId, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@JobRoleId", Value = request.JobRoleId, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@CityId", Value = request.CityId, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@VTP_Id", Value = request.VTP_Id, SqlDbType = SqlDbType.Int
},
});
//Comment : Here fill & return generic list from DbSet
var listBatchMaster = new List <BatchMaster>();
if (dbSet != null && dbSet.Tables.Count > 0)
{
foreach (DataRow dataRow in dbSet.Tables[0].Rows)
{
listBatchMaster.Add(
new BatchMaster()
{
Id = Convert.ToInt64(dataRow["BatchMasterId"]),
BatchId = dataRow["BatchId"].ToString(),
BatchName = dataRow["BatchName"].ToString(),
//Comment": Here data for BatchDetails
BatchDetails = new BatchDetail()
{
//refrence key data
BatchMasterId = Convert.ToInt32(dataRow["BatchMasterId"]),
SchemeName = dataRow["SchemeName"].ToString(),
JobRoleName = dataRow["JobRoleName"].ToString(),
CityName = dataRow["CityName"].ToString(),
VTP_Name = dataRow["VTP_Name"].ToString(),
TotalCandidates = Convert.ToInt32(dataRow["TotalCandidates"]),
},
IsActive = Convert.ToBoolean((dataRow["IsActive"] == DBNull.Value || dataRow["IsActive"] == null) ? 0 : dataRow["IsActive"])
});
}
}
//assign fecthed list
batchMasterResponse.BatchMaster = listBatchMaster;
batchMasterResponse.OperationStatus = new OperationStatus {
ServiceName = "SearchBatchMaster", ServiceMethod = "Get", RequestProcessed = true, RequestSuccessful = true
};
}
catch (Exception ex)
{
batchMasterResponse.OperationStatus = new OperationStatus {
Messages = new List <Message>()
{
new Message()
{
DTOName = "BatchMaster", DTOProperty = "", MessageType = MessageType.SystemError, Text = ex.Message
}
}, RequestProcessed = true, RequestSuccessful = false
};
}
return(batchMasterResponse);
}