public LoginResponseDetailsModel loginResponseDetailsModel(CustomerloginRequestModel customerloginRequest) { LoginResponseDetailsModel loginResponseDetailsModel = new LoginResponseDetailsModel(); CustomerRepository repository = new CustomerRepository(); loginResponseDetailsModel = repository.loginRequest(customerloginRequest); return(loginResponseDetailsModel); }
public LoginResponseDetailsModel loginRequest(CustomerloginRequestModel customerloginRequestModel) { LoginResponseDetailsModel loginResponseDetailsModel = new LoginResponseDetailsModel(); List <CustomerLoginRequestResponse> loginRequestResponses = new List <CustomerLoginRequestResponse>(); using (MySqlConnection sqlConnection = new MySqlConnection(connectstring)) { using (MySqlCommand mySqlCommand = sqlConnection.CreateCommand()) { try { mySqlCommand.CommandText = "SELECT fld_id as fld_id," + "AES_DECRYPT(fld_firstname,'P@PDoctor')as fld_firstname," + "AES_DECRYPT(fld_lastname,'P@PDoctor')as fld_lastname, " + "AES_DECRYPT(fld_phonenumber,'P@PDoctor')as fld_phonenumber," + "AES_DECRYPT(fld_firstname,'P@PDoctor')as fld_firstname, " + "AES_DECRYPT(fld_email,'P@PDoctor')as fld_email, " + "AES_DECRYPT(fld_address1,'P@PDoctor')as fld_address1, " + "AES_DECRYPT(fld_address2,'P@PDoctor')as fld_address2, " + "AES_DECRYPT(fld_suitenum,'P@PDoctor')as fld_suitenum, " + "AES_DECRYPT(fld_city,'P@PDoctor')as fld_city, " + "AES_DECRYPT(fld_country,'P@PDoctor')as fld_country, " + "AES_DECRYPT(fld_state,'P@PDoctor')as fld_state, " + "AES_DECRYPT(fld_postalcode,'P@PDoctor')as fld_postalcode, " + "AES_DECRYPT(fld_password,'P@PDoctor')as fld_password, " + "AES_DECRYPT(fld_status,'P@PDoctor')as fld_status, " + "AES_DECRYPT(fld_datetime,'P@PDoctor')as fld_datetime, " + "AES_DECRYPT(fld_profile,'P@PDoctor')as fld_profile, " + "AES_DECRYPT(fld_dob,'P@PDoctor')as fld_dob, " + "AES_DECRYPT(fld_timezone,'P@PDoctor')as fld_timezone, " + "AES_DECRYPT(fld_phn_number,'P@PDoctor')as fld_phn_number, " + "AES_DECRYPT(fld_gender,'P@PDoctor')as fld_gender FROM tbl_customer WHERE fld_email=" + "AES_ENCRYPT('" + customerloginRequestModel.customerEmail.Trim() + "'" + "," + "'" + "P@PDoctor" + "'" + ")" + " AND fld_password="******"AES_ENCRYPT('" + customerloginRequestModel.customerPassword.Trim() + "'" + "," + "'" + "P@PDoctor" + "'" + ")" + ""; mySqlCommand.CommandType = System.Data.CommandType.Text; mySqlCommand.Connection = sqlConnection; sqlConnection.Open(); using (MySqlDataReader reader = mySqlCommand.ExecuteReader()) { while (reader.Read()) { loginRequestResponses.Add(new CustomerLoginRequestResponse { customerID = (reader.GetString(reader.GetOrdinal("fld_id"))), customer_FirstName = (reader.GetString(reader.GetOrdinal("fld_firstname"))), customer_LastName = (reader.GetString(reader.GetOrdinal("fld_lastname"))), customer_Phone = (reader.GetString(reader.GetOrdinal("fld_phonenumber"))), customerEmail = (reader.GetString(reader.GetOrdinal("fld_email"))), customer_Address1 = (reader.GetString(reader.GetOrdinal("fld_address1"))), customer_Address2 = (reader.GetString(reader.GetOrdinal("fld_address2"))), customer_Suitenum = (reader.GetString(reader.GetOrdinal("fld_suitenum"))), customer_City = (reader.GetString(reader.GetOrdinal("fld_city"))), customer_Country = (reader.GetString(reader.GetOrdinal("fld_country"))), customer_State = (reader.GetString(reader.GetOrdinal("fld_state"))), customer_PostalCode = (reader.GetString(reader.GetOrdinal("fld_postalcode"))), customer_Password = (reader.GetString(reader.GetOrdinal("fld_password"))), customer_Status = (reader.GetString(reader.GetOrdinal("fld_status"))), customer_DateTime = (reader.GetString(reader.GetOrdinal("fld_datetime"))), customer_Profile = (reader.GetString(reader.GetOrdinal("fld_profile"))), customer_DOB = (reader.GetString(reader.GetOrdinal("fld_dob"))), customer_TimeZone = (reader.GetString(reader.GetOrdinal("fld_timezone"))), customer_Phnnumber = (reader.GetString(reader.GetOrdinal("fld_phn_number"))), customer_Gender = (reader.GetString(reader.GetOrdinal("fld_gender"))) }); } sqlConnection.Close(); loginResponseDetailsModel.loginRequestResponses = loginRequestResponses; } } catch (Exception e) { loginResponseDetailsModel.Message = e.ToString(); } } } if (loginRequestResponses.Count <= 0) { loginResponseDetailsModel.loginRequestResponses = loginRequestResponses; loginResponseDetailsModel.Message = "Nodata Found"; loginResponseDetailsModel.responseCode = "200"; Console.WriteLine(" SIZE ", loginRequestResponses.Count); } else { loginResponseDetailsModel.loginRequestResponses = loginRequestResponses; loginResponseDetailsModel.Message = "Customer Details"; loginResponseDetailsModel.responseCode = "200"; Console.WriteLine(" SIZE ", loginRequestResponses.Count); } return(loginResponseDetailsModel); }