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