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