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());
}
