public AgentDetails GetDetails()
{
AgentDetails agentData = new AgentDetails();
agentData.agentAddress = addressTxtbox.Text;
agentData.agentBloodGroup = bloodGroupTxtbox.Text;
agentData.agentBranchId = branchTxtbox.Text;
agentData.agentDateOfBirth = dobDatepicker.SelectedDate.Value;
agentData.joinDate = joinDatePicker.SelectedDate.Value;
agentData.agentFatherHusbandName = fatherHusbandNameTxtbox.Text;
agentData.agentIntroducerId = introducerIdTxtbox.Text;
agentData.agentName = nameTxtbox.Text;
agentData.agentNationality = nationalityTxtbox.Text;
agentData.agentNomineeDob = nomineeAgeDatepicker.SelectedDate.Value;
agentData.agentNomineeName = nomineeNameTxtbox.Text;
agentData.agentNomineeRelationship = nomineeRelationshipTxtbox.Text;
agentData.agentPhoneNumber = phoneNoTxtbox.Text;
agentData.agentPinCode = Convert.ToInt32(pincodeTxtbox.Text);
agentData.agentQualification = qualificationTxtbox.Text;
agentData.agentState = stateTxtbox.Text;
//agentData.agentTitle = titleNameCombobox.Text;
agentData.designation = designationTxtbox.Text;
agentData.rank = Convert.ToInt32(rankTxtbox.Text);
return agentData;
}
internal void SetDetails(AgentDetails agentDetails)
{
agentIdTxtbox.Text = agentDetails.agentId;
addressTxtbox.Text = agentDetails.agentAddress;
bloodGroupTxtbox.Text = agentDetails.agentBloodGroup;
branchTxtbox.Text = agentDetails.agentBranchId;
dobDatepicker.SelectedDate = agentDetails.agentDateOfBirth;
joinDatePicker.SelectedDate = agentDetails.joinDate;
fatherHusbandNameTxtbox.Text = agentDetails.agentFatherHusbandName;
introducerIdTxtbox.Text = agentDetails.agentIntroducerId;
nameTxtbox.Text = agentDetails.agentName;
nationalityTxtbox.Text = agentDetails.agentNationality ;
nomineeAgeDatepicker.SelectedDate = agentDetails.agentNomineeDob;
nomineeNameTxtbox.Text = agentDetails.agentNomineeName ;
nomineeRelationshipTxtbox.Text = agentDetails.agentNomineeRelationship;
phoneNoTxtbox.Text= agentDetails.agentPhoneNumber ;
pincodeTxtbox.Text= agentDetails.agentPinCode.ToString();
qualificationTxtbox.Text = agentDetails.agentQualification;
stateTxtbox.Text = agentDetails.agentState;
//titleNameCombobox.Text = agentDetails.agentTitle;
designationTxtbox.Text=agentDetails.designation;
rankTxtbox.Text = agentDetails.rank.ToString();
}
public static int DoRegisterNewAgent(AgentDetails agentDetails)
{
return RegisterNewAgentInDb(agentDetails);
}
private static int RegisterNewAgentInDb(AgentDetails agentDetails)
{
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 agents(agent_id,agent_join_date,agent_rank,agent_designation,agent_nationality,agent_educational_qualification,agent_nominee_name,agent_nominee_dob,agent_nominee_relationship,agent_introducer_id,agent_branch_id,agent_name,agent_father_husband_name,agent_address,agent_pin_code,agent_state,agent_phone_number,agent_blood_group,agent_dob) "
+ "VALUES(@agent_id,@agent_join_date,@agent_rank,@agent_designation,@agent_nationality,@agent_educational_qualification,@agent_nominee_name,@agent_nominee_dob,@agent_nominee_relationship,@agent_introducer_id,@agent_branch_id,@agent_name,@agent_father_husband_name,@agent_address,@agent_pin_code,@agent_state,@agent_phone_number,@agent_blood_group,@agent_dob)";
msqlCommand.Parameters.AddWithValue("@agent_id", agentDetails.agentId);
msqlCommand.Parameters.AddWithValue("@agent_join_date", agentDetails.joinDate);
msqlCommand.Parameters.AddWithValue("@agent_rank", agentDetails.rank);
msqlCommand.Parameters.AddWithValue("@agent_designation", agentDetails.designation);
msqlCommand.Parameters.AddWithValue("@agent_nationality", agentDetails.agentNationality);
msqlCommand.Parameters.AddWithValue("@agent_educational_qualification", agentDetails.agentQualification);
msqlCommand.Parameters.AddWithValue("@agent_nominee_name", agentDetails.agentNomineeName);
msqlCommand.Parameters.AddWithValue("@agent_nominee_dob", agentDetails.agentNomineeDob);
msqlCommand.Parameters.AddWithValue("@agent_nominee_relationship", agentDetails.agentNomineeRelationship);
msqlCommand.Parameters.AddWithValue("@agent_introducer_id", agentDetails.agentIntroducerId);
msqlCommand.Parameters.AddWithValue("@agent_branch_id", agentDetails.agentBranchId);
msqlCommand.Parameters.AddWithValue("@agent_name", agentDetails.agentName);
msqlCommand.Parameters.AddWithValue("@agent_father_husband_name", agentDetails.agentFatherHusbandName);
msqlCommand.Parameters.AddWithValue("@agent_address", agentDetails.agentAddress);
msqlCommand.Parameters.AddWithValue("@agent_pin_code", agentDetails.agentPinCode);
msqlCommand.Parameters.AddWithValue("@agent_state", agentDetails.agentState);
msqlCommand.Parameters.AddWithValue("@agent_phone_number", agentDetails.agentPhoneNumber);
msqlCommand.Parameters.AddWithValue("@agent_blood_group", agentDetails.agentBloodGroup);
msqlCommand.Parameters.AddWithValue("@agent_dob", agentDetails.agentDateOfBirth);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return returnVal;
}
private static List<AgentDetails> QueryAllAgentList()
{
List<AgentDetails> agentList = new List<AgentDetails>();
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 agents;";
MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
while (msqlReader.Read())
{
AgentDetails agent = new AgentDetails();
agent.agentId = msqlReader.GetString("agent_id");
agent.rank = msqlReader.GetInt32("agent_rank");
agent.designation = msqlReader.GetString("agent_designation");
agent.agentNationality = msqlReader.GetString("agent_nationality");
agent.agentQualification = msqlReader.GetString("agent_educational_qualification");
agent.agentNomineeName = msqlReader.GetString("agent_nominee_name");
agent.agentNomineeDob = msqlReader.GetDateTime("agent_nominee_dob");
agent.joinDate = msqlReader.GetDateTime("agent_join_date");
agent.agentNomineeRelationship = msqlReader.GetString("agent_nominee_relationship");
agent.agentIntroducerId = msqlReader.GetString("agent_introducer_id");
agent.agentBranchId = msqlReader.GetString("agent_branch_id");
agent.agentName = msqlReader.GetString("agent_name");
agent.agentFatherHusbandName = msqlReader.GetString("agent_father_husband_name");
agent.agentAddress = msqlReader.GetString("agent_address");
agent.agentPinCode = msqlReader.GetInt32("agent_pin_code");
agent.agentState = msqlReader.GetString("agent_state");
agent.agentPhoneNumber = msqlReader.GetString("agent_phone_number");
agent.agentBloodGroup = msqlReader.GetString("agent_blood_group");
agent.agentDateOfBirth = msqlReader.GetDateTime("agent_dob");
agentList.Add(agent);
}
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
return agentList;
}
