public IHttpActionResult GetAllContacts(contactus contact) { try { //checking model propety if (ModelState.IsValid) { using (var ctx = new MayowaaEntities()) { ctx.messages.Add(new message { userName = contact.userName, emailAddress = contact.emailAddress, phoneNumber = contact.phoneNumber, message1 = contact.message }); ctx.SaveChanges(); } return(Ok(HttpStatusCode.Created)); } else { return(BadRequest(ModelState)); } } catch (Exception ex) { throw ex.InnerException; } }
public async Task <bool> AddRecord(contactus submission) { dbContext.contactus.Add(submission); var success = await dbContext.SaveChangesAsync(); return(success > 0 ? true : false); }
public async Task <IActionResult> Create(int userid, string sendername, string senderemail, string mailsubject, string mailmessage) { contactus contactus = new contactus(); if (ModelState.IsValid) { var currentUser = await _context.users.FirstOrDefaultAsync(m => m.id == userid); if (currentUser == null) { return(NotFound()); } else { contactus.fkuser = currentUser; contactus.sendername = sendername; contactus.senderemail = senderemail; contactus.mailsubject = mailsubject; contactus.mailmessage = mailmessage; _context.Add(contactus); await _context.SaveChangesAsync(); return(Redirect("http://149.202.210.119:8080/")); } } return(Redirect("http://149.202.210.119:8080/")); }
public async Task <IActionResult> Create([Bind("id,fkuser,sendername,senderemail,mailsubject,mailmessage")] contactus contactus, string sendername, string senderemail, string mailsubject, string mailmessage) { if (ModelState.IsValid) { var userid = HttpContext.Session.GetInt32("userid"); var currentUser = await _context.users.FirstOrDefaultAsync(m => m.id == userid); if (currentUser == null) { contactus.fkuser = null; } else { contactus.fkuser = currentUser; contactus.sendername = sendername; contactus.senderemail = senderemail; contactus.mailsubject = mailsubject; contactus.mailmessage = mailmessage; _context.Add(contactus); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } return(RedirectToAction("Index", "Home")); }
public object Getcontactus(contactus objcontactus) { try { SqlConnection con = new SqlConnection("Data Source=DESKTOP-SS8I9A6;Initial Catalog=happy;Integrated Security=True"); //string strcon = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); //SqlConnection con = new SqlConnection(strcon); SqlCommand cmd = new SqlCommand("spGETcontactus", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); con.Open(); da.Fill(dt); if (dt != null && dt.Rows.Count > 0) { return(dt); } else { return("Fail"); } } catch (Exception Ex) { return(new Response { Status = "Error", Message = "Invalid Data." }); } }
public ActionResult Contact(contactus contact) { MailMessage mail = new MailMessage(); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(contact.EmailId); mail.Subject = contact.subject; mail.IsBodyHtml = true; string content = "Hello, <br>" + contact.Comments + " <br><br>"; content += "Regards, <br>" + contact.Name; mail.Body = content; SmtpClient smtp = new SmtpClient("smtp.gmail.com"); NetworkCredential nc = new NetworkCredential("*****@*****.**", "nishu450"); smtp.UseDefaultCredentials = false; smtp.Credentials = nc; smtp.Port = 587; smtp.EnableSsl = true; smtp.Send(mail); ViewBag.Message = "Mail Sent"; return(View()); }
public async Task <IHttpActionResult> AddRecord([FromBody] contactus submission) { //EF6 can't identify whether db has default values set, so it will instead insert null to these columns. //I want the deafult values to be set thus assigning them in code. submission.Date = DateTime.Now; submission.IsAdminRead = false; submission.IsActive = true; return(Ok(await contactUsRepo.AddRecord(submission))); }
public ActionResult ContactUs(contactus c) { if (ModelState.IsValid) { db.contactus.Add(c); db.SaveChanges(); ModelState.Clear(); Session["count"] = count += 1; return(Json("Message send successfully")); } else { return(Json(" All Field Must Fill")); } }
public ActionResult REPLAY(adminreplay ar, contactus c) { ar.sender = "ADMIN"; db.Entry(c).State = System.Data.Entity.EntityState.Modified; c.replay = string.Empty; db.SaveChanges(); ar.sender = "ADMIN"; ar.accountno = c.PHONE; db.adminreplay.Add(ar); if (db.SaveChanges() > 0) { Session["replay"] = "REPLAY DELIEVERED"; ModelState.Clear(); } return(View()); }
public object contactus(contactus objContactUs) { try { SqlConnection con = new SqlConnection("Data Source=DESKTOP-SS8I9A6;Initial Catalog=happy;Integrated Security=True"); //string strcon = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); //SqlConnection con = new SqlConnection(strcon); SqlCommand cmd = new SqlCommand("spcontact", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@FullName", objContactUs.FullName); cmd.Parameters.AddWithValue("@Email", objContactUs.Email); cmd.Parameters.AddWithValue("@PhoneNumber", objContactUs.PhoneNumber); cmd.Parameters.AddWithValue("@Message", objContactUs.Message); //cmd.Parameters.AddWithValue("@ContactusID", objContactUs.ContactusID); con.Open(); int k = cmd.ExecuteNonQuery(); if (k != 0) { return("sucess"); } else { return("Fail"); } } catch (Exception Ex) { return(new Response { Status = "Error", Message = "Invalid Data." }); } }
public ActionResult contactus(contactus obj) { ViewBag.active = "contactus"; if (obj.captcha == HttpContext.Session["captchacontact"].ToString()) { try { //Insert record in DB Start var listedit = new List <SqlParameter>(); listedit.Add(new SqlParameter("@Name", obj.name)); listedit.Add(new SqlParameter("@Email", obj.email)); listedit.Add(new SqlParameter("@Mobile", obj.mobile)); listedit.Add(new SqlParameter("@Message", obj.message)); if (!String.IsNullOrEmpty("obj.enquiryforTour")) { listedit.Add(new SqlParameter("@EnquiryFor", obj.enquiryforTour)); } listedit.Add(new SqlParameter("@state", "contactus")); int status = DataLayer.executenonquery("SPEnquiry", listedit.ToArray()); if (status == 1) { ViewBag.Success = "Your enquiry has been sent,We will come back to you soon."; } //Insert record in DB End //Email send message using goDAddy Start //Create the msg object to be sent MailMessage msg = new MailMessage(); //Add your email address to the recipients msg.To.Add("*****@*****.**"); //Configure the address we are sending the mail from MailAddress address = new MailAddress("*****@*****.**"); msg.From = address; msg.Subject = "Enquiry"; msg.Body = "Name : " + obj.name + "<br/>" + "Email : " + obj.email + "<br/>" + "Mobile : " + obj.mobile + "<br/>" + "Subject : " + "Enquiry" + "<br/>" + "Enquiry For : " + obj.enquiryforTour + "<br/>" + "Message : " + obj.message + "<br/>"; SmtpClient client = new SmtpClient(); client.DeliveryMethod = SmtpDeliveryMethod.Network; client.EnableSsl = false; client.Host = "relay-hosting.secureserver.net"; client.Port = 25; NetworkCredential credentials = new NetworkCredential("*****@*****.**", "starindia123"); client.UseDefaultCredentials = true; client.Credentials = credentials; client.Send(msg); ViewBag.Success = "Your enquiry has been sent,We will come back to you soon."; //ModelState.Clear(); //Email send message using goDAddy End } catch (Exception ex) { MailSend("Exception Mail:" + ex.Message + ex.StackTrace + ex.InnerException); } ModelState.Clear(); } else { if (!String.IsNullOrEmpty(obj.enquiryforTour)) { ViewBag.tourDetails = obj.enquiryforTour; } ViewBag.Error = "Captcha code is wrong,try again."; } return(View()); }