/// <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); }