public void GetPersonAndDormIdByEmail(string email, out int personId, out int dormId) { int _personId = Mails.GetAll().Where(x => x.email == email).Select(x => x.person_id).SingleOrDefault(); personId = _personId; dormId = Agreements.GetAll().Where(x => (x.person_id == _personId)).Select(x => x.dorm_id).SingleOrDefault(); }
/// <summary> /// Dependent type names of this entity /// </summary> public void DeleteChildren(DatabaseEntities dbContext) { foreach (var x in Agreements.ToList()) { x.DeleteFull(dbContext); } foreach (var x in FocusAreas.ToList()) { x.DeleteFull(dbContext); } foreach (var x in GrantAllocations.ToList()) { x.DeleteFull(dbContext); } foreach (var x in PersonStewardRegions.ToList()) { x.DeleteFull(dbContext); } foreach (var x in ProjectRegions.ToList()) { x.DeleteFull(dbContext); } foreach (var x in ProjectRegionUpdates.ToList()) { x.DeleteFull(dbContext); } }
public bool PersonExists(RegistrationData registrationData) { int roomTypeId, dormId; roomTypeId = RoomTypes.GetRoomTypeId(registrationData.RoomType); dormId = Dormitories.GetDormIdByName(registrationData.DormitoryName); int count = Persons.GetAll().Join( Agreements.GetAll(), p => p.id_person, a => a.person_id, (p, a) => new KeyValuePair <Person, Agreement>(p, a)).Where( x => (x.Key.surname == registrationData.Surname) && (x.Key.name == registrationData.Name) && (x.Key.is_living == true) && (x.Value.room_id == roomTypeId) && (x.Value.room_number == registrationData.RoomNumber) && (x.Value.dorm_id == dormId)).Select(res => res.Key.id_person).ToList().Count(); if (count == 1) { return(true); } else { return(false); } }
public void Agreements_can_get_data() { SenderMock sender = Arrange_sender(); Agreements agreements = new Agreements("", "", sender); Assert.IsTrue(agreements.Any()); }
/// <summary> /// Active Dependent type names of this object /// </summary> public List <string> DependentObjectNames() { var dependentObjects = new List <string>(); if (Agreements.Any()) { dependentObjects.Add(typeof(Agreement).Name); } if (FocusAreas.Any()) { dependentObjects.Add(typeof(FocusArea).Name); } if (GrantAllocations.Any()) { dependentObjects.Add(typeof(GrantAllocation).Name); } if (PersonStewardRegions.Any()) { dependentObjects.Add(typeof(PersonStewardRegion).Name); } if (ProjectRegions.Any()) { dependentObjects.Add(typeof(ProjectRegion).Name); } if (ProjectRegionUpdates.Any()) { dependentObjects.Add(typeof(ProjectRegionUpdate).Name); } return(dependentObjects.Distinct().ToList()); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Agreements model) { using (DBHelper db = DBHelper.Create()) { db.Insert <Agreements>(model); } }
public Task <Agreements> UpdateCodeOfConduct(UpdateCodeOfConduct data) { return(Task.Run(() => { var agreements = gameData.GetAllAgreements(); var coc = agreements.FirstOrDefault(x => x.Type.ToLower() == "coc"); if (coc != null) { if (coc.Message != data.Message || coc.Title != data.Title || coc.VisibleInClient != data.VisibleInClient) { coc.Message = data.Message; coc.Title = data.Title; coc.Revision = coc.Revision + 1; coc.LastModified = DateTime.UtcNow; coc.VisibleInClient = data.VisibleInClient; } } else { coc = new Agreements { Id = Guid.NewGuid(), Type = "coc", Message = data.Message, Title = data.Title, Revision = 1, ValidFrom = DateTime.UtcNow, LastModified = DateTime.UtcNow, VisibleInClient = data.VisibleInClient }; gameData.Add(coc); } return coc; })); }
/// <summary> /// Dependent type names of this entity /// </summary> public void DeleteChildren(DatabaseEntities dbContext) { foreach (var x in Agreements.ToList()) { x.DeleteFull(dbContext); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Agreements model) { using (DBHelper db = DBHelper.Create()) { db.Update <Agreements>(model); return(true); } }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string ID) { using (DBHelper db = DBHelper.Create()) { Agreements agreements = db.GetById <Agreements>(ID); return(agreements.ID != string.Empty); } }
public IEnumerable <Person> GetPeopleLivingInRoom(int dormId, int room) { return(Persons.GetAll().Join(Agreements.GetAll(), person => person.id_person, agreement => agreement.person_id, (person, agreement) => new KeyValuePair <Person, Agreement>(person, agreement) ).Where(res => res.Key.is_living == true && (res.Value.room_number == room) && (res.Value.dorm_id == dormId) ).Select(res => res.Key).ToList()); }
/// <summary> /// Active Dependent type names of this object /// </summary> public List <string> DependentObjectNames() { var dependentObjects = new List <string>(); if (Agreements.Any()) { dependentObjects.Add(typeof(Agreement).Name); } return(dependentObjects.Distinct().ToList()); }
public Agreement CreateAgreement(Dictionary <string, int> values) { var a = new Agreement(values, 0) { Id = Agreements.Count + 1 }; Agreements.Add(a); return(a); }
/// <summary> /// Active Dependent type names of this object /// </summary> public List <string> DependentObjectNames() { var dependentObjects = new List <string>(); if (Agreements.Any()) { dependentObjects.Add(typeof(Agreement).Name); } if (GisUploadSourceOrganizationsWhereYouAreTheDefaultLeadImplementerOrganization.Any()) { dependentObjects.Add(typeof(GisUploadSourceOrganization).Name); } if (Grants.Any()) { dependentObjects.Add(typeof(Grant).Name); } if (GrantAllocations.Any()) { dependentObjects.Add(typeof(GrantAllocation).Name); } if (OrganizationBoundaryStagings.Any()) { dependentObjects.Add(typeof(OrganizationBoundaryStaging).Name); } if (People.Any()) { dependentObjects.Add(typeof(Person).Name); } if (PersonStewardOrganizations.Any()) { dependentObjects.Add(typeof(PersonStewardOrganization).Name); } if (Programs.Any()) { dependentObjects.Add(typeof(Program).Name); } if (ProjectOrganizations.Any()) { dependentObjects.Add(typeof(ProjectOrganization).Name); } if (ProjectOrganizationUpdates.Any()) { dependentObjects.Add(typeof(ProjectOrganizationUpdate).Name); } return(dependentObjects.Distinct().ToList()); }
public ChangeAgreementEvent CreateChangeAgreementEvent(int agrId, Dictionary <string, int> changes, int valeur) { if (!Agreements.Any(x => x.Id.Equals(agrId))) { return(null); } var ce = new ChangeAgreementEvent(agrId, changes, valeur); AgreementEvents.Add(ce); return(ce); }
public AccountData GetSuitableTariff(int person_id, int dormId) { try { bool is_student, on_budget; bool? on_budgetNull; int roomId; decimal amount, price; is_student = Persons.GetAll() .Where(per => per.id_person == person_id) .Select(per => per.is_student) .ToList().Last(); on_budgetNull = Persons.GetAll() .Where(per => per.id_person == person_id) .Select(per => per.on_budget) .ToList() .Last(); on_budget = on_budgetNull.HasValue ? on_budgetNull.Value : false; roomId = Agreements.GetAll() .Where( agr => (agr.person_id == person_id) && (agr.dorm_id == dormId) && (agr.is_active == true)) .Select(agr => agr.room_id) .ToList() .Last(); price = Prices.GetAll() .Where( p => (p.is_student == is_student && p.on_budget == on_budget && p.is_active == true && p.dorm_id == dormId && p.room_id == roomId)). Select(p => p.price) .ToList() .Last(); amount = Accounts.GetAll() .Where(account => account.id_person == person_id) .Select(account => account.sum) .ToList() .Last(); return(new AccountData { IsStudent = is_student, IsBudget = on_budget, AccountAmount = amount, PricePerMonth = price }); } catch (Exception ex) { Debug.WriteLine(ex.ToString()); return(new AccountData()); } }
/// <summary> /// Dependent type names of this entity /// </summary> public void DeleteChildren(DatabaseEntities dbContext) { foreach (var x in Agreements.ToList()) { x.DeleteFull(dbContext); } foreach (var x in GisUploadSourceOrganizationsWhereYouAreTheDefaultLeadImplementerOrganization.ToList()) { x.DeleteFull(dbContext); } foreach (var x in Grants.ToList()) { x.DeleteFull(dbContext); } foreach (var x in GrantAllocations.ToList()) { x.DeleteFull(dbContext); } foreach (var x in OrganizationBoundaryStagings.ToList()) { x.DeleteFull(dbContext); } foreach (var x in People.ToList()) { x.DeleteFull(dbContext); } foreach (var x in PersonStewardOrganizations.ToList()) { x.DeleteFull(dbContext); } foreach (var x in Programs.ToList()) { x.DeleteFull(dbContext); } foreach (var x in ProjectOrganizations.ToList()) { x.DeleteFull(dbContext); } foreach (var x in ProjectOrganizationUpdates.ToList()) { x.DeleteFull(dbContext); } }
public void Agreements_can_get_data_from_of() { ofplug.of.Sender sender = new ofplug.of.Sender(); Agreements agreements = new Agreements("http://of.devflowtwo.com/kirkenskorshaer/api/v2/", "", sender); int id_index = 0; foreach (int id in agreements) { id_index++; Console.Out.WriteLine(id_index + ": " + id.ToString()); } }
public void MovePersonOut(PersonData person, string admin_name, int dorm_id) { Persons.GetAll().Where(p => p.id_person == GetPersonId(person)).ToList().ForEach(x => { x.is_living = false; }); Agreements.GetAll().Where(a => a.person_id == GetPersonId(person)).ToList().ForEach(x => { x.is_active = false; }); History.Add(new History { admin_name = admin_name, dorm_id = dorm_id, description = person.SurName + " " + person.Name + " " + "выселен(-а) из " + person.Room, moveOutFlag = true }); }
public string GetRoomType(int person_id) { try { return(RoomTypes.GetAll().Join( Agreements.GetAll(), r => r.id_type, a => a.room_id, (r, a) => new KeyValuePair <RoomType, Agreement>(r, a)) .Where(res => res.Value.person_id == person_id) .Select(res => res.Key.name).ToList().Last()); } catch { return("..."); } }
/// <summary> /// 获取收费协议json /// </summary> /// <param name="param"></param> /// <param name="agree"></param> /// <param name="itemCount"></param> /// <returns></returns> public List <dynamic> SearchContrast(EasyUIGridParamModel param, Agreements agree, Customer c, out int itemCount) { List <SqlParameter> paramList = new List <SqlParameter>(); StringBuilder StrSql = new StringBuilder(); StrSql.Append(@"select a.ID,c.ID as customerID,c.Code,c.Name,a.Money,a.Status, a.begindate,a.enddate,a.createtime,a.checktime,a.Code as agreementCode from T_Agreements a left join T_Customer c on c.ID=a.CustomerID where 1=1 "); Dictionary <string, object> paramDic = new Dictionary <string, object>(); if (!string.IsNullOrEmpty(agree.ID)) { StrSql.Append("and a.ID=@ID "); paramDic.Add("ID", agree.ID); } if (agree.BeginDate.ToString() != "0001/1/1 0:00:00" && agree.EndDate.ToString() != "0001/1/1 0:00:00") { StrSql.Append("and a.begindate>=@beginDate and a.enddate<=@endDate "); paramDic.Add("beginDate", agree.BeginDate); paramDic.Add("endDate", agree.EndDate); } if (agree.Status != -1) { StrSql.Append("and a.status=@status "); paramDic.Add("status", agree.Status); } if (!string.IsNullOrEmpty(agree.CustomerID)) { StrSql.Append("and c.ID=@customerID "); paramDic.Add("customerID", agree.CustomerID); } if (!string.IsNullOrEmpty(c.Name)) { StrSql.Append("and c.Name like @name "); paramDic.Add("name", string.Format("%{0}%", c.Name)); } int pageIndex = Convert.ToInt32(param.page) - 1; int pageSize = Convert.ToInt32(param.rows); using (DBHelper db = DBHelper.Create()) { itemCount = db.GetCount(string.Format(DBHelper.StrGetCountSql, StrSql), paramDic); return(db.GetDynaminObjectList(StrSql.ToString(), pageIndex, pageSize, null, paramDic)); } }
public string GetRoomGender(int dormId, int roomNumber, int roomTypeId) { List <bool> isMale; isMale = Persons.GetAll() .Join( Agreements.GetAll(), person => person.id_person, agreement => agreement.person_id, (person, agreement) => new KeyValuePair <Person, Agreement>(person, agreement) ) .Where(res => (res.Key.is_living == true) && (res.Value.room_id == roomTypeId) && (res.Value.is_active == true) && (res.Value.room_number == roomNumber) && (res.Value.dorm_id == dormId)) .Select(res => res.Key.is_male) .ToList(); if (isMale.Count != 0) { bool first = isMale.First(); //true, if there is a man in room bool q = true; //true, if all the elements the same foreach (bool item in isMale) { if (item != first) { q = false; break; } } if (!q) { return("М/Ж"); } else if (first) { return("М"); } else { return("Ж"); } } else { return("-"); } }
public ActionResult ModifyAgree(Agreements a) { AjaxResult result = new AjaxResult(); try { result.Success = new AgreementsRule().Update(a); result.Message = "协议修改成功。"; } catch { result.Success = false; result.Message = "协议修改失败。"; } return(Json(result, JsonRequestBehavior.AllowGet)); }
bool makeGroupIdBasketndAgreement(PaymentViewModel model) { IList <Basket> basketList = _mainContext.baskets.Where(w => w.basketStatus == BasketStatusEnum.active && w.userId == _usersService.getUserInformation(_cookieService.getSessionEmail()).userId).ToList(); Guid responsibleUser = new Guid(); responsibleUser = _usersService.getUserInformation(_cookieService.getSessionEmail()).responsibleUserId; foreach (var item in basketList) { Guid agreementsId = Guid.NewGuid(); int firstStatus = _agreementService.getFirstStatus(); item.basketGroupId = model.basketGroupId; item.basketStatus = BasketStatusEnum.done; Agreements agreementsModel = new Agreements(); agreementsModel.id = agreementsId; agreementsModel.appCategoryType = ApplicationCategoryTypesEnum.brand; agreementsModel.basketId = item.basketId; agreementsModel.groupId = model.basketGroupId; agreementsModel.companyIdForInvoice = Convert.ToInt32(model.selectedCompanieForInvoice); agreementsModel.statusId = firstStatus; agreementsModel.generalStatus = GeneralStatusEnum.Active; agreementsModel.paymentType = model.paymentStatus; agreementsModel.processDate = DateTime.Now; if (responsibleUser != new Guid()) { agreementsModel.responsibleUserId = responsibleUser; } AgreementsChanges agreementsChangesModel = new AgreementsChanges(); agreementsChangesModel.agreementId = agreementsId; agreementsChangesModel.comments = ""; agreementsChangesModel.generalStatus = GeneralStatusEnum.Active; agreementsChangesModel.processDate = DateTime.Now; agreementsChangesModel.status = firstStatus; agreementsChangesModel.userId = _usersService.getUserInformation(_cookieService.getSessionEmail()).userId; _mainContext.Add(agreementsChangesModel); _mainContext.Add(agreementsModel); } if (_mainContext.SaveChanges() > 0) { return(true); } else { return(false); } }
public int GetPersonId(PersonData person) { try { return(Persons.GetAll().Join( Agreements.GetAll(), p => p.id_person, a => a.person_id, (p, a) => new KeyValuePair <Person, Agreement>(p, a)).Where( x => (x.Key.surname == person.SurName) && (x.Key.name == person.Name) && (x.Key.is_living == true) && (x.Value.room_number == person.Room) && (x.Value.dorm_id == person.DormID)).Select(res => res.Key.id_person).ToList().SingleOrDefault()); } catch { return(0); } }
public IEnumerable <int> GetLivingRooms(int floor, int dormId) { return (Persons.GetAll() .Join( Agreements.GetAll(), person => person.id_person, agreement => agreement.person_id, (person, agreement) => new KeyValuePair <Person, Agreement>(person, agreement) ) .Where(res => (res.Key.is_living == true) && (res.Value.floor_number == floor) && (res.Value.is_active == true) && (res.Value.dorm_id == dormId)) .Select(res => res.Value.room_number) .Distinct() .ToList()); }
public IHttpActionResult UpdateAgreement(int id, [FromBody] BaseRate.RateType newBaseRateType) { Agreement agreement = db.Agreements.Include("Customer").SingleOrDefault(x => x.Id == id); if (agreement == null) { return(NotFound()); } BaseRate.RateType oldBaseRateType = agreement.BaseRateType; agreement.BaseRateType = newBaseRateType; db.MarkAsModified(agreement); try { db.SaveChanges(); } catch (Exception ex) { return(InternalServerError(ex)); } // check if base rate record exists BaseRate currentBaseRate = db.BaseRates.SingleOrDefault(x => x.Code == oldBaseRateType); BaseRate newBaseRate = db.BaseRates.SingleOrDefault(x => x.Code == newBaseRateType); if (currentBaseRate == null || newBaseRate == null) { // Better solution would be to throw a custom exception with an error message return(InternalServerError(new ArgumentNullException("Base Rate record was not found"))); } // to client we need to return an agreement with an old base rate type agreement.BaseRateType = oldBaseRateType; var agremeentExtended = Agreements.GetExtendedAgreement(agreement, newBaseRateType, currentBaseRate.Value, newBaseRate.Value); return(Ok(agremeentExtended)); }
public void ChangeRoom(PersonData person, NewPlace place, string admin_name, int dorm_id) { Agreements.GetAll().Where(a => a.person_id == GetPersonId(person)).ToList(). ForEach(x => { x.floor_number = place.NewFloor; x.room_number = place.NewRoom; x.room_id = place.NewRoomTypeId; }); History.Add( new History { admin_name = admin_name, dorm_id = dorm_id, description = person.SurName + " " + person.Name + " " + "переехал(-а) из " + person.Room + " в " + place.NewRoom, changeRoomFlag = true }); }
public ActionResult AddAgree(Agreements agree) { AjaxResult result = new AjaxResult(); try { agree.CheckTime = DateTime.MaxValue; agree.ID = WebHelper.GetNewGuidUpper(); agree.CheckOperatorID = MyTicket.CurrentTicket.UserID; agree.CreateTime = DateTime.Now; new AgreementsRule().Add(agree); result.Success = true; result.Message = "协议添加成功"; } catch (Exception ex) { result.Success = false; result.Message = "协议添加失败:" + ex.Message; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult SearchAgree(EasyUIGridParamModel param, Agreements agree, Ajax.Model.Customer c) { int itemCount = 0; List <dynamic> agreeList = new AgreementsRule().SearchAgree(param, agree, c, out itemCount); var showList = from a in agreeList select new { ID = a.ID, CONTRASTID = a.ID, CUSTOMERID = a.CUSTOMERID, CODE = a.CODE, NAME = a.NAME, MONEY = a.MONEY, BEGINDATE = a.BEGINDATE, AGREEMENTCODE = a.AGREEMENTCODE, ENDDATE = TimeParser.FormatDateTime(a.ENDDATE), STATUS = Convert.ToString(a.STATUS).Replace("0", "未审核").Replace("1", "已审核").Replace("2", "已删除") }; return(Json(new { total = itemCount, rows = showList }, JsonRequestBehavior.AllowGet)); }