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 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(); } }
protected void btnSave_Click(object sender, DirectEventArgs e) { using (var context = new FinancialEntities()) { int uomidDays = UnitOfMeasureEnum.GetDaysType(context).Id; int uomidYears = UnitOfMeasureEnum.GetYearsType(context).Id; SystemSetting gracePeriod = SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.GracePeriod, txtGracePeriod.Text); gracePeriod.UomId = uomidDays; SystemSetting invoiceGeneration = SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.InvoiceGenerationTiming, txtInvoice.Text); invoiceGeneration.UomId = uomidDays; SystemSetting demandCollectionAfter = SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.DemandCollectionAfter, txtDemand.Text); demandCollectionAfter.UomId = uomidDays; SystemSetting ageLimitOfBorrower = SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.AgeLimitOfBorrower, txtAgeLimit.Text); ageLimitOfBorrower.UomId = uomidYears; SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.PercentageOfLoanAmountPaid, txtPercentage.Text); SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.CalculatePenalty, cbCalculate.Text); SystemSetting allowDeleteOnLoansWithAge = SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.AllowDeleteOnLoansWithAge, txtAllowDelWithAge.Text); if (allowDeleteOnLoansWithAge != null) allowDeleteOnLoansWithAge.UomId = uomidYears; SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.ClerksMaximumHonorableAmount, txtMaxAmountAppovableByClerk.Text); SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.StraightLineLoan, txtStraightLine.Text); SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.DiminishingBalanceLoan, txtDiminishing.Text); string datePaymentOptionValue = string.Empty; if (radioAfter.Checked == true) datePaymentOptionValue = "1"; else if (radioBefore.Checked == true) datePaymentOptionValue = "0"; SystemSetting.CreateOrEditSystemSetting(context, SystemSettingType.DatePaymentOptionType.Name, datePaymentOptionValue); SystemSetting.CreateOrEditSystemSetting(context, SystemSettingsEnums.AdvanceChangeNoInterestStartDay, cmbAdvanceChangeNoInterestStartDay.SelectedItem.Text); context.SaveChanges(); } }
protected void btnSave_Click(object sender, DirectEventArgs e) { using (var context = new FinancialEntities()) { RequiredDocumentType doc = new RequiredDocumentType(); TextInfo info = CultureInfo.CurrentCulture.TextInfo; //string name = info.ToTitleCase(this.Name.Text); var nameTemp = this.Name.Text; string name = ""; string[] temp = nameTemp.Split('\''); if (temp.Length > 1) { int count = 0; foreach (var n in temp) { if (count == 0) { name = name + info.ToTitleCase(n); } else { var t = info.ToTitleCase(n); name = name + "'" + info.ToLower(t[0]) + t.Substring(1); } count++; } } else { //foreach //string name = info.ToTitleCase(this.Name.Text); name = this.Name.Text; } doc.Name = name; context.RequiredDocumentTypes.AddObject(doc); context.SaveChanges(); } }
protected void btnSave_Click(object sender, DirectEventArgs e) { using (var context = new FinancialEntities()) { int id = int.Parse(this.RecordID.Text); RequiredDocumentType customer = context.RequiredDocumentTypes.SingleOrDefault(entity => entity.Id == id); TextInfo info = CultureInfo.CurrentCulture.TextInfo; var nameTemp = this.Name.Text; string name = ""; string[] temp = nameTemp.Split('\''); if (temp.Length > 1) { int count = 0; foreach (var n in temp) { if (count == 0) { name = name + info.ToTitleCase(n); } else { var t = info.ToTitleCase(n); name = name + "'" + info.ToLower(t[0]) + t.Substring(1); } count++; } } else { //foreach //string name = info.ToTitleCase(this.Name.Text); name = this.Name.Text; } customer.Name = name; context.SaveChanges(); } }
protected void btnSave_Click(object sender, DirectEventArgs e) { using (var context = new FinancialEntities()) { var today = DateTime.Now; Bank bank = new Bank(); Organization org = null; Party party = null; if (string.IsNullOrWhiteSpace(hiddenPartyId.Text) != false) { party = new Party(); org = new Organization(); org.Party = party; org.OrganizationName = txtName.Text; } else { int partyId = Convert.ToInt32(hiddenPartyId.Text); party = context.Parties.FirstOrDefault(entity => entity.Id == partyId); org = context.Organizations.FirstOrDefault(entity => entity.PartyId == partyId); org.OrganizationName = txtName.Text; hiddenPartyId.Value = ""; } BankStatu bankStatus = new BankStatu(); var bankRoleType = context.RoleTypes.SingleOrDefault(entity => entity.Name == RoleTypeEnums.Bank); var orgPartyType = context.PartyTypes.SingleOrDefault(entity => entity.Name == PartyTypeEnums.Organization); var bankStatusType = context.BankStatusTypes.SingleOrDefault(entity => entity.Name == BankStatusTypeEnum.Active); InitialDatabaseValueChecker.ThrowIfNull<RoleType>(bankRoleType); InitialDatabaseValueChecker.ThrowIfNull<PartyType>(orgPartyType); InitialDatabaseValueChecker.ThrowIfNull<BankStatusType>(bankStatusType); party.PartyType = orgPartyType; PartyRole partyRole = new PartyRole(); partyRole.Party = party; partyRole.PartyRoleType = bankRoleType.PartyRoleType; partyRole.EffectiveDate = today; bankStatus.BankStatusType = bankStatusType; bankStatus.PartyRoleId = partyRole.Id; bankStatus.EffectiveDate = today; bank.Branch = this.txtBranch.Text; if (string.IsNullOrWhiteSpace(this.txtAcronym.Text)) bank.Acronym = bank.PartyRole.Party.Organization.OrganizationName; else bank.Acronym = this.txtAcronym.Text; var addressType = context.AddressTypes.SingleOrDefault(entity => entity.Name == AddressTypeEnums.PostalAddress); Address postalAdd = AddressBusinessUtility.AddAddress(party, addressType, today); var postalAddressType = context.PostalAddressTypes.SingleOrDefault(entity => entity.Name == PostalAddressTypeEnums.BusinessAddress); InitialDatabaseValueChecker.ThrowIfNull<PostalAddressType>(postalAddressType); PostalAddress specificPostalAddress2 = AddressBusinessUtility.AddPostal(postalAdd, postalAddressType, true); int countryId = int.Parse(cmbCountry.Value.ToString()); var country = context.Countries.FirstOrDefault(entity => entity.Id == countryId); InitialDatabaseValueChecker.ThrowIfNull<Country>(country); if(string.IsNullOrWhiteSpace(hiddenStreetName.Text)==false)specificPostalAddress2.StreetAddress = hiddenStreetName.Text; specificPostalAddress2.Barangay = hiddenBarangay.Text; specificPostalAddress2.PostalCode = hiddenPostalCode.Text; specificPostalAddress2.Country = country; if (string.IsNullOrWhiteSpace(hiddenCity.Text) == false) specificPostalAddress2.City = hiddenCity.Text; if (string.IsNullOrWhiteSpace(hiddenMunicipality.Text) == false) specificPostalAddress2.Municipality = hiddenMunicipality.Text; if (string.IsNullOrWhiteSpace(hiddenProvince.Text) == false) specificPostalAddress2.Province = hiddenProvince.Text; var telAddressType = context.AddressTypes.SingleOrDefault(entity => entity.Name == AddressTypeEnums.TelecommunicationNumber); if (string.IsNullOrWhiteSpace(txtAreaCode.Text) ==false) { Address telephoneAddress = AddressBusinessUtility.AddAddress(party, telAddressType, today); var telType = context.TelecommunicationsNumberTypes.SingleOrDefault(entity => entity.Name == TelecommunicationsNumberTypeEnums.BusinessPhoneNumber); TelecommunicationsNumber specificTelephoneAddress = AddressBusinessUtility.AddTelNum(telephoneAddress, telType, true); specificTelephoneAddress.AreaCode = txtAreaCode.Text; specificTelephoneAddress.PhoneNumber = txtPhoneNum.Text; } if (string.IsNullOrWhiteSpace(txtFaxAreaCode.Text)== false) { Address faxAddress = AddressBusinessUtility.AddAddress(party, telAddressType, today); var faxType = context.TelecommunicationsNumberTypes.SingleOrDefault(entity => entity.Name == TelecommunicationsNumberTypeEnums.BusinessFaxNumber); TelecommunicationsNumber specificTelephoneAddress1 = AddressBusinessUtility.AddTelNum(faxAddress, faxType, false); specificTelephoneAddress1.AreaCode = txtFaxAreaCode.Text; specificTelephoneAddress1.PhoneNumber = txtFaxNum.Text; } if (string.IsNullOrWhiteSpace(txtEmailAdd.Text) == false) { var emailAddType = context.AddressTypes.SingleOrDefault(entity => entity.Name == AddressTypeEnums.ElectronicAddress); var emailType = context.ElectronicAddressTypes.SingleOrDefault(entity => entity.Name == ElectronicAddressTypeEnums.BusinessEmailAddress); Address email = AddressBusinessUtility.AddAddress(party, emailAddType, today); ElectronicAddress specificEmail = AddressBusinessUtility.AddEmail(email, emailType, true); specificEmail.ElectronicAddressString = txtEmailAdd.Text; } context.Banks.AddObject(bank); context.SaveChanges(); } X.Msg.Alert("Message", "Bank record successfully created").Show(); }