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();
}