protected virtual TypeSetBatch GetTypesetBatchResultsFromReader(IDataReader reader)
{
EntityConverter <TypeSetBatch> typesetBatchEntity = new EntityConverter <TypeSetBatch>();
EntityConverter <Batch> batchEntity = new EntityConverter <Batch>();
TypeSetBatch typesetBatch = new TypeSetBatch();
if (reader.Read())
{
typesetBatch = typesetBatchEntity.Convert(reader);
typesetBatch.Batch = batchEntity.Convert(reader);
}
return(typesetBatch);
}
protected virtual TranslationBatch GetTranslationBatchResultsFromReader(IDataReader reader)
{
EntityConverter <TranslationBatch> translationBatchEntity = new EntityConverter <TranslationBatch>();
EntityConverter <Batch> batchEntity = new EntityConverter <Batch>();
TranslationBatch translationBatch = new TranslationBatch();
if (reader.Read())
{
translationBatch = translationBatchEntity.Convert(reader);
translationBatch.Batch = batchEntity.Convert(reader);
}
return(translationBatch);
}
protected virtual PrintBatch GetPrintBatchFromReader(IDataReader reader)
{
EntityConverter <PrintBatch> printBatchEntity = new EntityConverter <PrintBatch>();
EntityConverter <Batch> batchEntity = new EntityConverter <Batch>();
PrintBatch printBatch = new PrintBatch();
if (reader.Read())
{
printBatch = printBatchEntity.Convert(reader);
printBatch.Batch = batchEntity.Convert(reader);
}
return(printBatch);
}
protected virtual MediaBatch GetMediaBatchFromReader(IDataReader dataReader)
{
EntityConverter <MediaBatch> mediaEntity = new EntityConverter <MediaBatch>();
EntityConverter <Batch> batchEntity = new EntityConverter <Batch>();
MediaBatch mediaBatch = new MediaBatch();
if (dataReader.Read())
{
mediaBatch = mediaEntity.Convert(dataReader);
}
mediaBatch.batch = batchEntity.Convert(dataReader);
return(mediaBatch);
}
protected virtual ProjectInvoiceStatus GetProjectInvoiceStatusFromReader(IDataReader reader)
{
EntityConverter <ProjectInvoiceStatus> projectInvoiceStatusEntity = new EntityConverter <ProjectInvoiceStatus>();
EntityConverter <InvoiceType> invoiceTypeEntity = new EntityConverter <InvoiceType>();
EntityConverter <CodeMaster> codemasterEntity = new EntityConverter <CodeMaster>();
ProjectInvoiceStatus projectInvoiceStatus = projectInvoiceStatusEntity.Convert(reader);
InvoiceType invoiceType = new InvoiceType();
CodeMaster codemaster = new CodeMaster();
codemaster = codemasterEntity.Convert(reader);
invoiceType = invoiceTypeEntity.Convert(reader);
projectInvoiceStatus.InvoiceType1 = invoiceType;
projectInvoiceStatus.codeMaster = codemaster;
return(projectInvoiceStatus);
}
protected virtual Contacts GetContactDetailsByEmailFromReader(IDataReader reader)
{
EntityConverter <Contacts> cont = new EntityConverter <Contacts>();
Contacts contact = new Contacts();
if (reader.Read())
{
contact = cont.Convert(reader);
}
if (reader.NextResult())
{
while (reader.Read())
{
contact.Add_New_Contacts_List.Add(contact);
}
}
return(contact);
}
protected virtual HospitalityBatch GetHospitalityBatchFromReader(IDataReader reader)
{
EntityConverter <HospitalityBatch> hospitalityBatchEntity = new EntityConverter <HospitalityBatch>();
EntityConverter <Batch> batchEntity = new EntityConverter <Batch>();
EntityConverter <HospitalityConferenceRoomUsage> conferenceUsage = new EntityConverter <HospitalityConferenceRoomUsage>();
EntityConverter <HospitalityNoOfMealsUsage> hospitalityNoOfMealsUsage = new EntityConverter <HospitalityNoOfMealsUsage>();
HospitalityBatch hospitalityBatch = new HospitalityBatch();
List <HospitalityConferenceRoomUsage> hospitalityConferenceRoomUsagelist = new List <HospitalityConferenceRoomUsage>();
List <HospitalityNoOfMealsUsage> hospitalityNoOfMealsUsageList = new List <HospitalityNoOfMealsUsage>();
if (reader.Read())
{
hospitalityBatch = hospitalityBatchEntity.Convert(reader);
hospitalityBatch.Batch = batchEntity.Convert(reader);
// hospitalityBatch.conferenceRoomDetailsList.Add(conferenceUsage.Convert(reader));
//hospitalityBatch.hospitalityNoOfMealsUsageList.Add(hospitalityNoOfMealsUsage.Convert(reader));
}
if (reader.NextResult())
{
while (reader.Read())
{
hospitalityConferenceRoomUsagelist.Add(conferenceUsage.Convert(reader));
}
}
if (reader.NextResult())
{
while (reader.Read())
{
hospitalityNoOfMealsUsageList.Add(hospitalityNoOfMealsUsage.Convert(reader));
}
}
hospitalityBatch.hospitalityNoOfMealsUsageList = hospitalityNoOfMealsUsageList;
hospitalityBatch.conferenceRoomDetailsList = hospitalityConferenceRoomUsagelist;
return(hospitalityBatch);
}
protected virtual VM_UserDetails GetUserDetailsByUserIdFromReader(IDataReader reader)
{
EntityConverter <VM_UserDetails> usr = new EntityConverter <VM_UserDetails>();
EntityConverter <UserRole> userRolesEntity = new EntityConverter <UserRole>();
VM_UserDetails user = new VM_UserDetails();
UserRole userRoles = new UserRole();
if (reader.Read())
{
user = usr.Convert(reader);
}
if (reader.NextResult())
{
while (reader.Read())
{
userRoles = userRolesEntity.Convert(reader);
user.Roles.Add(userRoles);
}
}
return(user);
}