public int UpdateDelivered(int OrderNo) { this.CheckAccess(); using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { using (var dbContextTransaction = entity.Database.BeginTransaction()) { try { var query = from ord in entity.BookingDetails where ord.BookingID == OrderNo select ord; // Execute the query, and change the column values // you want to change. foreach (var ord in query) { ord.IsDeliver = true; // Insert any additional changes to column values. } entity.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Rollback(); return(0); } } } return(1); }
public string CreateNewUserGroup(string userGroupName) { UserGroup _userGroup = new UserGroup(); string message = ""; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { var Isalready = entity.UserGroups.Where(w => w.UserGroupName.Trim().ToUpper() == userGroupName.Trim().ToUpper()).Count(); if (Isalready > 0) { message = "Already exist"; } else { using (TransactionScope scope = new TransactionScope()) { _userGroup.UserGroupName = userGroupName; entity.UserGroups.Add(_userGroup); entity.SaveChanges(); scope.Complete(); message = "Succesfully Added"; } } } return(message); }
public string BookingSendMessage(int bookingID = 0) { //get list of message var result = ""; BraathenEiendomEntities entity = new BraathenEiendomEntities(); var list = entity.BookingMessages.Where(w => w.Status == 0 && (bookingID == 0 || bookingID != 0 && w.BookingID == bookingID) && (w.SendTime == null || w.SendTime <= DateTime.Now)).ToList(); result += "Found records: " + list.Count + "."; foreach (var message in list) { result += "Sending " + message.ID + "."; var messageType = 0; if (message.Type == "email") { messageType = 1; } else if (message.Type == "sms") { messageType = 2; } var toArray = message.To.Split(';'); var to = new Dictionary <string, string[]>(); foreach (var item in toArray) { to.Add(item, new string[] { null }); } var parameters = new Dictionary <string, string>(); if (messageType != 0) { //send var sendResult = Message.SendMessage(type: messageType, to: to, title: message.Subject, body: message.Body, parameters: parameters); if (sendResult == "1") { message.Status = 1; result += "[" + message.ID + "]Sent to " + message.To; } else { message.Status = 2; result += "[" + message.ID + "]Not send to" + message.To + ". Error: " + sendResult; } entity.SaveChanges(); } } return(result); }
public IEnumerable <CompanyMaster> GetCustomerList() { List <CompanyMaster> customerList = new List <CompanyMaster>(); CompanyMaster customer; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { string internalCustomersIds = Digimaker.Config.Custom.AppSettings["InternalCustomers"].ToString(); // "2038,4, 2037,2030"; var internalCustIds = internalCustomersIds.Split(',').ToArray(); string externalCostumersIds = Digimaker.Config.Custom.AppSettings["ExternalCostumers"].ToString(); //"3039"; var externalCustIds = externalCostumersIds.Split(',').ToArray(); var internalCustomerList = (from u in entity.OrganizationUnits where internalCustIds.Contains(u.ParentID.ToString()) select u).ToList(); var ExternalCustomerList = (from u in entity.OrganizationUnits where externalCustIds.Contains(u.ParentID.ToString()) select u).ToList(); foreach (var item in internalCustomerList) { customer = new CompanyMaster(); if (!string.IsNullOrEmpty(item.Code)) { customer.IsMVA = false; } else { customer.IsMVA = true; } customer.IsPrimary = true; customer.OrganizationUnitId = item.OrganizationUnitID.ToString(); customer.OrganizationUnitName = item.OrganizationUnitName; customerList.Add(customer); } foreach (var item in ExternalCustomerList) { customer = new CompanyMaster(); customer.IsPrimary = false; if (!string.IsNullOrEmpty(item.Code)) { customer.IsMVA = false; } else { customer.IsMVA = true; } customer.OrganizationUnitId = item.OrganizationUnitID.ToString(); customer.OrganizationUnitName = item.OrganizationUnitName; customerList.Add(customer); } } return(customerList); }
public UserGroupList GetUserGroupList(string userGroupId) { UserGroupList userGroup; List <UserGroupListUser> personlist; UserGroupListUser person; int id = 0; if (userGroupId != null) { id = Convert.ToInt32(userGroupId); } using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { userGroup = new UserGroupList(); var usrResult = entity.UserGroups.Where(u => u.UserGroupId == id).Select(s => s).FirstOrDefault(); if (usrResult != null) { personlist = new List <UserGroupListUser>(); userGroup.userGroupId = usrResult.UserGroupId; userGroup.name = usrResult.UserGroupName; var persons = entity.People.Join(entity.UserGroup_User, p => p.PersonID, o => o.UserId, (P, O) => new { p = P, o = O }) .Where(w => w.o.UserGroupId == usrResult.UserGroupId).Select(s => s.p).OrderBy(o => o.DisplayName).ToList(); if (persons != null) { foreach (var p in persons.Where(p => p.Custom2 == null)) { person = new UserGroupListUser(); person.id = p.PersonID; person.name = p.DisplayName; person.telephone = p.MobilePhone; person.UserEmail = p.Email; person.PositionTitle = p.Title; var comp = entity.OrganizationUnits.Join(entity.OrganizationUnit_Person, ou => ou.OrganizationUnitID, oup => oup.OrganizationUnitID, (OU, OUP) => new { ou = OU, oup = OUP }) .Where(w => w.oup.PersonID == p.PersonID).Select(s => s.ou).FirstOrDefault(); if (comp != null) { person.companyId = comp.OrganizationUnitID; person.companyName = comp.OrganizationUnitName; } personlist.Add(person); } } userGroup.personList = personlist; } } return(userGroup); }
public string AddToUserGroupList(UserAssignedGroupModel userGroupModel) { UserGroup_User _userGroupUsr; string message = ""; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { using (var scope = entity.Database.BeginTransaction()) { try { var ExistingGrp = entity.UserGroup_User.Where(w => w.UserId == userGroupModel.userId).ToList(); if (ExistingGrp != null) { foreach (var item in ExistingGrp) { entity.UserGroup_User.Remove(item); entity.SaveChanges(); } } if (userGroupModel.userGroup != null) { foreach (var userGroup in userGroupModel.userGroup) { _userGroupUsr = new UserGroup_User(); _userGroupUsr.UserId = userGroupModel.userId; _userGroupUsr.UserGroupId = userGroup; entity.UserGroup_User.Add(_userGroupUsr); } entity.SaveChanges(); scope.Commit(); message = "successfully assigned UserGroup"; } else { message = "UserGroup not assigned"; } } catch (Exception) { scope.Rollback(); message = ""; } finally{ scope.Dispose(); } } } return(message); }
public List <Menu> GetMenuDetail(string menuItemID, int includeArticle = 0) { var idList = menuItemID.Split('-'); List <Menu> menuList = new List <Menu>(); foreach (var id in idList) { int menuId = 0; if (menuItemID != null) { menuId = Convert.ToInt32(id); } Menu menu; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { menu = new Menu(); var result = entity.MenuItems.Where(w => w.MenuItemID == menuId).Select(s => s).FirstOrDefault(); menu.MenuId = result.MenuItemID; menu.MenuName = result.MenuItemName; menu.MenuDesc = result.MetaDescription; menu.PicturePath = entity.PictureProperties.Where(w => w.PictureMainID == result.Pictureid).Select(s => s.Filepath).ToString(); } if (includeArticle == 1) { var rows = SiteBuilder.Content.Article.ByMenuIds(id, Digimaker.Data.Content.ArticleSortOrder.Default, 0, true, SiteBuilder.Content.Article.ReturnValues.AbstractAndFullstory, 1).Article.Rows; if (rows.Count > 0) { var article = (Digimaker.Schemas.Web.ArticleViewData.ArticleRow)rows[0]; var articleModel = new ArticleModel(); articleModel.ArticleDesc = article.Abstract.Replace("{RelatedPersons}", ""); articleModel.ArticleName = article.Headline; articleModel.PicturePath = article.Filepath; articleModel.ArticleId = article.MainID; articleModel.ArticleBody = article.Fullstory; var children = new List <ArticleModel>(); children.Add(articleModel); menu.Children = children; } } menuList.Add(menu); } return(menuList); }
public IEnumerable <UserMaster> GetPersonListByCompany(int customerNo) { List <UserMaster> um = new List <UserMaster>(); using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { var result = entity.OrganizationUnit_Person.Join(entity.People, a => a.PersonID, b => b.PersonID, (A, B) => new { a = A, b = B }) .Where(w => w.a.OrganizationUnitID == customerNo).Select(s => s.b).ToList(); foreach (var item in result) { um.Add(new UserMaster { PersonID = item.PersonID, DisplayName = item.DisplayName }); } } return(um); }
public OrgUnit GetCustomerCompanyDetail(string orgId) { int id = 0; if (orgId != null) { id = Convert.ToInt32(orgId); } OrgUnit orgUnit; List <OrganizationPerson> personlist; OrganizationPerson person; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { var orgResult = entity.OrganizationUnits.Where(w => w.OrganizationUnitID == id).Select(s => s).FirstOrDefault(); personlist = new List <OrganizationPerson>(); orgUnit = new OrgUnit(); orgUnit.id = orgResult.OrganizationUnitID; orgUnit.name = orgResult.OrganizationUnitName; orgUnit.Code = string.IsNullOrEmpty(orgResult.Code)?true :false; orgUnit.OrganizationNumber = orgResult.OrgNumber; if (orgResult.PictureID != null) { orgUnit.PicturePath = entity.PictureProperties.Where(w => w.PicturePropertyID == orgResult.PictureID).SingleOrDefault().Filepath.ToString(); } var persons = entity.People.Join(entity.OrganizationUnit_Person, p => p.PersonID, o => o.PersonID, (P, O) => new { p = P, o = O }) .Where(w => w.o.OrganizationUnitID == orgResult.OrganizationUnitID).Select(s => s.p).OrderBy(o => o.DisplayName).ToList(); if (persons != null) { foreach (var p in persons.Where(p => p.Custom2 == null)) { person = new OrganizationPerson(); person.id = p.PersonID; person.name = p.DisplayName; person.telephone = p.MobilePhone; person.UserEmail = p.Email; person.Department = p.Custom1; person.UserGroup = string.Join(",", entity.UserGroups.Join(entity.UserGroup_User, gp => gp.UserGroupId, go => go.UserGroupId, (GP, GO) => new { gp = GP, go = GO }) .Where(w => w.go.UserId == p.PersonID).Select(gs => gs.gp.UserGroupName)); personlist.Add(person); } } orgUnit.personList = personlist; } return(orgUnit); }
public async Task <ApiResponse> UpdateClean(int OrderNo) { this.CheckAccess(); ApiResponse response = new ApiResponse(); var rsp = await orderAsync(OrderNo); if (rsp.errorType == 1) { return(rsp); } using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { using (var dbContextTransaction = entity.Database.BeginTransaction()) { try { var query = from ord in entity.BookingDetails where ord.BookingID == OrderNo select ord; // Execute the query, and change the column values // you want to change. foreach (var ord in query) { ord.IsClean = true; // Insert any additional changes to column values. } entity.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); response.message = ex.Message; response.errorType = (int)Enums.ErrorType.Error; return(response); } } } response.message = "Successfully Clean"; response.errorType = (int)Enums.ErrorType.Success; return(response); }
public IEnumerable <UserGroupList> GetUserGroup() { List <UserGroupList> userGroupList; UserGroupList userGroup; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { var usrResult = entity.UserGroups.Select(s => s).ToList(); userGroupList = new List <UserGroupList>(); foreach (var usr in usrResult) { userGroup = new UserGroupList(); userGroup.userGroupId = usr.UserGroupId; userGroup.name = usr.UserGroupName; userGroupList.Add(userGroup); } } return(userGroupList); }
public string DeleteUserGroup(int userGroupId) { string message = ""; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { //For multiple records var allRec = entity.UserGroup_User.Where(w => w.UserGroupId == userGroupId); entity.UserGroup_User.RemoveRange(allRec); //For Single record var singleRec = entity.UserGroups.FirstOrDefault(x => x.UserGroupId == userGroupId);// object your want to delete entity.UserGroups.Remove(singleRec); entity.SaveChanges(); message = "Delete Successfully"; } return(message); }
public IEnumerable <UserGroupList> UserWiseGroupList(int userId) { List <UserGroupList> userGroupList; UserGroupList userGroup; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { var usrResult = entity.UserGroups.Join(entity.UserGroup_User, p => p.UserGroupId, o => o.UserGroupId, (P, O) => new { p = P, o = O }) .Where(w => w.o.UserId == userId).Select(s => s.p).OrderBy(o => o.UserGroupName).ToList(); userGroupList = new List <UserGroupList>(); foreach (var usr in usrResult) { userGroup = new UserGroupList(); userGroup.userGroupId = usr.UserGroupId; userGroup.name = usr.UserGroupName; userGroupList.Add(userGroup); } } return(userGroupList); }
public IHttpActionResult GetChildMenuList(int parentMenuId) { ApiResponse response = new ApiResponse(); if (parentMenuId != 0) { using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { var result = entity.MenuItems.Where(w => w.Parentid == parentMenuId).Select(s => s).ToList(); if (result.Count > 0) { List <MenuItems> menulist = new List <MenuItems>(); MenuItems menu; foreach (var item in result) { menu = new MenuItems(); menu.MenuItemID = item.MenuItemID; menu.MenuName = item.MenuItemName; menulist.Add(menu); } return(Ok(menulist)); } else { response.message = "No data found"; response.errorType = (int)ErrorType.Error; return(Ok(response)); } } } else { response.message = "please enter valid menuid"; response.errorType = (int)ErrorType.Error; return(Ok(response)); } }
public int GetKitchenDepID(int buildingid) { try { using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { string KitchenDepID = entity.MenuItems.Where(w => w.MenuItemID == buildingid).Select(s => s.MetaDescription).FirstOrDefault(); if (!string.IsNullOrEmpty(KitchenDepID)) { if (KitchenDepID.IndexOf('=') > 0) { string DepID = KitchenDepID.Substring(KitchenDepID.IndexOf('=') + 1, KitchenDepID.Length - (KitchenDepID.IndexOf('=') + 1)); return(Convert.ToInt32(DepID)); } } } } catch (Exception e) { return(0); } return(0); }
public List <KitchenNotification> GetKitchenNotification(int buildingid) { DateTime TodayDate = System.DateTime.Now.Date; List <KitchenNotification> kitchenNotificationList = new List <KitchenNotification>(); KitchenNotification kitchenNotification; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { var notDeliveredCount = entity.BookingDetails.Where(ord => ord.BuildingID == buildingid && DbFunctions.TruncateTime(ord.FromDate) <= TodayDate && ord.IsClean == false && ord.IsDeliver == false && ord.BookingServiceLists.Count(s => s.IsKitchen == true && s.Status == false) > 0).GroupBy(info => DbFunctions.TruncateTime(info.FromDate)).Select(group => new { FromDate = DbFunctions.TruncateTime(group.Key), NotDeliveredCount = group.Count(), NotClearUpCount = 0 }).OrderBy(x => DbFunctions.TruncateTime(x.FromDate)); var notClearUpCount = entity.BookingDetails.Where(ord => ord.BuildingID == buildingid && DbFunctions.TruncateTime(ord.FromDate) <= TodayDate && ord.IsClean == false && ord.IsDeliver == true && ord.BookingServiceLists.Count(s => s.IsKitchen == true && s.Status == false) > 0).GroupBy(info => DbFunctions.TruncateTime(info.FromDate)).Select(group => new { FromDate = DbFunctions.TruncateTime(group.Key), NotDeliveredCount = 0, NotClearUpCount = group.Count() }).OrderBy(x => DbFunctions.TruncateTime(x.FromDate)); var result = notDeliveredCount.Union(notClearUpCount); var groupby = result.GroupBy(info => DbFunctions.TruncateTime(info.FromDate)).Select(group => new { FromDate = DbFunctions.TruncateTime(group.Key), NotDeliveredCount = group.Sum(x => x.NotDeliveredCount), NotClearUpCount = group.Sum(x => x.NotClearUpCount) }).OrderBy(x => DbFunctions.TruncateTime(x.FromDate)); foreach (var line in groupby) { kitchenNotification = new KitchenNotification(); kitchenNotification.Fromdate = line.FromDate; kitchenNotification.NotDeliveredCount = line.NotDeliveredCount; kitchenNotification.NotClearUpCount = line.NotClearUpCount; kitchenNotificationList.Add(kitchenNotification); } } return(kitchenNotificationList); }
public string DeleteUserGroupList(int userGroupId, int userId) { string message = ""; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { //For Single record var singleRec = entity.UserGroup_User.FirstOrDefault(x => x.UserGroupId == userGroupId && x.UserId == userId); // object your want to delete if (singleRec != null) { entity.UserGroup_User.Remove(singleRec); entity.SaveChanges(); message = "Delete Successfully"; } else { message = "Delete Unsuccessfully"; } } return(message); }
public IEnumerable <UserMaster> GetPersonList(int OrgUnitId) { using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { //if( UserAccess.SelfOnly() ) //{ // _persons = SiteBuilder.Content.Person.ByPersonId( Digimaker.User.Identity.ID, true ); //} //else //{ _persons = SiteBuilder.Content.Person.ByOrgUnitId(OrgUnitId, true, true); // } for (int i = 0; i < _persons.Person.Count; i++) { if (string.IsNullOrEmpty(_persons.Person[i]["Custom2"] == DBNull.Value ? string.Empty :_persons.Person[i]["Custom2"].ToString())) { //string orgUnitName = string.Empty; //string orgUnitId = string.Empty; //bool isPrimary = false; //bool flag = false; //Digimaker.Schemas.Web.PersonViewData.OrganizationUnit_PersonRow[] orgs = _persons.Person[i].GetOrganizationUnit_PersonRows(); //if (orgs.Length > 0) //{ // orgUnitName = orgs[0].OrganizationUnitName.ToString(); // orgUnitId = orgs[0].OrganizationUnitId.ToString(); // if (orgUnitId != null) // { // int orgUId = Convert.ToInt32(orgUnitId); // int OrgParentId = Convert.ToInt32(entity.OrganizationUnits.Where(w => w.OrganizationUnitID == orgUId).Select(s => s.ParentID).FirstOrDefault()); // // internal Customers // string internalCustomersIds = Digimaker.Config.Custom.AppSettings["InternalCustomers"].ToString(); // "2038,4, 2037,2030"; // List<int> internalCustIds = internalCustomersIds.Split(',').Select(int.Parse).ToList(); // if (internalCustIds.Contains(OrgParentId)) // { // isPrimary = true; // flag = true; // } // // external Costumers // string externalCostumersIds = Digimaker.Config.Custom.AppSettings["ExternalCostumers"].ToString(); //"3039"; // List<int> externalCustIds = externalCostumersIds.Split(',').Select(int.Parse).ToList(); // if (externalCustIds.Contains(OrgParentId)) // { // isPrimary = false; // flag = true; // } // } //} //if (flag) { userMaster.Add(new UserMaster { PersonID = Convert.ToInt32(_persons.Person[i].PersonId), GivenName = _persons.Person[i].GivenName.ToString(), FamilyName = _persons.Person[i].FamilyName.ToString(), DisplayName = _persons.Person[i].DisplayName.ToString() }); // } } } } return(userMaster); }
public async Task <ApiResponse> orderAsync(int OrderNo) { ApiResponse response = new ApiResponse(); using (var session = new TripletexSession()) { try { var consumerKey = Digimaker.Config.Custom.AppSettings["consumerKey"].ToString(); var employeeKey = Digimaker.Config.Custom.AppSettings["employeeKey"].ToString(); var customerNumber = Digimaker.Config.Custom.AppSettings["CustomerNo"].ToString(); // var productNumber = CloudConfigurationManager.GetSetting("TripletexProductNumber"); if (await session.CreateSessionToken(consumerKey, employeeKey)) { using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { //// check the Product Number var resfood1 = from ord in entity.BookingServiceLists where ord.BookingID == OrderNo && ord.IsKitchen == true && ord.Status == false select ord; foreach (var it in resfood1) { if (it.ArticleId != "0") { var product1 = await session.GetProductFromNumberChecking(it.ArticleId, "id", "name", "vatType(id)", "priceExcludingVatCurrency"); if (product1 == 0) { response.message = "Article id does not exist in Tripletex, article id :-" + it.ArticleId; response.errorType = (int)Enums.ErrorType.Error; return(response); } } } //// var customerNo = entity.BookingDetails.Where(w => w.BookingID == OrderNo).Select(s => s).FirstOrDefault(); // 14008116 //var customer = await session.GetCustomerFromCustomerNo((int)customerNo.Customer, "id", "name"); var customer = await session.GetCustomerFromCustomerNo(Convert.ToInt32(customerNumber), "id", "name"); if (customer != null) { var order = new JObject(); order["orderDate"] = ((DateTime)customerNo.FromDate).ToString("yyyy-MM-dd"); // "2019-04-25"; order["deliveryDate"] = ((DateTime)customerNo.FromDate).ToString("yyyy-MM-dd"); order["customer"] = JObject.FromObject(new { id = customer["id"] }); order["reference"] = "BookingID: " + customerNo.BookingID.ToString(); int departmentid = GetKitchenDepID(Convert.ToInt32(customerNo.BuildingID)); if (departmentid > 0) { var department = await session.GetdepartmentFromNumber(departmentid.ToString(), "id"); order["department"] = JObject.FromObject(new { id = department["id"] }); } var rsp = await session.CreateOrder(order); // product //// food list var resfood = from ord in entity.BookingServiceLists where ord.BookingID == OrderNo && ord.IsKitchen == true && ord.Status == false select ord; foreach (var it in resfood) { var orderLine = new JObject(); if (it.ArticleId != "0") { var product = await session.GetProductFromNumber(it.ArticleId, "id", "name", "vatType(id)", "priceExcludingVatCurrency"); if (product != null) { orderLine["product"] = JObject.FromObject(new { id = product["id"] }); orderLine["vatType"] = JObject.FromObject(new { id = product["vatType"]["id"] }); orderLine["unitPriceExcludingVatCurrency"] = it.CostPrice; orderLine["count"] = it.Qty; } } orderLine["description"] = it.Tekst; orderLine["order"] = JObject.FromObject(rsp); var rsp1 = await session.CreateOrderLine(orderLine); } } } // try // { // // var invoice = await session.CreateInvoice(order["id"].Value<int>(), lastDayOfMonth); // //log.Info($"Created and sent invoice {invoice["invoiceNumber"]}"); // //return invoice; // } // catch (Exception e) // { // // log.Error($"Could not create invoice of order {order["orderNumber"]}"); // } } else { response.message = await session.CreateSessionTokenCheck(consumerKey, employeeKey); response.errorType = (int)Enums.ErrorType.Error; return(response); } } catch (Exception e) { response.message = e.Message; response.errorType = (int)Enums.ErrorType.Error; return(response); } finally { await session.DestroySessionToken(); } } response.message = "Successfully order"; response.errorType = (int)Enums.ErrorType.Success; return(response); }
public KitchenDisplay GetKitchenDisplay(DateTime TodayDate, int buildingid) { this.CheckAccess(); DateTime TodayDate1 = TodayDate.Date;// System.DateTime.Now.Date; KitchenDisplay kitchenDisplay = new KitchenDisplay(); using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { // Food Not Cleaned List List <FoodNotCleanedList> notcleanedList = new List <FoodNotCleanedList>(); FoodNotCleanedList notclean; var result = from ord in entity.BookingDetails where ord.BuildingID == buildingid && DbFunctions.TruncateTime(ord.FromDate) == TodayDate1 && ord.IsClean == false && ord.IsDeliver == true && ord.BookingServiceLists.Count(s => s.IsKitchen == true) > 0 select ord; foreach (var item in result) { notclean = new FoodNotCleanedList(); //string text = entity.BookingServiceLists.Where(w => w.BookingID == item.BookingID && w.IsMainService == true).Select(s => s.Tekst).FirstOrDefault(); string text = entity.Articles.Where(w => w.MainID == item.ServiceID && w.Status == 0).Select(s => s.Headline).FirstOrDefault(); notclean.OrderNo = item.BookingID; notclean.Text = text + " " + item.BookingName; notclean.Todate = item.ToDate; notclean.Fromdate = item.FromDate; notclean.NoOFPeople = item.NoOfPeople; notcleanedList.Add(notclean); } kitchenDisplay.FoodNotCleanedList = notcleanedList; // Food Not Delivered List List <FoodNotDeliveredList> notdeliveredList = new List <FoodNotDeliveredList>(); FoodNotDeliveredList notdelivered; FoodList food; var res = from ord in entity.BookingDetails where ord.BuildingID == buildingid && DbFunctions.TruncateTime(ord.FromDate) == TodayDate1 && ord.IsClean == false && ord.IsDeliver == false && ord.BookingServiceLists.Count(s => s.IsKitchen == true) > 0 select ord; foreach (var item in res) { notdelivered = new FoodNotDeliveredList(); List <FoodList> foodList = new List <FoodList>(); //string text = entity.BookingServiceLists.Where(w => w.BookingID == item.BookingID && w.IsMainService == true).Select(s => s.Tekst).FirstOrDefault(); string text = entity.Articles.Where(w => w.MainID == item.ServiceID && w.Status == 0).Select(s => s.Headline).FirstOrDefault(); notdelivered.OrderNo = item.BookingID; notdelivered.Text = text + " " + item.BookingName; notdelivered.Todate = item.ToDate; notdelivered.Fromdate = item.FromDate; notdelivered.NoOFPeople = item.NoOfPeople; //// food list var resfood = from ord in entity.BookingServiceLists where ord.BookingID == item.BookingID && ord.IsKitchen == true && ord.Status == false select ord; bool isFoodservice = false; foreach (var it in resfood) { food = new FoodList(); food.Text = it.Tekst; food.Quantity = it.Qty; food.DeliverTime = it.Time; foodList.Add(food); isFoodservice = true; } if (isFoodservice) { notdelivered.FoodList = foodList; notdeliveredList.Add(notdelivered); } } kitchenDisplay.FoodNotDeliveredList = notdeliveredList; } return(kitchenDisplay); }
public IEnumerable <OrganizationPerson> UserListbyBuilding(int buildingId, int orgId) { List <OrganizationPerson> userList = new List <OrganizationPerson>(); OrganizationPerson user; using (BraathenEiendomEntities entity = new BraathenEiendomEntities()) { if (buildingId != 0) { var orgList = entity.OrganizationUnits.Where(w => w.ParentID == buildingId).Select(s => new { s.OrganizationUnitID, s.OrganizationUnitName }).ToList(); if (orgList != null) { foreach (var item in orgList) { var persons = entity.People.Join(entity.OrganizationUnit_Person, p => p.PersonID, o => o.PersonID, (P, O) => new { p = P, o = O }) .Where(w => w.o.OrganizationUnitID == item.OrganizationUnitID).Select(s => s.p).OrderBy(o => o.DisplayName).ToList(); if (persons != null) { foreach (var p in persons.Where(p => p.Custom2 == null || p.Custom2 == "")) { user = new OrganizationPerson(); user.id = p.PersonID; user.name = p.DisplayName; user.telephone = p.MobilePhone; user.UserEmail = p.Email; user.Department = p.Custom1; user.UserGroup = string.Join(",", entity.UserGroups.Join(entity.UserGroup_User, gp => gp.UserGroupId, go => go.UserGroupId, (GP, GO) => new { gp = GP, go = GO }) .Where(w => w.go.UserId == p.PersonID).Select(gs => gs.gp.UserGroupName)); user.OrganizationName = item.OrganizationUnitName; userList.Add(user); } } } } } else { if (orgId != 0) { var persons = entity.People.Join(entity.OrganizationUnit_Person, p => p.PersonID, o => o.PersonID, (P, O) => new { p = P, o = O }) .Where(w => w.o.OrganizationUnitID == orgId).Select(s => s.p).OrderBy(o => o.DisplayName).ToList(); if (persons != null) { foreach (var p in persons.Where(p => p.Custom2 == null || p.Custom2 == "")) { user = new OrganizationPerson(); user.id = p.PersonID; user.name = p.DisplayName; user.telephone = p.MobilePhone; user.UserEmail = p.Email; user.Department = p.Custom1; user.UserGroup = string.Join(",", entity.UserGroups.Join(entity.UserGroup_User, gp => gp.UserGroupId, go => go.UserGroupId, (GP, GO) => new { gp = GP, go = GO }) .Where(w => w.go.UserId == p.PersonID).Select(gs => gs.gp.UserGroupName)); userList.Add(user); } } } } } userList = userList.OrderBy(o => o.name).ToList(); return(userList); }