//save records to csv file
        //(membershipHelper memerinfo if you use obkect
        public bool SaveRecordstoCsvFile(MemberShipHelper memberShipHelper)
        {
            string currentYear = DateTime.Now.Year.ToString();
            string currentDate = DateTime.Now.ToString("yyyy-MM-dd");
            var    filePath    = Path.Combine(Environment.CurrentDirectory, "./wwwroot/MembershipRecords/") + "MembershipRecord" + currentYear + ".csv";
            string csvContent  = string.Format("{0},{1},{2},{3},{4},{5},{6},{7}", Name, Email, Phone, Address, Message, currentDate, MembershipType, PaymentMethod);

            if (File.Exists(filePath))
            {
                StringBuilder sb = new StringBuilder();
                sb.AppendLine(csvContent);
                File.AppendAllText(filePath, sb.ToString());
                sb.Clear();
            }
            else
            {
                File.Create(filePath).Dispose();
                StringBuilder sb = new StringBuilder();
                sb.AppendLine("Name,EmailAddress,Phone,Address,Message,RecordDate,MembershipType,PaymentMethod");
                sb.AppendLine(csvContent);
                File.AppendAllText(filePath, sb.ToString());
                sb.Clear();
            }
            return(true);
        }
        //send email to -- ask club member who handles this scretary or presend
        //save port details in webconfig
        public void SendEmail(MemberShipHelper memberShipHelper)
        {
            string fromaddress    = config.GetValue <string>("EmailConfig:FromEmail").ToString();        //mail server ypou are using
            string toaddress      = config.GetValue <string>("EmailConfig:ToEmail").ToString();          //president /screatary //you can separate it by colon
            string smtpmailserver = config.GetValue <string>("EmailConfig:SMTPServerName");              //for outlook smtp-mail.outlook.com//check how to find email smtp server //google it or check the email header
            int    portnumber     = Convert.ToInt32(config.GetValue <string>("EmailConfig:PortNumber")); //587 is for outlook/microsoft, search for our mail server
            string password       = config.GetValue <string>("EmailConfig:FromEmailPassword");
            string currentDate    = DateTime.Now.ToString("yyyy-MM-dd hh:mm tt");

            using (MailMessage mail = new MailMessage())
            {
                mail.From = new MailAddress(fromaddress);
                mail.To.Add(toaddress);
                mail.Subject    = "Membership Request";
                mail.Body       = $"Following membership request has been submitted. \n\nName: {Name} \nEmail: {Email} \nPhones: {Phone} \n Address: {Address} \nMessage: {Message} \nMembership Type: {MembershipType} \nRequest Submitted On: {currentDate} \nPayment Method: {PaymentMethod}"; //use the info from the ajax req parameter above
                mail.IsBodyHtml = false;

                using (SmtpClient client = new SmtpClient(smtpmailserver, portnumber))
                {
                    client.Credentials = new NetworkCredential(fromaddress, password);
                    client.EnableSsl   = true;
                    client.Send(mail);
                }
            }
        }
        public void EmailandSaveRecords(MemberShipHelper membership)
        {
            membershiphelper.Name  = membership.Name.Replace(",", " ");
            membershiphelper.Email = membership.Email.Replace(",", " ");
            membershiphelper.Phone = membership.Phone.Replace(",", " ");
            if (membership.Address != null)
            {
                membershiphelper.Address = membership.Address.Replace(",", " - ");
            }
            if (membership.Message != null)
            {
                membershiphelper.Message = membership.Message.Replace(",", " - ");
            }
            membershiphelper.MembershipType = membership.MembershipType;
            membershiphelper.PaymentMethod  = membership.PaymentMethod;


            var isrecordsaved = membershiphelper.SaveRecordstoCsvFile(membershiphelper);

            if (isrecordsaved)
            {
                membershiphelper.SendEmail(membershiphelper);
                membershiphelper.SendEmailToMember(membershiphelper);
            }
        }