public MemberBO GetMemberByEmail(string email) { using (var context = new InThuDoEntities()) { var member = context.Users.FirstOrDefault(c => c.Email == email) as User; return(Mapper.Map <User, MemberBO>(member)); } }
public List<RoleTypeBO> GetRoleTypes() { using (var context = new InThuDoEntities()) { var roles = context.LibRoleTypes.ToList(); return Mapper.Map<List<LibRoleType>, List<RoleTypeBO>>(roles); } }
public List<BusinessObjects.ProductBO> GetAllProducts() { using (var context = new InThuDoEntities()) { var query = context.Products.ToList(); return Mapper.Map<List<Product>, List<BusinessObjects.ProductBO>>(query); } }
public MemberBO GetMemberByTelephone(string telephone) { using (var context = new InThuDoEntities()) { var member = context.Users.FirstOrDefault(c => c.Telephone == telephone) as User; return(Mapper.Map <User, MemberBO>(member)); } }
public List <RoleTypeBO> GetRoleTypes() { using (var context = new InThuDoEntities()) { var roles = context.LibRoleTypes.ToList(); return(Mapper.Map <List <LibRoleType>, List <RoleTypeBO> >(roles)); } }
public void DeleteMember(MemberBO member) { using (var context = new InThuDoEntities()) { var entity = context.Users.SingleOrDefault(m => m.UserId == member.UserId); entity.Deteted = true; context.SaveChanges(); } }
public void ChangePass(int userId, string pass) { using (var context = new InThuDoEntities()) { var mem = context.Users.SingleOrDefault(m => m.UserId == userId); if (mem == null) return; mem.Password = pass; context.SaveChanges(); } }
public CustomerTypeBO GetCustomerTypeById(int id) { using (var context = new InThuDoEntities()) { var query = from c in context.LibCustomerTypes where c.Id== id select c; if (query.Count() == 0) return null; return this.MapCustomerType(query.FirstOrDefault()); } }
public CustomerBO GetCustomerById(int custId) { using (var context = new InThuDoEntities()) { var query = from c in context.Customers where c.CustomerId == custId select c; return MapCustomer(query.FirstOrDefault()); } }
public int GetCustomerTypeId(string code) { using (var context = new InThuDoEntities()) { var query = from c in context.LibCustomerTypes where c.Code == code select c; if (query.Count() == 0) return 0; return query.FirstOrDefault().Id; } }
public void MarkCustomerAsDeleted(int custId) { using (var context = new InThuDoEntities()) { Customer cust = (from c in context.Customers where c.CustomerId == custId select c).FirstOrDefault(); cust.Deleted = true; context.SaveChanges(); } }
public CustomerBO GetCustomerByOrder(int orderId) { using (var context = new InThuDoEntities()) { var query = from c in context.Customers join o in context.Orders on c.CustomerId equals o.CustomerId where o.OrderId == orderId select c; return MapCustomer(query.FirstOrDefault()); } }
public string GetStringSetting(string name) { using (var context = new InThuDoEntities()) { var query = from s in context.Settings where s.Name == name select s; if (query.FirstOrDefault() == null) return string.Empty; return query.FirstOrDefault().Value; } }
public void DeleteUserOrganizationMapping(int memberId, int organizationId) { using (var context = new InThuDoEntities()) { UserOrganizationMappping userOrganizationMap = context.UserOrganizationMapppings.Where(uo => uo.UserId == memberId && uo.OrganizationId == organizationId).FirstOrDefault(); if (userOrganizationMap == null) return; context.UserOrganizationMapppings.Remove(userOrganizationMap); context.SaveChanges(); } }
public bool GetBoolSetting(string name) { using (var context = new InThuDoEntities()) { var query = from s in context.Settings where s.Name == name select s; bool result = false; bool.TryParse(query.FirstOrDefault().Value, out result); return result; } }
public List<DepartmentBO> GetAllDepartment() { using (var context = new InThuDoEntities()) { var query = from d in context.LibDepartments select new DepartmentBO() { DepartmentId = d.DepartmentId, Name = d.Name, Description = d.Description }; return query.ToList(); } }
public int InsertMember(MemberBO member) { using (var context = new InThuDoEntities()) { var entity = Mapper.Map <MemberBO, User>(member); context.Users.Add(entity); context.SaveChanges(); // update business object with new id return(entity.UserId); } }
public List<DepositMethodBO> GetAllDepositMethod() { using (var context = new InThuDoEntities()) { return (from d in context.LibDepositTypes select new DepositMethodBO() { DepositTypeId = d.DepositTypeId, Name = d.Name, Description = d.Description }).ToList(); } }
public void ChangePass(int userId, string pass) { using (var context = new InThuDoEntities()) { var mem = context.Users.SingleOrDefault(m => m.UserId == userId); if (mem == null) { return; } mem.Password = pass; context.SaveChanges(); } }
public List<OrganizationBO> GetAllOrganizations() { using (var context = new InThuDoEntities()) { var query = from og in context.Organizations select new OrganizationBO() { OrganizationId = og.OrganizationId, Name = og.Name }; return query.Distinct().ToList(); } }
public List<OrderStatusBO> GetAllOrderStatus() { using (var context = new InThuDoEntities()) { return (from status in context.LibOrderStatus select new OrderStatusBO() { OrderStatusId = status.OrderStatusId, Name = status.Name, Description = status.Description, ProcessingOrder = status.ProcessingOrder }).ToList(); } }
public void DeleteUserOrganizationMapping(int memberId, int organizationId) { using (var context = new InThuDoEntities()) { UserOrganizationMappping userOrganizationMap = context.UserOrganizationMapppings.Where(uo => uo.UserId == memberId && uo.OrganizationId == organizationId).FirstOrDefault(); if (userOrganizationMap == null) { return; } context.UserOrganizationMapppings.Remove(userOrganizationMap); context.SaveChanges(); } }
public void InsertUserOrganizationMapping(int memberId, int organizationId) { using (var context = new InThuDoEntities()) { UserOrganizationMappping userOrganization = new UserOrganizationMappping() { OrganizationId = organizationId, UserId = memberId, }; context.UserOrganizationMapppings.Add(userOrganization); context.SaveChanges(); } }
public List <DepartmentBO> GetAllDepartment() { using (var context = new InThuDoEntities()) { var query = from d in context.LibDepartments select new DepartmentBO() { DepartmentId = d.DepartmentId, Name = d.Name, Description = d.Description }; return(query.ToList()); } }
public int InsertProduct(string productName) { using (var context = new InThuDoEntities()) { Product p = new Product() { Name = productName }; context.Entry(p).State = System.Data.EntityState.Added; context.Products.Add(p); context.SaveChanges(); return p.ProductId; } }
public ProductBO GetProductByName(string productName) { using (var context = new InThuDoEntities()) { var query = (from p in context.Products where p.Name == productName select new ProductBO() { ProductId = p.ProductId, Name = p.Name, Description=p.Description }).FirstOrDefault(); return query; } }
public List<string> GetProductNames(string prefixText) { using (var context = new InThuDoEntities()) { List<string> result = new List<string>(); var query = from p in context.Products where p.Name.Contains(prefixText) select p; foreach(Product p in query) { result.Add(p.Name); } return result; } }
public void UpdateMember(MemberBO member) { using (var context = new InThuDoEntities()) { var entity = context.Users.SingleOrDefault(m => m.UserId == member.UserId); entity.Email = member.Email; entity.UserName = member.UserName; entity.Address = member.Address; entity.Telephone = member.Telephone; entity.RoleTypeId = member.RoleTypeId; entity.LastEditedOn = member.LastEditedOn; entity.FullName = member.FullName; entity.DepartmentId = member.DepartmentId; //context.Members.Attach(entity); context.SaveChanges(); } }
public List<CustomerBO> GetCustomers(string customerName, string telephone, string email, string companyName, int customerTypeId) { using (var context = new InThuDoEntities()) { var query = from c in context.Customers where (string.IsNullOrEmpty(customerName) || c.Name.Contains(customerName)) && (string.IsNullOrEmpty(telephone) || c.Telephone.Contains(telephone)) && (string.IsNullOrEmpty(email) || c.Email.Contains(email)) && (string.IsNullOrEmpty(companyName) || c.Company.Contains(companyName)) && (customerTypeId ==0 || c.CustomerTypeId == customerTypeId)&& (c.Deleted == false || c.Deleted == null) select c; return MapCustomerList(query); } }
public List<OrganizationBO> GetAllOrganization() { using (var context = new InThuDoEntities()) { var query = from or in context.Organizations select new OrganizationBO() { OrganizationId = or.OrganizationId, Name = or.Name, Address = or.Address, Description = or.Description, FaxNumber = or.FaxNumber, PhoneNumber = or.PhoneNumber, TaxCode = or.TaxCode }; if (query == null) return new List<OrganizationBO>(); return query.ToList(); } }
public MemberBO GetMemberByUserName(string userName) { using (var context = new InThuDoEntities()) { var member = context.Users.FirstOrDefault(c => c.UserName == userName) as User; var result = Mapper.Map <User, MemberBO>(member); if (result != null) { result.Department = new DepartmentBO() { DepartmentId = member.LibDepartment.DepartmentId, Code = member.LibDepartment.Code, Name = member.LibDepartment.Name, Description = member.LibDepartment.Description }; } return(result); } }
public List <MemberBO> GetMembers(string username, string email, string fullName, string telephone, int roletypeId, int departId, int organizationId) { using (var context = new InThuDoEntities()) { var query = from mem in context.Users join uom in context.UserOrganizationMapppings on mem.UserId equals uom.UserId into uomGroup from uom2 in uomGroup.DefaultIfEmpty() where (String.IsNullOrEmpty(username) || mem.UserName.Contains(username)) && (String.IsNullOrEmpty(email) || mem.Email.Contains(email)) && (String.IsNullOrEmpty(fullName) || mem.FullName.Contains(fullName)) && (String.IsNullOrEmpty(telephone) || mem.FullName.Contains(telephone)) && (roletypeId == 0 || mem.RoleTypeId == roletypeId) && (departId == 0 || mem.DepartmentId == departId) && (organizationId == 0 || uom2.OrganizationId == organizationId) && (mem.Deteted == null || mem.Deteted == false) select mem; var roles = context.LibRoleTypes; return(query.ToList().AsQueryable().Select(m => new MemberBO { UserId = m.UserId, Email = m.Email, DepartmentId = m.DepartmentId, RoleType = Mapper.Map <LibRoleType, RoleTypeBO>(roles.Where(r => r.RoleTypeId == m.RoleTypeId).FirstOrDefault()), FullName = m.FullName, Address = m.Address, Telephone = m.Telephone, UserName = m.UserName, Department = new DepartmentBO() { DepartmentId = m.LibDepartment.DepartmentId, Code = m.LibDepartment.Code, Name = m.LibDepartment.Name, Description = m.LibDepartment.Description } } ) .ToList()); } }
public MemberBO GetMemberByOrder(int orderId) { using (var context = new InThuDoEntities()) { var query = from u in context.Users join o in context.Orders on u.UserId equals o.UserId where (o.OrderId == orderId) select new MemberBO() { UserId = u.UserId, Email = u.Email, FullName = u.FullName, Address = u.Address, Telephone = u.Telephone, UserName = u.UserName }; return(query.FirstOrDefault()); } }
public bool Login(string user, string pass) { using (var context = new InThuDoEntities()) { var query = (from u in context.Users join d in context.LibDepartments on u.DepartmentId equals d.DepartmentId join o in context.UserOrganizationMapppings on u.UserId equals o.UserId where (u.Deteted == false || u.Deteted == null) && (u.UserName == user) && (u.Password == pass) select u).Distinct().ToList(); if (query.Count() == 1) { return(true); } return(false); } }
public List <MemberBO> GetBusinessMen(List <int> orgsId) { using (var context = new InThuDoEntities()) { var query = from m in context.Users join d in context.LibDepartments on m.DepartmentId equals d.DepartmentId join o in context.UserOrganizationMapppings on m.UserId equals o.UserId where (m.Deteted == false || m.Deteted == null) && (d.Code == "PKD") && (orgsId.Count == 0 || orgsId.Contains(o.OrganizationId)) select new MemberBO() { UserId = m.UserId, UserName = m.UserName, FullName = m.FullName, }; return(query.Distinct().ToList()); } }
public List<PrintingTypeBO> GetAllPrintingType() { using (var context = new InThuDoEntities()) { var query = (from pt in context.LibPrintingTypes select pt).ToList(); List<PrintingTypeBO> printingTypes = new List<PrintingTypeBO>(); foreach (LibPrintingType p in query) { PrintingTypeBO printingType = new PrintingTypeBO() { Id = p.Id, Code = p.Code, Name = p.Name, Description = p.Description, }; printingTypes.Add(printingType); } return printingTypes; } }
public List <OrganizationBO> GetAllOrganization() { using (var context = new InThuDoEntities()) { var query = from or in context.Organizations select new OrganizationBO() { OrganizationId = or.OrganizationId, Name = or.Name, Address = or.Address, Description = or.Description, FaxNumber = or.FaxNumber, PhoneNumber = or.PhoneNumber, TaxCode = or.TaxCode }; if (query == null) { return(new List <OrganizationBO>()); } return(query.ToList()); } }
public MemberBO GetMemberByTelephone(string telephone) { using (var context = new InThuDoEntities()) { var member = context.Users.FirstOrDefault(c => c.Telephone== telephone) as User; return Mapper.Map<User, MemberBO>(member); } }
public List<MemberBO> GetMembers(string sortExpression = "UserId ASC") { using (var context = new InThuDoEntities()) { var members = context.Users.Where(m=> m.Deteted ==false || m.Deteted == null).AsQueryable().OrderBy(sortExpression).ToList(); var roles = context.LibRoleTypes.ToList(); return members.AsQueryable().Select(m => new MemberBO { UserId = m.UserId, Email = m.Email, RoleType = new RoleTypeBO() { RoleTypeId = m.RoleTypeId, RoleName = m.LibRoleType.RoleName, RoleDescription = m.LibRoleType.RoleDescription }, FullName = m.FullName, Address = m.Address, Telephone = m.Telephone, UserName = m.UserName, Department = new DepartmentBO() { DepartmentId = m.LibDepartment.DepartmentId, Code = m.LibDepartment.Code, Name = m.LibDepartment.Name, Description = m.LibDepartment.Description } } ) .ToList(); //return Mapper.Map<List<User>, List<Member>>(members); } }
public MemberBO GetMemberByUserName(string userName) { using (var context = new InThuDoEntities()) { var member = context.Users.FirstOrDefault(c => c.UserName == userName) as User; var result = Mapper.Map<User, MemberBO>(member); if (result != null) { result.Department = new DepartmentBO() { DepartmentId = member.LibDepartment.DepartmentId, Code = member.LibDepartment.Code, Name = member.LibDepartment.Name, Description = member.LibDepartment.Description }; } return result; } }
public List<MemberBO> GetMembers(string username, string email, string fullName, string telephone, int roletypeId, int departId, int organizationId) { using (var context = new InThuDoEntities()) { var query = from mem in context.Users join uom in context.UserOrganizationMapppings on mem.UserId equals uom.UserId into uomGroup from uom2 in uomGroup.DefaultIfEmpty() where (String.IsNullOrEmpty(username) || mem.UserName.Contains(username))&& (String.IsNullOrEmpty(email) || mem.Email.Contains(email))&& (String.IsNullOrEmpty(fullName)|| mem.FullName.Contains(fullName))&& (String.IsNullOrEmpty(telephone)|| mem.FullName.Contains(telephone))&& (roletypeId ==0 || mem.RoleTypeId == roletypeId)&& (departId == 0 || mem.DepartmentId == departId)&& (organizationId ==0 || uom2.OrganizationId == organizationId)&& (mem.Deteted == null || mem.Deteted == false) select mem; var roles = context.LibRoleTypes; return query.ToList().AsQueryable().Select(m => new MemberBO { UserId = m.UserId, Email = m.Email, DepartmentId = m.DepartmentId, RoleType = Mapper.Map<LibRoleType, RoleTypeBO>(roles.Where(r => r.RoleTypeId == m.RoleTypeId).FirstOrDefault()), FullName = m.FullName, Address = m.Address, Telephone = m.Telephone, UserName = m.UserName, Department = new DepartmentBO() { DepartmentId = m.LibDepartment.DepartmentId, Code = m.LibDepartment.Code, Name = m.LibDepartment.Name, Description = m.LibDepartment.Description } } ) .ToList(); } }
public List<OrganizationBO> GetOrganizationsByMemberId(int memberId) { using (var context = new InThuDoEntities()) { var query = from om in context.UserOrganizationMapppings where om.UserId == memberId select new OrganizationBO() { OrganizationId = om.OrganizationId, Name = om.Organization.Name, Address = om.Organization.Address, Description = om.Organization.Description, FaxNumber = om.Organization.FaxNumber, PhoneNumber = om.Organization.PhoneNumber, TaxCode = om.Organization.TaxCode }; if (query == null) return new List<OrganizationBO>(); return query.ToList(); } }
public int InsertMember(MemberBO member) { using (var context = new InThuDoEntities()) { var entity = Mapper.Map<MemberBO, User>(member); context.Users.Add(entity); context.SaveChanges(); // update business object with new id return entity.UserId; } }
public bool Login(string user, string pass) { using(var context = new InThuDoEntities()) { var query = (from u in context.Users join d in context.LibDepartments on u.DepartmentId equals d.DepartmentId join o in context.UserOrganizationMapppings on u.UserId equals o.UserId where (u.Deteted == false || u.Deteted == null) &&(u.UserName == user) &&(u.Password==pass) select u).Distinct().ToList(); if (query.Count() == 1) { return true; } return false; } }