/// <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);
}
/// <summary>
/// Method will return list of BatchMaster
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
BatchMasterResponse IBatchMasterDbService.GetBatchMaster(BatchMasterRequestParams request)
{
BatchMasterResponse batchMasterResponse = new BatchMasterResponse();
try
{
var dbSet = GetDbConnector().LoadDataSet("GetBatchMaster", QueryCommandType.StoredProcedure,
new List <System.Data.IDbDataParameter>
{
new SqlParameter()
{
ParameterName = "@BatchMasterId", Value = request.Id, SqlDbType = SqlDbType.Int
},
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 = "@OnlyActive", Value = request.IsActive, SqlDbType = SqlDbType.Bit
}
});
//Comment : Here fill & return generic list from DbSet
var listBatchMaster = new List <BatchMaster>();
if (dbSet != null && dbSet.Tables.Count > 0)
{
#region STEP-1. Get BatchMaster Related Details
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
SchemeId = Convert.ToInt32(dataRow["SchemeId"]),
JobRoleId = Convert.ToInt32(dataRow["JobRoleId"]),
CityId = Convert.ToInt32(dataRow["CityId"]),
District = dataRow["District"].ToString(),
TotalCandidates = Convert.ToInt32(dataRow["TotalCandidates"]),
VTP_Id = Convert.ToInt32(dataRow["VTP_Id"]),
VTP_SPOC_Name = dataRow["VTP_SPOC_Name"].ToString(),
VTP_SPOC_Email = dataRow["VTP_SPOC_Email"].ToString(),
VTP_SPOC_Mobile = dataRow["VTP_SPOC_Mobile"].ToString(),
VTP_SPOC_Mobile2 = dataRow["VTP_SPOC_Mobile2"].ToString(),
VTP_SPOC_AlternativeNo = dataRow["VTP_SPOC_AlternativeNo"].ToString(),
VTP_Address = dataRow["VTP_Address"].ToString(),
Centre_SPOC_Name = dataRow["Centre_SPOC_Name"].ToString(),
Centre_SPOC_Email = dataRow["Centre_SPOC_Email"].ToString(),
Centre_SPOC_Mobile = dataRow["Centre_SPOC_Mobile"].ToString(),
//refrence key Master values data
SchemeName = dataRow["SchemeName"].ToString(),
JobRoleName = dataRow["JobRoleName"].ToString(),
CityName = dataRow["CityName"].ToString(),
VTP_Name = dataRow["VTP_Name"].ToString(),
StateName = dataRow["StateName"].ToString(),
//other additional inoformation mapping
SkillCouncilTypeId = Convert.ToInt32(dataRow["SkillCouncilTypeId"]),
SkillCouncilId = Convert.ToInt32(dataRow["SkillCouncilId"]),
StateId = Convert.ToInt32(dataRow["StateId"]),
},
//DB.Null should be checked before conversion
CreatedDate = (dataRow["CreatedDate"] == DBNull.Value || dataRow["CreatedDate"] == null) ? (DateTime?)null : Convert.ToDateTime(dataRow["CreatedDate"]),
CreatedBy = Convert.ToInt32(dataRow["CreatedBy"]),
ModifiedDate = (dataRow["ModifiedDate"] == DBNull.Value || dataRow["ModifiedDate"] == null) ? (DateTime?)null : Convert.ToDateTime(dataRow["ModifiedDate"]),
ModifiedBy = Convert.ToInt32((dataRow["ModifiedBy"] != DBNull.Value || dataRow["ModifiedBy"] != null) ? 0 : dataRow["ModifiedBy"]),
IsActive = Convert.ToBoolean((dataRow["IsActive"] == DBNull.Value || dataRow["IsActive"] == null) ? 0 : dataRow["IsActive"])
});
}
#endregion
#region STEP-2. Get BatchAllocation Related Details
Int64 assessorId = 0;
foreach (DataRow dataRow in dbSet.Tables[1].Rows)
{
//hold assessor-id
assessorId = Convert.ToInt64(dataRow["AssessorId"]);
//Comment": Here data for BatchAllocationDetails
listBatchMaster[0].BatchAllocationDetails = new BatchAllocationDetail()
{
BatchMasterId = Convert.ToInt64(dataRow["AllocatedBatchId"]),
BatchId = dataRow["BatchId"].ToString(),
BatchName = dataRow["BatchName"].ToString(),
BatchAllocationId = Convert.ToInt64(dataRow["BatchAllocationId"]),
AssessmentDate = Convert.ToDateTime(dataRow["AllocatedAssessmentDate"]),
AssessmentTiming = Convert.ToBoolean(dataRow["AllocatedAssessmentTiming"]),
Assessor = new ASSESSOR.Assessor()
{
Id = assessorId,
//Comment": Here data for BatchDetails
PerosnalDetail = new ASSESSOR.AssessorPersonalDetail()
{
AssessorId = assessorId,
Name = dataRow["AssessorName"].ToString(),
},
CommunicationDetail = new ASSESSOR.AssessorCommunicationDetail()
{
AssessorId = assessorId,
EmailId = dataRow["EmailId"].ToString(),
MobileNo = dataRow["MobileNo"].ToString(),
WhatsAppNo = dataRow["WhatsAppNo"].ToString(),
StateName = dataRow["StateName"].ToString(),
CityName = dataRow["CityName"].ToString(),
},
}
};
}
#endregion
}
//assign fecthed list
batchMasterResponse.BatchMaster = listBatchMaster;
batchMasterResponse.OperationStatus = new OperationStatus {
ServiceName = "GetBatchMasters", 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);
}
