public static List<tbheader> Getheader() { using (var context = new ivyEntities()) { return context.tbheaders.ToList(); } }
public static List<tbl_Menu> GetMenus1() { using (var context = new ivyEntities()) { return context.tbl_Menu.Where(p => p.Section == 2 && p.Status == 1).OrderBy(p => p.priority).ToList(); } }
public static List<tbl_Content> GetContent() { using (var context = new ivyEntities()) { return context.tbl_Content.ToList(); } }
public ActionResult CARDIACPACKAGE(string date, string name, string email, string phone, string message, int HospitalId) { if (email == null && name == null && message == null) { return View(); } else { using (ivyEntities db = new ivyEntities()) { tbl_Package _Tbl_Contact = new tbl_Package(); _Tbl_Contact.Name = name; _Tbl_Contact.Email = email; _Tbl_Contact.Phone = phone; _Tbl_Contact.Message = message; _Tbl_Contact.Message = date; _Tbl_Contact.HospitalId = HospitalId; db.tbl_Package.Add(_Tbl_Contact); db.SaveChanges(); string em = email; MailMessage mail1 = new MailMessage(); mail1.To.Add(em); mail1.From = new MailAddress("*****@*****.**"); mail1.Subject = "Rvtechnologies"; string s1 = "<b>Hello Sir/Mam </b><br/>"; s1 += "<b>We will Contact Soon </b><br/>"; s1 += "<br/>"; s1 += "<b>Thanks for Visiting our Website </b><br/>"; s1 += "<b> Best Regards,</b><br/>"; s1 += "<b>Mr. Ranjit Singh (Director) (+91-172-4416590, +91-8284869881)</b><br/>"; s1 += "<b>M/S RV Technologies Softwares Pvt Ltd,</b><br/>"; s1 += "<b>Quiet Office 7, 2nd Floor, 40 B, Chandigarh. </b><br/>"; s1 += "<b>Web:- http://rvtechnologies.co.in/ </b><br/>"; s1 += "<b>HR Email :[email protected]</b><br/>"; s1 += "<b>Official Email :[email protected]</b><br/>"; s1 += "<b>http://www.facebook.com/RVTechnologies</b><br/>"; s1 += "<b>http://twitter.com/rvtechnologies</b><br/>"; s1 += "<b>http://in.linkedin.com/pub/rv-technologies-softwares-pvt-ltd/5a/851/ba7</b><br/>"; mail1.Body = s1; mail1.IsBodyHtml = true; SmtpClient smtp1 = new SmtpClient(); smtp1.Host = "smtp.gmail.com"; smtp1.Credentials = new System.Net.NetworkCredential ("*****@*****.**", "aspdev@rv#40"); smtp1.EnableSsl = true; smtp1.Send(mail1); MailMessage mail = new MailMessage(); mail.To.Add("*****@*****.**"); mail.From = new MailAddress("*****@*****.**"); mail.Subject = "Rvtechnologies"; string s = "<b>Hi Admin...</b><br/>"; s += "<b>Greetings!!</b><br/>"; s += "<br/>"; s += "<br/>"; s += "<b>Name : </b>" + name + "<br/>"; s += "<br/>"; s += "<b>Email Address : </b>" + email + "<br/>"; s += "<b>Message : </b>" + message + "<br/>"; s += "<br/>"; s += "Thanking you for your consideration and forthcoming response.<br/>"; s += "<br/>"; s += "<b> Best Regards,</b><br/>"; s += "<b>Mr. Ranjit Singh (Director) (+91-172-4416590, +91-8284869881)</b><br/>"; s += "<b>M/S RV Technologies Softwares Pvt Ltd,</b><br/>"; s += "<b>Quiet Office 7, 2nd Floor, 40 B, Chandigarh. </b><br/>"; s += "<b>Web:- http://rvtechnologies.co.in/ </b><br/>"; s += "<b>HR Email :[email protected]</b><br/>"; s += "<b>Official Email :[email protected]</b><br/>"; s += "<b>http://www.facebook.com/RVTechnologies</b><br/>"; s += "<b>http://twitter.com/rvtechnologies</b><br/>"; s += "<b>http://in.linkedin.com/pub/rv-technologies-softwares-pvt-ltd/5a/851/ba7</b><br/>"; mail.Body = s; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.Credentials = new System.Net.NetworkCredential ("*****@*****.**", "aspdev@rv#40"); smtp.EnableSsl = true; smtp.Send(mail); ViewBag.Message = "Message Sent"; //second mail } return RedirectToAction("CARDIACPACKAGE", "Front"); } }