public void UpdateMarriedStatus(MarriedStatusModel model)
{
using (IDbConnection connection = new NpgsqlConnection(GlobalConfig.getDatabaseConnectionString()))
{
connection.ExecuteScalar($"update maritalstatus set maritalstatus_id = '{model.maritalstatus_id}', maritalstatus_name = '{model.maritalstatus_name}'");
}
}
public MarriedStatusModel CreateMarriedStatusModel(MarriedStatusModel model)
{
using (IDbConnection connection = new NpgsqlConnection(GlobalConfig.getDatabaseConnectionString()))
{
int id = connection.ExecuteScalar <int>($"insert into maritalstatus values(default,'{model.maritalstatus_id}','{model.maritalstatus_name}'");
return(model);
}
}
private void WireUpForm()
{
//First, Middle and Last Name
model.applicantModel.applicant_firstname = FirstNameTextBox.Text;
if (MiddleNameTextBox.Text.Length != 0)
{
model.applicantModel.applicant_middlename = MiddleNameTextBox.Text;
}
else
{
model.applicantModel.applicant_middlename = "";
}
model.applicantModel.applicant_lastname = LastNameTextBox.Text;
//Get Aquaintance
AcquaintanceModel temp = (AcquaintanceModel)AcquaintanceComboBox.SelectedItem;
model.applicantModel.applicant_acquaintanceid = temp.acquaintance_id;
model.applicantModel.applicant_acquaintancename = AcquaintanceNameTextBox.Text;
/*
* DOB - DatePicker
* Age - AgeTextBlock
* Marital Status - MaritalStatusComboBox
* Caste - CasteComboBox
* Category - CategoryComboBox
* State - StateComboBox
* District - DistrictComboBox
* Pincode - PincodeTextBox
* Address - AddressTextBlock
* Mobile Number - MobileNumberTextBox
* Office Number - OfficeNumberTextBox
* Designation - DesignationTextBox
* Education - EducationComboBox
* Employer Name - EmployerNameTextBox
* Office Address - OfficeAddressTextBlock
* Distance To NE - DistanceToNeTextBox
* Nearest Branch - NearestBranchComboBox
*/
model.applicantModel.applicant_dob = DatePicker.SelectedDate.ToString().Split(' ').First();
//Marital Status
MarriedStatusModel marriedStatusModel = (MarriedStatusModel)MaritalStatusComboBox.SelectedItem;
model.applicantModel.applicant_maritalstatusid = marriedStatusModel.maritalstatus_id;
//Caste
CasteModel casteModel = (CasteModel)CasteComboBox.SelectedItem;
model.applicantModel.applicant_casteid = casteModel.caste_id;
//Category
CategoryModel category = (CategoryModel)CategoryComboBox.SelectedItem;
model.applicantModel.applicant_categoryid = category.category_id;
//State
model.applicantModel.applicant_state = (string)StateComboBox.SelectedItem;
//District
model.applicantModel.applicant_district = (string)DistrictComboBox.SelectedItem;
//Pincode
model.applicantModel.applicant_pincode = PincodeTextBox.Text;
//Address
model.applicantModel.applicant_currentaddress = AddressTextBlock.Text;
//Mobile Number
model.applicantModel.applicant_mobile = MobileNumberTextBox.Text;
//Office Number
model.applicantModel.applicant_officeno = OfficeNumberTextBox.Text;
//Designation
model.applicantModel.applicant_desgination = DesignationTextBox.Text;
//Education
model.applicantModel.applicant_education = (string)EducationComboBox.SelectedItem;
//Employer Name
model.applicantModel.applicant_employername = EmployerNameTextBox.Text;
//Office Address
model.applicantModel.applicant_officeaddress = OfficeAddressTextBlock.Text;
//Distance to NE
model.applicantModel.applicant_distance = int.Parse(DistanceToNeTextBox.Text);
//Nearest Branch
model.applicantModel.applicant_nearestbranch = (string)NearestBranchComboBox.SelectedItem;
}
