partial void DeletesubscribedEmail(subscribedEmail instance);
 partial void UpdatesubscribedEmail(subscribedEmail instance);
        public ActionResult test()
        {
            string path = Server.MapPath("~/pdf/file2.csv");
            StreamReader sr = new StreamReader(path);
            // for set encoding
            // StreamReader sr = new StreamReader(@"file.csv", Encoding.GetEncoding(1250));

            string strline = "";
            string[] _values = null;
            int x = 0;

            while (!sr.EndOfStream)
            {
                x++;
                strline = sr.ReadLine();
                _values = strline.Split(',');

                for (int i = 0; i < _values.Length; i++)
                {
                    if (_values[i].Trim().Length > 0)
                    {
                        subscribedEmail se = new subscribedEmail();
                        se.createdDate = DateTime.Now;
                        se.email = _values[i];
                        //se.name = subEmail.name;
                        //se.mobileNo = subEmail.phoneNumber;

                        db2.subscribedEmails.InsertOnSubmit(se);
                        db2.SubmitChanges();
                    }
                }
                //if (_values[0].Trim().Length > 0)
                //{
                //    //MessageBox.show(_values[1]);
                //}
            }
            sr.Close();
            return View();
        }
 partial void InsertsubscribedEmail(subscribedEmail instance);
        public ActionResult Subscribed(SubscribedModel subEmail)
        {
            if (ModelState.IsValid)
            {
                subscribedEmail se = new subscribedEmail();
                se.createdDate = DateTime.Now;
                se.email = subEmail.email;
                se.name = subEmail.name;
                se.mobileNo = subEmail.phoneNumber;

                db2.subscribedEmails.InsertOnSubmit(se);
                db2.SubmitChanges();
                return RedirectToAction("thankyou");
            }
            else
            {
                return View();
            }
        }