public IEnumerable <UserLogin> Login(UserLogin userLogin) { using (var ctx = new SystemCompanyEntities()) { return(ctx.UserLogin.Where(u => u.UserName == userLogin.UserName && u.Password == userLogin.Password).ToList()); } }
public IEnumerable<View_Project_Company> ViewProjectCompany() { using (var ctx = new SystemCompanyEntities()) { return ctx.View_Project_Company.ToList(); } }
public IEnumerable <UserLogin> ViewingUsers() { using (var ctx = new SystemCompanyEntities()) { return(ctx.UserLogin.ToList()); } }
public void UpdateProduct(Products newProduct) { using (var ctx = new SystemCompanyEntities()) { Products product = ctx.Products.First(e => e.idProduct == newProduct.idProduct); if (product.ProductName != newProduct.ProductName || product.ProductDiscription != newProduct.ProductDiscription || product.ProductDate != newProduct.ProductDate || product.ProductCount != newProduct.ProductCount || product.ProductCostPrice != newProduct.ProductCostPrice || product.ProductCustomers != newProduct.ProductCustomers) { AuditDataServices.Instance.InsertAudit(newProduct.idProduct, 0, 0, "products", product.ProductName, "Update"); AuditDataServices.Instance.InsertAudit(newProduct.idProduct, 0, 0, "products", product.ProductDiscription, "Update"); AuditDataServices.Instance.InsertAudit(newProduct.idProduct, 0, 0, "products", Convert.ToString(product.ProductDate), "Update"); AuditDataServices.Instance.InsertAudit(newProduct.idProduct, 0, 0, "products", Convert.ToString(product.ProductCount), "Update"); AuditDataServices.Instance.InsertAudit(newProduct.idProduct, 0, 0, "products", Convert.ToString(newProduct.ProductCostPrice), "Update"); AuditDataServices.Instance.InsertAudit(newProduct.idProduct, 0, 0, "products", Convert.ToString(newProduct.ProductCustomers), "Update"); product.ProductCustomers = newProduct.ProductCustomers; product.ProductName = newProduct.ProductName; product.ProductDiscription = newProduct.ProductDiscription; product.ProductDate = newProduct.ProductDate; product.ProductCount = newProduct.ProductCount; product.ProductCostPrice = newProduct.ProductCostPrice; ctx.SaveChanges(); } } }
public IEnumerable<ProjectCompany> ViewingProjectToCompany() { using (var ctx = new SystemCompanyEntities()) { return ctx.ProjectCompanies.ToList(); } }
public void UpdateProjectToCompany(ProjectCompany projectCompany, DateProjectCompany dateProjectCompany) { using (var ctx = new SystemCompanyEntities()) { var PC = ctx.ProjectCompanies.First( pC => pC.idProject == projectCompany.idProject && pC.idCompany == projectCompany.idCompany); PC.idProject = projectCompany.idProject; PC.idCompany = projectCompany.idCompany; PC.priceType = projectCompany.priceType; PC.paid = projectCompany.paid; PC.destination = projectCompany.destination; PC.discriptions = projectCompany.discriptions; ctx.SaveChanges(); var DPC = ctx.DateProjectCompany.First( dpC => dpC.idProject == dateProjectCompany.idProject && dpC.idCompany == dateProjectCompany.idCompany); DPC.idCompany = dateProjectCompany.idCompany; DPC.idProject = dateProjectCompany.idProject; DPC.DateStartProject = dateProjectCompany.DateStartProject; DPC.DateFinishProject = dateProjectCompany.DateFinishProject; ctx.SaveChanges(); } }
public IEnumerable <Viewing_Service_Calls> GetServiceCallsBetweenDate(ServiceCall serviceCall) { using (var ctx = new SystemCompanyEntities()) { // var query3 = return(ctx.Viewing_Service_Calls.Where( t => t.dateOpenCalls > serviceCall.dateOpenCalls && t.dateOpenCalls < DateTime.Now).ToList()); // return ctx.ServiceCalls.Include("Company").Include("Priority").Where( // t => t.dateOpenCalls > serviceCall.dateOpenCalls && t.dateOpenCalls < DateTime.Now).ToList(); //.Select // (item => new // { // companyName = item.Company.companyName, // dateOpenCalls = item.dateOpenCalls.Value, // discriptions = item.discriptions, // TypePriority = item.Priority.TypePriority, // idCallsServices = item.idCallsServices, // idCompany = item.idCompany, // idPriority = item.idPriority // } // ).ToList(); // var query = mDB.ServiceCalls.Where(t => t.dateOpenCalls > serviceCall.dateOpenCalls && t.dateOpenCalls < DateTime.Now).ToList(); //return query3.Select(item => new ServiceCall //{ // idCompany = item.idCompany, // dateOpenCalls = item.dateOpenCalls, // discriptions = item.discriptions, // idCallsServices = item.idCallsServices, // idPriority = item.idPriority //}).ToList(); } }
public IEnumerable <project> ViewingProject() { using (var ctx = new SystemCompanyEntities()) { return(ctx.projects.ToList()); } }
public IEnumerable <Priority> ViewingPriority() { using (var ctx = new SystemCompanyEntities()) { return(ctx.Priorities.ToList()); } }
/// <summary> /// /// </summary> /// <returns></returns> public IEnumerable <Service> ViewingServices() { using (var ctx = new SystemCompanyEntities()) { return(ctx.Services.ToList()); } }
public void UpdateServiceToCompany(ServicesCompany newServiceToCompany) { using (var ctx = new SystemCompanyEntities()) { var serviceToCompany = ctx.ServicesCompanies.First( e => e.idService == newServiceToCompany.idService && e.idCompany == newServiceToCompany.idCompany); if (serviceToCompany.startdate != newServiceToCompany.startdate || serviceToCompany.enddate != newServiceToCompany.enddate || serviceToCompany.price != newServiceToCompany.price || serviceToCompany.priceCost != newServiceToCompany.priceCost || serviceToCompany.paid != newServiceToCompany.paid) { serviceToCompany.startdate = newServiceToCompany.startdate; serviceToCompany.enddate = newServiceToCompany.enddate; serviceToCompany.price = newServiceToCompany.price; if (newServiceToCompany.priceCost == string.Empty) { newServiceToCompany.priceCost = "0"; } serviceToCompany.priceCost = newServiceToCompany.priceCost; serviceToCompany.paid = newServiceToCompany.paid; ctx.SaveChanges(); } } }
public void UpdateCompany(Company newCompany) { using (var ctx = new SystemCompanyEntities()) { var company = ctx.Companys.First(e => e.idCompany == newCompany.idCompany); if (company.contactName != newCompany.contactName || company.address != newCompany.address || company.companyName != newCompany.companyName || company.Phone != newCompany.Phone || company.mobilePhone != newCompany.mobilePhone || company.city != newCompany.city || company.FAX != newCompany.FAX || company.email != newCompany.email || company.ZIP != newCompany.ZIP || company.PostalNum != newCompany.PostalNum || company.paymentTerms != newCompany.paymentTerms) { company.contactName = newCompany.contactName; company.address = newCompany.address; company.companyName = newCompany.companyName; company.Phone = newCompany.Phone; company.mobilePhone = newCompany.mobilePhone; company.city = newCompany.city; company.FAX = newCompany.FAX; company.email = newCompany.email; company.ZIP = newCompany.ZIP; company.PostalNum = newCompany.PostalNum; company.paymentTerms = newCompany.paymentTerms; ctx.SaveChanges(); } } }
/// <summary> /// ViewingCompanys() /// </summary> /// <returns></returns> public IEnumerable <Company> ViewingCompanys() { using (var ctx = new SystemCompanyEntities()) { return(ctx.Companys.ToList()); } }
/* public List<ServicesCompany> GetIdServiceAndIdCompny() * { * var query = _mDb.ServicesCompanies.Select(s => new * { * s.idService, * s.idCompany, * }).ToList(); * * return query.Select(serviceCompany => new ServicesCompany * { * idService = serviceCompany.idService, * idCompany = serviceCompany.idCompany * }).ToList(); * }*/ public void InsertServiceToCompany(ServicesCompany serviceToCompany) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToServicesCompanies(serviceToCompany); ctx.SaveChanges(); } }
public IEnumerable <View_Services_Company> ViewingServicesToCompanys() { using (var ctx = new SystemCompanyEntities()) { return(ctx.View_Services_Company.ToList()); // return ctx.ServicesCompanies.Include("Company").Include("Service").ToList(); } }
public void InsertServiceCall(ServiceCall serviceCall) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToServiceCalls(serviceCall); ctx.SaveChanges(); } }
private void InsertDataToAudit(SysAudit audit) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToSysAudit(audit); ctx.SaveChanges(); } }
public void InsertCompany(Company company) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToCompanys(company); ctx.SaveChanges(); } }
public Company GetCompanyById(Company company) { using (var ctx = new SystemCompanyEntities()) { var companyToDelete = ctx.Companys.First(e => e.idCompany == company.idCompany); return(companyToDelete); } }
public void InsertProduct(Products products) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToProducts(products); ctx.SaveChanges(); } }
public void InsertUser(UserLogin login) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToUserLogin(login); ctx.SaveChanges(); } }
public void InsertPriority(Priority priority) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToPriorities(priority); ctx.SaveChanges(); } }
public void InsertProject(project project) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToprojects(project); ctx.SaveChanges(); } }
public IEnumerable <UserLogin> CheckUserName(UserLogin userLogin) { using (var ctx = new SystemCompanyEntities()) { return(from c in ctx.UserLogin where c.UserName == userLogin.UserName select c); } }
public IEnumerable <Viewing_Service_Calls> ViewingServiceCalls() { using (var ctx = new SystemCompanyEntities()) { return(ctx.Viewing_Service_Calls.ToList()); //return ctx.ServiceCalls.Include("Company").Include("Priority").ToList(); } }
public void InsertProjectToCompany(ProjectCompany projectCompany, DateProjectCompany dateProjectCompany) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToProjectCompanies(projectCompany); ctx.SaveChanges(); ctx.AddToDateProjectCompany(dateProjectCompany); ctx.SaveChanges(); } }
public void DeletePriority(Priority priority) { using (var ctx = new SystemCompanyEntities()) { var priorityToDelete = ctx.Priorities.First(e => e.idPriority == priority.idPriority); AuditDataServices.Instance.InsertAudit(priorityToDelete.idPriority, 0, 0, "Priorities", priorityToDelete.TypePriority, "Delete"); ctx.DeleteObject(priorityToDelete); ctx.SaveChanges(); } }
public void DeleteProject(project project) { using (var ctx = new SystemCompanyEntities()) { project projectToDelete = ctx.projects.First(e => e.idProject == project.idProject); AuditDataServices.Instance.InsertAudit(projectToDelete.idProject, 0, 0, "projects", projectToDelete.projectName, "Delete"); AuditDataServices.Instance.InsertAudit(projectToDelete.idProject, 0, 0, "projects", projectToDelete.projectDescription, "Delete"); ctx.DeleteObject(projectToDelete); ctx.SaveChanges(); } }
public void DeleteServiceCall(ServiceCall serviceCall) { using (var ctx = new SystemCompanyEntities()) { var serviceCallToDelete = ctx.ServiceCalls.First(e => e.idCallsServices == serviceCall.idCallsServices); AuditDataServices.Instance.InsertAudit(serviceCallToDelete.idCallsServices, serviceCallToDelete.idCompany, 0, "ServiceCalls", Convert.ToString(serviceCallToDelete.dateOpenCalls), "Delete"); AuditDataServices.Instance.InsertAudit(serviceCallToDelete.idCallsServices, serviceCallToDelete.idCompany, 0, "ServiceCalls", serviceCallToDelete.discriptions, "Delete"); AuditDataServices.Instance.InsertAudit(serviceCallToDelete.idCallsServices, serviceCallToDelete.idCompany, 0, "ServiceCalls", Convert.ToString(serviceCallToDelete.idPriority), "Delete"); ctx.DeleteObject(serviceCallToDelete); ctx.SaveChanges(); } }
public void DeleteProduct(Products products) { using (var ctx = new SystemCompanyEntities()) { Products ProductsToDelete = ctx.Products.First(e => e.idProduct == products.idProduct); AuditDataServices.Instance.InsertAudit(ProductsToDelete.idProduct, 0, 0, "products", ProductsToDelete.ProductName, "Delete"); AuditDataServices.Instance.InsertAudit(ProductsToDelete.idProduct, 0, 0, "products", Convert.ToString(ProductsToDelete.ProductCostPrice), "Delete"); AuditDataServices.Instance.InsertAudit(ProductsToDelete.idProduct, 0, 0, "products", Convert.ToString(ProductsToDelete.ProductCount), "Delete"); AuditDataServices.Instance.InsertAudit(ProductsToDelete.idProduct, 0, 0, "products", Convert.ToString(ProductsToDelete.ProductDate), "Delete"); AuditDataServices.Instance.InsertAudit(ProductsToDelete.idProduct, 0, 0, "products", ProductsToDelete.ProductDiscription, "Delete"); ctx.DeleteObject(ProductsToDelete); ctx.SaveChanges(); } }