public static SystemSettingType GetPercentageofLoanAmountPaidType(FinancialEntities context) { var type = context.SystemSettingTypes.SingleOrDefault(entity => entity.Name == PercentageofLoanAmountPaid); InitialDatabaseValueChecker.ThrowIfNull<SystemSettingType>(type); return type; }
public static SystemSettingType GetInvoiceGenerationTimingType(FinancialEntities context) { var type = context.SystemSettingTypes.SingleOrDefault(entity => entity.Name == InvoiceGenerationTiming); InitialDatabaseValueChecker.ThrowIfNull<SystemSettingType>(type); return type; }
protected void OnChange(object sender, DirectEventArgs e) { List<PartyType> partyType = new List<PartyType>(); List<CustomerStatusType> cusStatType = new List<CustomerStatusType>(); List<Country> country = new List<Country>(); using (var context = new FinancialEntities()) { partyType = context.PartyTypes.ToList(); cusStatType = context.CustomerStatusTypes.ToList(); country = context.Countries.ToList(); } if (cmbFilterBy.SelectedItem.Text.Equals("Status")) { FilterStore.DataSource = cusStatType; cmbFilterBy2.Show(); } else if (cmbFilterBy.SelectedItem.Text.Equals("Party Type")) { FilterStore.DataSource = partyType; cmbFilterBy2.Show(); } else { cmbFilterBy2.Hide(); } CountryStore.DataSource = country; CountryStore.DataBind(); FilterStore.DataBind(); }
public static SystemSettingType GetGracePeriodType(FinancialEntities context) { var type = context.SystemSettingTypes.SingleOrDefault(entity => entity.Name == GracePeriod); InitialDatabaseValueChecker.ThrowIfNull<SystemSettingType>(type); return type; }
public static UnitOfMeasure GetSemiMonthlyType(FinancialEntities context) { var type = context.UnitOfMeasures.SingleOrDefault(entity => entity.Name == SemiMonthly); InitialDatabaseValueChecker.ThrowIfNull<UnitOfMeasure>(type); return type; }
public static SystemSettingType GetAllowableNumberofStraightLineLoanPerCustomerType(FinancialEntities context) { var type = context.SystemSettingTypes.SingleOrDefault(entity => entity.Name == AllowableNumberofStraightLineLoanPerCustomer); InitialDatabaseValueChecker.ThrowIfNull<SystemSettingType>(type); return type; }
public static AddressType GetPostalAddressType(FinancialEntities context) { AddressType postalAddressType = new AddressType(); postalAddressType = context.AddressTypes.SingleOrDefault(entity => entity.Name == AddressTypeEnums.PostalAddress); InitialDatabaseValueChecker.ThrowIfNull<AddressType>(postalAddressType); return postalAddressType; }
public static SystemSettingType GetDemandCollectionAfterType(FinancialEntities context) { var type = context.SystemSettingTypes.SingleOrDefault(entity => entity.Name == DemandCollectionAfter); InitialDatabaseValueChecker.ThrowIfNull<SystemSettingType>(type); return type; }
public static PostalAddress GetCurrentPostalAddress(FinancialEntities context, Party party, PostalAddressType type, Func<Address, bool> condition) { Address address = party.Addresses.SingleOrDefault(entity => entity.EndDate == null && entity.PostalAddress.PostalAddressTypeId == type.Id && condition(entity)); if (address != null) return address.PostalAddress; return null; }
protected void Page_Load(object sender, EventArgs e) { if (X.IsAjaxRequest == false && this.IsPostBack == false) { if (this.LoginInfo.UserType == UserAccountType.Teller.Name) { btnEdit.Hidden = true; btnSave.Hidden = true; btnOpen.Hidden = true; } int id = int.Parse(Request.QueryString["id"]); hiddenId.Text = id.ToString(); using (var context = new FinancialEntities()) { Holiday holiday = context.Holidays.SingleOrDefault(entity => entity.Id == id); if (holiday != null) { this.txtName.Value = holiday.Name; this.dtHoliday.SelectedDate = holiday.Date; this.txtDesciption.Text = holiday.Description; this.txtNotes.Text = holiday.Notes; } else { // TODO:: Don't know how to handle for now. } } if (Holiday.GetById(id) == null) throw new AccessToDeletedRecordException("The selected holiday has already been deleted by another user."); } }
public static void CreateOrUpdatePostalAddress(FinancialEntities context, PostalAddress currentPostalAddress, PostalAddress newPostalAddress, DateTime now) { //check if is equal; bool equal = true; equal &= currentPostalAddress.Barangay == newPostalAddress.Barangay; equal &= currentPostalAddress.StreetAddress == newPostalAddress.StreetAddress; equal &= currentPostalAddress.Country == newPostalAddress.Country; equal &= currentPostalAddress.City == newPostalAddress.City; equal &= currentPostalAddress.Municipality == newPostalAddress.Municipality; equal &= currentPostalAddress.PostalCode == newPostalAddress.PostalCode; equal &= currentPostalAddress.Province == newPostalAddress.Province; equal &= currentPostalAddress.State == newPostalAddress.State; if (equal == false) { currentPostalAddress.Address.EndDate = now; Address address = new Address(); address.Party = currentPostalAddress.Address.Party; address.AddressType = currentPostalAddress.Address.AddressType; address.EffectiveDate = now; newPostalAddress.Address = address; newPostalAddress.PostalAddressType = currentPostalAddress.PostalAddressType; context.PostalAddresses.AddObject(newPostalAddress); } }
public int checkBranch() { int result = 0; var name = txtName.Text; using (var context = new FinancialEntities()) { // check if inputed name equal to organization name var bankRoleType = context.RoleTypes.SingleOrDefault(entity => entity.Name == RoleTypeEnums.Bank); InitialDatabaseValueChecker.ThrowIfNull<RoleType>(bankRoleType); var sameBankName = context.BankViewLists.FirstOrDefault(entity => entity.Organization_Name == name); if (sameBankName != null) { hiddenID.Value = sameBankName.PartyRoleID; result = 1; } else { var sameNameNotBank = context.PartyRoles.FirstOrDefault(entity => entity.Party.Organization.OrganizationName == name && entity.EndDate == null && entity.RoleTypeId != RoleType.BankType.Id); if (sameNameNotBank != null) { hiddenID.Value = sameNameNotBank.PartyId; result = 2; } } } return result; }
public static AddressType GetTelecommunicationNumberType(FinancialEntities context) { AddressType telecommunicationNumberType = new AddressType(); telecommunicationNumberType = context.AddressTypes.SingleOrDefault(entity => entity.Name == AddressTypeEnums.TelecommunicationNumber); InitialDatabaseValueChecker.ThrowIfNull<AddressType>(telecommunicationNumberType); return telecommunicationNumberType; }
public static PostalAddressType GetPropertyLocationAddressType(FinancialEntities context) { PostalAddressType propertyLocationAddressType = new PostalAddressType(); propertyLocationAddressType = context.PostalAddressTypes.SingleOrDefault(entity => entity.Name == PostalAddressTypeEnums.PropertyLocation); InitialDatabaseValueChecker.ThrowIfNull<PostalAddressType>(propertyLocationAddressType); return propertyLocationAddressType; }
public static PostalAddressType GetHomeAddressType(FinancialEntities context) { PostalAddressType homeAddressType = new PostalAddressType(); homeAddressType = context.PostalAddressTypes.SingleOrDefault(entity => entity.Name == PostalAddressTypeEnums.HomeAddress); InitialDatabaseValueChecker.ThrowIfNull<PostalAddressType>(homeAddressType); return homeAddressType; }
public static PostalAddressType GetBirthPlaceAddressType(FinancialEntities context) { PostalAddressType birthplaceType = new PostalAddressType(); birthplaceType = context.PostalAddressTypes.SingleOrDefault(entity => entity.Name == PostalAddressTypeEnums.Birthplace); InitialDatabaseValueChecker.ThrowIfNull<PostalAddressType>(birthplaceType); return birthplaceType; }
public static RoleType GetGuarantorRoleType(FinancialEntities context) { var domainApplication = GetDomainApplicationRoleType(context); var type = context.RoleTypes.SingleOrDefault(entity => entity.Name == Guarantor && entity.ParentRoleTypeId == domainApplication.Id); InitialDatabaseValueChecker.ThrowIfNull<RoleType>(type); return type; }
public static PersonName GetPersonNameByTypeEntity(FinancialEntities context, Person person, string type) { var personNameType = context.PersonNameTypes.SingleOrDefault(entity => entity.Name == type); InitialDatabaseValueChecker.ThrowIfNull<PersonNameType>(personNameType); var personName = person.PersonNames.SingleOrDefault(entity => entity.PersonNameTypeId == personNameType.Id && entity.EndDate == null); return personName; }
public static PostalAddress GetCurrentPostalAddressV2(FinancialEntities context, Party party, PostalAddressType type, Func<PostalAddress, bool> condition) { PostalAddress postalAddress = context.PostalAddresses.SingleOrDefault(entity =>entity.Address.PartyId == party.Id && entity.Address.EndDate == null && entity.PostalAddressTypeId == type.Id && condition(entity)); //Address address = party.Addresses.SingleOrDefault(entity => entity.EndDate == null && entity.PostalAddress.PostalAddressTypeId == type.Id && condition(entity)); //if (address != null) // return address.PostalAddress; return postalAddress; }
protected void checkDistrict(object sender, RemoteValidationEventArgs e) { int count = 0; using (var context = new FinancialEntities()) { count = context.ClassificationTypes.Where(entity => entity.District == this.District.Text).Count(); } e.Success = count == 0; if (count > 0) e.ErrorMessage = "Customer classification record already exists."; }
public static PostalAddress CreatePostalAddress(FinancialEntities context, Party party, PostalAddressType type, DateTime now) { Address address = new Address(); address.Party = party; address.AddressType = AddressTypeEnums.GetPostalAddressType(context); address.EffectiveDate = now; PostalAddress postalAddress = new PostalAddress(); postalAddress.Address = address; postalAddress.PostalAddressType = type; return postalAddress; }
public static PersonName CreatePersonName(FinancialEntities context, string nameType, string name, Person person) { var personNameType = context.PersonNameTypes.SingleOrDefault(entity => entity.Name == nameType); InitialDatabaseValueChecker.ThrowIfNull<PersonNameType>(personNameType); PersonName personName = new PersonName(); personName.Name = name; personName.PersonNameType = personNameType; personName.Person = person; personName.EffectiveDate = DateTime.Now; return personName; }
public static void CreateOrUpdatePersonNames(FinancialEntities context, Person person, string type, string name, DateTime today) { PersonName personName = GetPersonNameByTypeEntity(context, person, type); if (personName == null || name != personName.Name) { if (personName != null) personName.EndDate = today; PersonName newPersonName = CreatePersonName(context, type, name, person); context.PersonNames.AddObject(newPersonName); } }
protected void btnSave_Click(object sender, DirectEventArgs e) { using (var context = new FinancialEntities()) { int id = int.Parse(this.hiddenId.Text); Holiday holiday = context.Holidays.SingleOrDefault(entity => entity.Id == id); holiday.Name = this.txtName.Text; holiday.Date = this.dtHoliday.SelectedDate; holiday.Description = this.txtDesciption.Text; holiday.Notes = this.txtNotes.Text; context.SaveChanges(); } }
protected void btnSave_Click(object sender, DirectEventArgs e) { using (var context = new FinancialEntities()) { Holiday holiday = new Holiday(); holiday.Name = this.txtName.Text; holiday.Date = this.dtHoliday.SelectedDate; holiday.Description = this.txtDesciption.Text; holiday.Notes = this.txtNotes.Text; context.Holidays.AddObject(holiday); context.SaveChanges(); } }
protected void Page_Load(object sender, EventArgs e) { if (X.IsAjaxRequest == false && this.IsPostBack == false) { using (var context = new FinancialEntities()) { txtGracePeriod.Text = GetCurrentSetting(context, SystemSettingsEnums.GracePeriod); txtInvoice.Text = GetCurrentSetting(context, SystemSettingsEnums.InvoiceGenerationTiming); txtDemand.Text = GetCurrentSetting(context, SystemSettingsEnums.DemandCollectionAfter); txtAgeLimit.Text = GetCurrentSetting(context, SystemSettingsEnums.AgeLimitOfBorrower); // txtPercentage.Text = GetCurrentSetting(context, SystemSettingsEnums.PercentageOfLoanAmountPaid); if (txtPercentage.Text.Equals("")) { rdApplyNo.Checked = true; txtPercentage.Disabled = true; } else { rdApplyYes.Checked = true; } cbCalculate.Text = GetCurrentSetting(context, SystemSettingsEnums.CalculatePenalty); // txtAllowDelWithAge.Text = GetCurrentSetting(context, SystemSettingsEnums.AllowDeleteOnLoansWithAge); if (txtAllowDelWithAge.Text.Equals("")) { rdAllowNo.Checked = true; txtAllowDelWithAge.Disabled = true; } else { rdAllowYes.Checked = true; } var paymentDateOption = GetCurrentSetting(context, SystemSettingType.DatePaymentOptionType.Name); if (paymentDateOption == "1") radioAfter.Checked = true; else if(paymentDateOption == "0") radioBefore.Checked = true; txtMaxAmountAppovableByClerk.Text = GetCurrentSetting(context, SystemSettingsEnums.ClerksMaximumHonorableAmount); txtStraightLine.Text = GetCurrentSetting(context, SystemSettingsEnums.StraightLineLoan); txtDiminishing.Text = GetCurrentSetting(context, SystemSettingsEnums.DiminishingBalanceLoan); //var advanceChangeDay = GetCurrentSetting(context, SystemSettingsEnums.AdvanceChangeNoInterestStartDay); cmbAdvanceChangeNoInterestStartDay.SelectedItem.Value = GetCurrentSetting(context, SystemSettingsEnums.AdvanceChangeNoInterestStartDay); } } }
protected void Page_Load(object sender, EventArgs e) { if (X.IsAjaxRequest == false && this.IsPostBack == false) { using (var context = new FinancialEntities()) { var loanTerm = from uom in context.UnitOfMeasures where uom.UnitOfMeasureType.Name == "Time Unit" select new { Id = uom.Id, Name = uom.Name }; var paymentMode = from uom in context.UnitOfMeasures where uom.UnitOfMeasureType.Name == "Time Frequency" select new { Id = uom.Id, Name = uom.Name }; var interestMode = from pf in context.ProductFeatures where pf.ProductFeatureCategory.Name == "Interest Computation Mode" select new { Id = pf.Id, Name = pf.Name }; var methodOfCharging = from pf in context.ProductFeatures where pf.ProductFeatureCategory.Name == "Method of Charging Interest" select new { Id = pf.Id, Name = pf.Name }; StoreLoanTerm.DataSource = loanTerm.ToList(); StorePaymentMode.DataSource = paymentMode.ToList(); StoreInterest.DataSource = interestMode.ToList(); StoreMethodOfCharging.DataSource = methodOfCharging.ToList(); StoreLoanTerm.DataBind(); StorePaymentMode.DataBind(); StoreInterest.DataBind(); StoreMethodOfCharging.DataBind(); } } }
protected void btnSave_Click(object sender, DirectEventArgs e) { using (var context = new FinancialEntities()) { ClassificationType classification = new ClassificationType(); classification.District = this.District.Text; classification.StationNumber = this.StationNumber.Text; var selectedDistrict = this.cmbDistrictType.SelectedIndex; if (selectedDistrict != -1) { classification.DistrictTypeId = int.Parse(this.cmbDistrictType.SelectedItem.Value); } context.ClassificationTypes.AddObject(classification); context.SaveChanges(); } }
protected void btnSave_Click(object sender, DirectEventArgs e) { using (var context = new FinancialEntities()) { int id = int.Parse(this.RecordID.Text); ClassificationType classification = context.ClassificationTypes.SingleOrDefault(entity => entity.Id == id); classification.District = this.District.Text; classification.StationNumber = this.StationNumber.Text; var selectedDistrict = this.cmbDistrictType.SelectedIndex; if (selectedDistrict != -1) { classification.DistrictTypeId = int.Parse(this.cmbDistrictType.SelectedItem.Value); } context.SaveChanges(); } }
public int checkOrganizationName() { int result = 0; var name = txtName.Text; using (var context = new FinancialEntities()) { var sameOrgName = context.ContactViewLists.FirstOrDefault(entity => entity.Name == name); if (sameOrgName != null) { hiddenID.Value = sameOrgName.PartyRoleId; result = 1; } } return result; }
private void OnGenerateWordDoc() { try { WordDocGenerator wordDocGenerator = new WordDocGenerator(); var finaincialList = FinancialEntities.ToList(); var totalInfo = new FinancialInfoTotal(); totalInfo.TotalText = "Total"; foreach (var financialInfo in finaincialList) { totalInfo.TotalNBOfProvServ += financialInfo.NumberOfProvServ; totalInfo.DentalPrice += financialInfo.DentalPrice; totalInfo.PriceDueToContract += financialInfo.PriceDueToContract; totalInfo.TotalPriceProvServ += financialInfo.TotalPriceProvServ; totalInfo.TotalDueToContract += financialInfo.TotalDueToContract; } wordDocGenerator.CreateTable(finaincialList, totalInfo, GenerateTableInfoViewModel.Year, GenerateTableInfoViewModel.SelectedMonth, GenerateTableInfoViewModel.Provider, GenerateTableInfoViewModel.Beneficiary); } catch (Exception) { MessageBox.Show("Pentru a genera fisierul word creati tabelul intai"); } }