public Dictionary <int, Domain.PricingUnit> GetPricingUnits()
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
return(context.PricingUnits.Select(row => row.GetDomainObject()).ToDictionary(obj => obj.ID));
}
}
public Dictionary <int, Domain.ApprovalStatus> GetApprovalStatuses()
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
return(context.ApprovalStatus.Select(row => row.GetDomainObject()).ToDictionary(obj => obj.ID));
}
}
/// <summary>
/// return all of configurations of website.
/// </summary>
/// <returns></returns>
public Dictionary <string, Domain.Configuration> GetConfigurations()
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
return(context.Configurations.Select(row => new Domain.Configuration {
ID = row.ID, Name = row.Name, Value = row.Value, Description = row.Description
}).ToDictionary(obj => obj.Name));
}
}
public Dictionary <int, Domain.PermissionType> GetPermissionTypes()
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
return(context.PermissionTypes.Select(row => new Domain.PermissionType {
ID = row.ID, Name = row.Name
}).ToDictionary(obj => obj.ID));
}
}
public Dictionary <int, Domain.EmailFormat> GetEmailFormats()
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
return(context.EmailFormats.Select(row => new Domain.EmailFormat {
ID = row.ID, Name = row.Name,
}).ToDictionary(obj => obj.ID));
}
}
public Dictionary <int, Domain.DocumentClassifier> GetDocumentClassifiers()
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
return(context.DocumentClassifiers.Select(row => new Domain.DocumentClassifier {
ID = row.ID, Name = row.Name
}).ToDictionary(obj => obj.ID));
}
}
public Dictionary <int, Domain.OrderAssignmentStatus> GetOrderAssignmentStatus()
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
return(context.OrderAssignmentStatus.Select(row => new Domain.OrderAssignmentStatus {
ID = row.ID, Name = row.Name, IsNoteRequired = row.NoteRequired
}).OrderBy(obj => obj.Name).ToDictionary(obj => obj.ID));
}
}
public Dictionary <int, Domain.State> GetStates(int CountryID)
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
//return context.States.Select(row => row.GetDomainObject()).Where(row=>row.CountryID==CountryID).ToDictionary(obj => obj.ID);
return(context.States.Select(
row => new Domain.State {
Abbr = row.Abbr,
CountryID = row.CountryID,
ID = row.ID,
Inactive = row.Inactive,
Name = row.Name
})
.Where(row => (row.CountryID == CountryID && row.Inactive == false))
.ToDictionary(obj => obj.ID));
}
}
public Domain.ZipCode GetZipCode(string zipCode)
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
//var query = context.ZipCodes.Where(z => z.ZIPCode == zipCode);
var linqZip = context.ZipCodes.SingleOrDefault(z => z.ZIPCode == zipCode);
if (linqZip != null)
{
Domain.ZipCode zip = new Domain.ZipCode();
zip.ID = linqZip.ID;
zip.ZipCodeName = linqZip.ZIPCode;
zip.State = linqZip.State;
zip.City = linqZip.City;
return(zip);
}
else
{
Domain.ZipCode zip = new Domain.ZipCode();
zip.City = "Not Found";
return(zip);
}
}
}