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