public void SetDetails(ClientDetails clientData) { nameTxtbox.Text = clientData.clientName; joinDatePicker.SelectedDate = clientData.joinDate; clientDobDatepicker.SelectedDate = clientData.clientDateOfBirth; clientIdTxtbox.Text = clientData.clientId; jointApplicantNameTxtbox.Text = clientData.clientJointApplicantName; jointApplicantDobDatepicker.SelectedDate = clientData.clientJointApplicantDateOfBirth; clientGuardianFatherNameTxtbox.Text = clientData.clientGuardianFatherName; clientAddressTxtbox.Text = clientData.clientAddress; clientPinCodeTxtbox.Text = clientData.clientPinCode.ToString(); clientPhoneNumberTxtbox.Text = clientData.clientPhoneNumber; clientOccupationTxtbox.Text = clientData.clientOccupation; clientNomineeNameTxtbox.Text=clientData.clientNomineeName; clientNomineeDateOfBirthDatepicker.SelectedDate = clientData.clientNomineeDateOfBirth; clientNomineeRelationshipTxtbox.Text = clientData.clientNomineeRelationship; clientPlanTxtbox.Text = clientData.clientPlan; clientProposedValueTxtbox.Text = clientData.clientProposedValue.ToString(); clientPeriodMonthTxtbox.Text=clientData.clientPeriodMonth.ToString(); clientPaymentModeCombobox.Text = clientData.clientPaymentMode; clientPaymentAmountInstalmentTxtbox.Text = clientData.clientPaymentAmountInstallment.ToString(); clientPaymentAmountServiceChargeTxtbox.Text = clientData.clientPaymentAmountServiceCharge.ToString(); clientPaymentAmountTotalTxtbox.Text = clientData.clientPaymentAmountTotal.ToString(); clientPaymentReceiptNumberTxtbox.Text = clientData.clientPaymentReciptNumber; clientIntroducerIdTxtbox.Text = clientData.clientIntroducerId; }
public ClientDetails GetDetails() { ClientDetails clientData = new ClientDetails(); clientData.clientName = nameTxtbox.Text; clientData.joinDate = joinDatePicker.SelectedDate.Value; clientData.clientDateOfBirth = clientDobDatepicker.SelectedDate.Value; //clientData.clientId = clientIdTxtbox.Text; clientData.clientJointApplicantName = jointApplicantNameTxtbox.Text; clientData.clientJointApplicantDateOfBirth = jointApplicantDobDatepicker.SelectedDate.Value; clientData.clientGuardianFatherName = clientGuardianFatherNameTxtbox.Text; clientData.clientAddress = clientAddressTxtbox.Text; clientData.clientPinCode = Convert.ToInt32(clientPinCodeTxtbox.Text); clientData.clientPhoneNumber = clientPhoneNumberTxtbox.Text; clientData.clientOccupation = clientOccupationTxtbox.Text; clientData.clientNomineeName = clientNomineeNameTxtbox.Text; clientData.clientNomineeDateOfBirth = clientNomineeDateOfBirthDatepicker.SelectedDate.Value; clientData.clientNomineeRelationship = clientNomineeRelationshipTxtbox.Text; clientData.clientPlan = clientPlanTxtbox.Text; clientData.clientProposedValue = Convert.ToDouble(clientProposedValueTxtbox.Text); clientData.clientPeriodMonth = Convert.ToInt32(clientPeriodMonthTxtbox.Text); clientData.clientPaymentMode = clientPaymentModeCombobox.Text; clientData.clientPaymentAmountInstallment = Convert.ToDouble(clientPaymentAmountInstalmentTxtbox.Text); clientData.clientPaymentAmountServiceCharge = Convert.ToDouble (clientPaymentAmountServiceChargeTxtbox.Text); clientData.clientPaymentAmountTotal = Convert.ToDouble(clientPaymentAmountTotalTxtbox.Text); clientData.clientPaymentReciptNumber = clientPaymentReceiptNumberTxtbox.Text; clientData.clientIntroducerId = clientIntroducerIdTxtbox.Text; return clientData; }
public static int DoRegisterNewClient(ClientDetails clientDetails) { return RegisterNewClientInDb(clientDetails); }
private static int RegisterNewClientInDb(ClientDetails clientDetails) { int returnVal = 0; MySql.Data.MySqlClient.MySqlConnection msqlConnection = null; msqlConnection = new MySql.Data.MySqlClient.MySqlConnection("server=localhost;user id=root;Password=technicise;database=Mmm_mb;persist security info=False"); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); //define the connection used by the command object msqlCommand.Connection = msqlConnection; //open the connection if (msqlConnection.State != System.Data.ConnectionState.Open) msqlConnection.Open(); msqlCommand.CommandText = "INSERT INTO clients(client_id,client_name,client_dob,client_joint_applicant_name,client_joint_applicant_dob,client_gurdain_father_husband_name,client_address,client_pin_code,client_phone_number,client_occupation,client_nominee_name,client_nominee_dob,client_nominee_relationship,client_plan,client_proposed_value,client_period_month,client_payment_mode,client_payment_amount_instalment,client_payment_amount_service_charge,client_payment_amount_total,client_payment_receipt_number,client_introducer_id,client_join_date) " + "VALUES(@client_id,@client_name,@client_dob,@client_joint_applicant_name,@client_joint_applicant_dob,@client_gurdain_father_husband_name,@client_address,@client_pin_code,@client_phone_number,@client_occupation,@client_nominee_name,@client_nominee_dob,@client_nominee_relationship,@client_plan,@client_proposed_value,@client_period_month,@client_payment_mode,@client_payment_amount_instalment,@client_payment_amount_service_charge,@client_payment_amount_total,@client_payment_receipt_number,@client_introducer_id,@client_join_date)"; msqlCommand.Parameters.AddWithValue("@client_id", clientDetails.clientId); msqlCommand.Parameters.AddWithValue("@client_name", clientDetails.clientName); msqlCommand.Parameters.AddWithValue("@client_dob", clientDetails.clientDateOfBirth); msqlCommand.Parameters.AddWithValue("@client_joint_applicant_name", clientDetails.clientJointApplicantName); msqlCommand.Parameters.AddWithValue("@client_joint_applicant_dob", clientDetails.clientJointApplicantDateOfBirth); msqlCommand.Parameters.AddWithValue("@client_gurdain_father_husband_name", clientDetails.clientGuardianFatherName); msqlCommand.Parameters.AddWithValue("@client_address", clientDetails.clientAddress); msqlCommand.Parameters.AddWithValue("@client_pin_code", clientDetails.clientPinCode); msqlCommand.Parameters.AddWithValue("@client_phone_number", clientDetails.clientPhoneNumber); msqlCommand.Parameters.AddWithValue("@client_occupation", clientDetails.clientOccupation); msqlCommand.Parameters.AddWithValue("@client_nominee_name", clientDetails.clientNomineeName); msqlCommand.Parameters.AddWithValue("@client_nominee_dob", clientDetails.clientNomineeDateOfBirth); msqlCommand.Parameters.AddWithValue("@client_nominee_relationship", clientDetails.clientNomineeRelationship); msqlCommand.Parameters.AddWithValue("@client_plan", clientDetails.clientPlan); msqlCommand.Parameters.AddWithValue("@client_proposed_value", clientDetails.clientProposedValue); msqlCommand.Parameters.AddWithValue("@client_period_month", clientDetails.clientPeriodMonth); msqlCommand.Parameters.AddWithValue("@client_payment_mode", clientDetails.clientPaymentMode); msqlCommand.Parameters.AddWithValue("@client_payment_amount_instalment", clientDetails.clientPaymentAmountInstallment); msqlCommand.Parameters.AddWithValue("@client_payment_amount_service_charge", clientDetails.clientPaymentAmountServiceCharge); msqlCommand.Parameters.AddWithValue("@client_payment_amount_total", clientDetails.clientPaymentAmountTotal); msqlCommand.Parameters.AddWithValue("@client_payment_receipt_number", clientDetails.clientPaymentReciptNumber); msqlCommand.Parameters.AddWithValue("@client_introducer_id", clientDetails.clientIntroducerId); msqlCommand.Parameters.AddWithValue("@client_join_date", clientDetails.joinDate); msqlCommand.ExecuteNonQuery(); returnVal = 1; } catch (Exception er) { returnVal = 0; } finally { //always close the connection msqlConnection.Close(); } return returnVal; }
private static List<ClientDetails> QueryAllClientList() { List<ClientDetails> clientList = new List<ClientDetails>(); MySql.Data.MySqlClient.MySqlConnection msqlConnection = null; msqlConnection = new MySql.Data.MySqlClient.MySqlConnection("server=localhost;user id=root;Password=technicise;database=Mmm_mb;persist security info=False"); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); msqlCommand.Connection = msqlConnection; msqlConnection.Open(); msqlCommand.CommandText = "Select * From clients;"; MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader(); while (msqlReader.Read()) { ClientDetails client = new ClientDetails(); client.clientId = msqlReader.GetString("client_id"); client.clientName = msqlReader.GetString("client_name"); client.clientDateOfBirth = msqlReader.GetDateTime("client_dob"); client.clientJointApplicantName = msqlReader.GetString("client_joint_applicant_name"); client.clientJointApplicantDateOfBirth = msqlReader.GetDateTime("client_joint_applicant_dob"); client.clientGuardianFatherName = msqlReader.GetString("client_gurdain_father_husband_name"); client.clientAddress = msqlReader.GetString("client_address"); client.clientPinCode = msqlReader.GetInt32("client_pin_code"); client.clientPhoneNumber = msqlReader.GetString("client_phone_number"); client.clientOccupation = msqlReader.GetString("client_occupation"); client.clientNomineeName = msqlReader.GetString("client_nominee_name"); client.clientNomineeDateOfBirth = msqlReader.GetDateTime("client_nominee_dob"); client.clientNomineeRelationship = msqlReader.GetString("client_nominee_relationship"); client.clientPlan = msqlReader.GetString("client_plan"); client.clientPeriodMonth = msqlReader.GetInt32("client_period_month"); client.clientPaymentMode = msqlReader.GetString("client_payment_mode"); client.clientPaymentAmountInstallment = msqlReader.GetDouble("client_payment_amount_instalment"); client.clientPaymentAmountServiceCharge = msqlReader.GetDouble("client_payment_amount_service_charge"); client.clientPaymentAmountTotal = msqlReader.GetDouble("client_payment_amount_total"); client.clientPaymentReciptNumber = msqlReader.GetString("client_payment_receipt_number"); client.clientIntroducerId = msqlReader.GetString("client_introducer_id"); client.joinDate = msqlReader.GetDateTime("client_join_date"); clientList.Add(client); } } catch (Exception er) { } finally { //always close the connection msqlConnection.Close(); } return clientList; }