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