public List <TaskData> GetTasksForUser(string user)
{
var ctx = new ApplicationEntities(ConfigurationManager.ConnectionStrings["ApplicationConnection"].ToString());
var result = new List <TaskData>();
var tasks = ctx.Tasks
.Include("Category")
.Include("Project")
.Include("Project.ModifiedByUser")
.Include("Project.CreatedByUser")
.Include("Status")
.Include("AssignedToUser")
.Include("ModifiedByUser")
.Include("CreatedByUser")
.Where(row => row.AssignedToUser.Name == user);
foreach (var task in tasks)
{
result.Add(new TaskData(task));
}
ctx.Dispose();
return(result);
}
public List <InvoiceData> GetInvoices(DateTime start, DateTime end)
{
var ctx = new ApplicationEntities(ConfigurationManager.ConnectionStrings["ApplicationConnection"].ToString());
var result = new List <InvoiceData>();
var invoices = ctx.Invoices
.Include("Task")
.Include("Task.Category")
.Include("Task.Project")
.Include("Task.Project.ModifiedByUser")
.Include("Task.Project.CreatedByUser")
.Include("Task.Status")
.Include("Task.AssignedToUser")
.Include("Task.ModifiedByUser")
.Include("Task.CreatedByUser")
.Include("ModifiedByUser")
.Include("CreatedByUser")
.Where(row => row.PreparedDate >= start && row.PreparedDate <= end);
foreach (var invoice in invoices)
{
result.Add(new InvoiceData(invoice));
}
ctx.Dispose();
return(result);
}
public List <HourData> GetHoursForUser(string user, DateTime start, DateTime end)
{
var ctx = new ApplicationEntities(ConfigurationManager.ConnectionStrings["ApplicationConnection"].ToString());
var result = new List <HourData>();
var hours = ctx.Hours
.Include("User")
.Include("Task")
.Include("Task.Category")
.Include("Task.Project")
.Include("Task.Project.ModifiedByUser")
.Include("Task.Project.CreatedByUser")
.Include("Task.Status")
.Include("Task.AssignedToUser")
.Include("Task.ModifiedByUser")
.Include("Task.CreatedByUser")
.Include("ModifiedByUser")
.Include("CreatedByUser")
.Where(row => row.User.Name == user)
.Where(row => row.Date >= start && row.Date <= end);
foreach (var hour in hours)
{
result.Add(new HourData(hour));
}
ctx.Dispose();
return(result);
}
public List <ProjectData> GetProjects()
{
var ctx = new ApplicationEntities(ConfigurationManager.ConnectionStrings["ApplicationConnection"].ToString());
var result = new List <ProjectData>();
var projects = ctx.Projects
.Include("ModifiedByUser")
.Include("CreatedByUser")
.OrderBy(project => project.Name)
.AsQueryable();
var notes = ctx.Notes
.Include("ModifiedByUser")
.Include("CreatedByUser")
.Where(note => note.SourceType == 2 &&
projects.Select(project => project.ProjectId).Contains(note.SourceId))
.OrderByDescending(note => note.CreatedDate);
foreach (var project in projects)
{
var projectData = new ProjectData(project);
foreach (var note in notes.Where(note => note.SourceId == project.ProjectId))
{
projectData.Notes.Add(new NoteData(note));
}
result.Add(projectData);
}
ctx.Dispose();
return(result);
}
public virtual IEnumerable <U> GetAll()
{
using (ApplicationEntities context = new ApplicationEntities())
{
IEnumerable <T> models = context.Set <T>();
return(Mapper.Map <IEnumerable <T>, IEnumerable <U> >(models));
}
}
public JsonResult AddProduct(Product product)
{
using (ApplicationEntities entities = new ApplicationEntities())
{
entities.Products.Add(product);
entities.SaveChanges();
}
return(Json(product));
}
public UnitOfWork(ApplicationEntities context)
{
_context = context;
Users = new AspNetUserRepository(_context);
Roles = new AspNetRoleRepository(_context);
Companies = new CompanyRepository(_context);
Beacons = new BeaconRepository(_context);
SurveyAnswers = new SurveyAnswerRepository(_context);
SurveyQuestions = new SurveyQuestionRepository(_context);
}
public ActionResult DeleteProduct(int productId)
{
using (ApplicationEntities entities = new ApplicationEntities())
{
Product customer = (from c in entities.Products
where c.ProductId == productId
select c).FirstOrDefault();
entities.Products.Remove(customer);
entities.SaveChanges();
}
return(new EmptyResult());
}
public virtual void BulkSave(List <T> entities)
{
using (var transactionScope = new TransactionScope())
{
using (var ctx = new ApplicationEntities())
{
// some stuff in dbcontext
ctx.BulkInsert(entities);
ctx.SaveChanges();
//ctx.Commit();
transactionScope.Complete();
}
}
}
public ActionResult UpdateProduct(Product product)
{
using (ApplicationEntities entities = new ApplicationEntities())
{
Product updatedCustomer = (from c in entities.Products
where c.ProductId == product.ProductId
select c).FirstOrDefault();
updatedCustomer.ProductName = product.ProductName;
updatedCustomer.ProductCode = product.ProductCode;
updatedCustomer.Quantity = product.Quantity;
updatedCustomer.Amount = product.Amount;
updatedCustomer.TaxPercent = product.TaxPercent;
updatedCustomer.TaxAmount = product.TaxAmount;
updatedCustomer.NetAmount = product.NetAmount;
updatedCustomer.Category = product.Category;
entities.SaveChanges();
}
return(new EmptyResult());
}
public List <UserData> GetUsers()
{
var ctx = new ApplicationEntities(ConfigurationManager.ConnectionStrings["ApplicationConnection"].ToString());
var result = new List <UserData>();
var users = ctx.Users
.Where(user => user.IsActive)
.OrderBy(user => user.Name)
.AsQueryable();
foreach (var user in users)
{
var userData = new UserData(user);
result.Add(userData);
}
ctx.Dispose();
return(result);
}
public List <CategoryData> GetCategories()
{
var ctx = new ApplicationEntities(ConfigurationManager.ConnectionStrings["ApplicationConnection"].ToString());
var result = new List <CategoryData>();
var categories = ctx.Categories
.Where(category => category.IsActive)
.OrderBy(category => category.Name)
.AsQueryable();
foreach (var category in categories)
{
var categoryData = new CategoryData(category);
result.Add(categoryData);
}
ctx.Dispose();
return(result);
}
public List <StatusData> GetStatuses()
{
var ctx = new ApplicationEntities(ConfigurationManager.ConnectionStrings["ApplicationConnection"].ToString());
var result = new List <StatusData>();
var statuses = ctx.Statuses
.Where(status => status.IsActive)
.OrderBy(status => status.Name)
.AsQueryable();
foreach (var status in statuses)
{
var statusData = new StatusData(status);
result.Add(statusData);
}
ctx.Dispose();
return(result);
}
public ResellerService(ApplicationEntities Ae, IResellerRepository RR)
{
this.resellersRepository = RR;
this.ApplicationEntity = Ae;
}
public BookingService()
{
db = new ApplicationEntities();
}
/// <summary>
/// Constructor Method
/// </summary>
/// <param name="logger"></param>
/// <param name="applicationClient"></param>
/// <param name="applicationMapper"></param>
public ReportsController(ILogger logger)
{
_logger = logger;
db = new ApplicationEntities();
}
public EmployeeInfoController()
{
ctx = new ApplicationEntities();
}
public Service()
{
ctx = new ApplicationEntities();
}
public AspNetUserRepository(ApplicationEntities context) : base(context)
{
}
public RoleService(ApplicationEntities Ae, IRoleRepository RR)
{
this.rolesRepository = RR;
this.ApplicationEntity = Ae;
}
public Service()
{
ctx = new ApplicationEntities();
}
public ApplicationEntities Init()
{
return(db ?? (db = new ApplicationEntities()));
}
public ActionService(ApplicationEntities Ae, IActionRepository AR)
{
this.ActionsRepsoitory = AR;
this.ApplicationEntity = Ae;
}
public EmployerInfoAPIController()
{
context = new ApplicationEntities();
}
public ProductsAPIController()
{
ctx = new ApplicationEntities();
}
public ApplicationEntities Get()
{
return(dataContext ?? (dataContext = new ApplicationEntities()));
}
public CompanyRepository(ApplicationEntities context) : base(context)
{
}
public PermissionService(ApplicationEntities Ae, IPermissionRepository PR, IRoleRepository RR)
{
this.permissionsRepository = PR;
this.ApplicationEntity = Ae;
this.rolesRepositroy = RR;
}
public EmployeeInfoController()
{
ctx = new ApplicationEntities();
}
public CapacityProviderService()
{
db = new ApplicationEntities();
}
public SubscriptionsService(ApplicationEntities Ae, ISubscriptionsRepository SR)
{
this.SubscriptionsRepository = SR;
this.ApplicationEntity = Ae;
}
public MasterController(ILogger logger)
{
_logger = logger;
db = new ApplicationEntities();
}
