public async Task <ActionResult> Save(QueryModel data) { try { if (ModelState.IsValid) { //if (this.IsCaptchaValid("Captcha is not valid")) //{ CLayer.Query query = new CLayer.Query() { Name = data.Name, Email = data.Email, Phone = data.Phone, Subject = data.Subject, Body = data.Body, MessageType = (CLayer.ObjectStatus.MsgType)data.MsgType }; BLayer.Query.Save(query); string querymail = BLayer.Settings.GetValue(CLayer.Settings.QUERY_MAILID); System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage(); //string BccEmailsforsupp = BLayer.Settings.GetValue(CLayer.Settings.CUSTOMERQUERYCCMAILS); //if (BccEmailsforsupp.Trim() != "") //{ // string[] emails = BccEmailsforsupp.Split(','); // for (int i = 0; i < emails.Length; ++i) // { // msg.Bcc.Add(emails[i]); // } //} msg.To.Add(querymail); msg.ReplyToList.Add(data.Email); // msg.From = new System.Net.Mail.MailAddress(querymail); msg.Body = data.Body; msg.Subject = data.Subject; Common.Mailer ml = new Common.Mailer(); await ml.SendMailAsync(msg, Common.Mailer.MailType.Query); return(RedirectToAction("Posted")); } else { ViewBag.Message = "Error: captcha is not valid."; return(View("Index", data)); } } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/Admin/ErrorPage")); } }
public int Save(CLayer.Query query) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, query.Name)); param.Add(Connection.GetParameter("pEmail", DataPlug.DataType._Varchar, query.Email)); param.Add(Connection.GetParameter("pPhone", DataPlug.DataType._Varchar, query.Phone)); param.Add(Connection.GetParameter("pSubject", DataPlug.DataType._Varchar, query.Subject)); param.Add(Connection.GetParameter("pBody", DataPlug.DataType._Varchar, query.Body)); param.Add(Connection.GetParameter("pType", DataPlug.DataType._Int, (int)query.MessageType)); object result = Connection.ExecuteQueryScalar("query_Save", param); return(Connection.ToInteger(result)); }
public ActionResult Delete(int id) { try { CLayer.Query q = BLayer.Query.Get(id); BLayer.Query.Delete(id); if (q.Status == (int)QueryModel.status.Archived) { return(RedirectToAction("Archivebox")); } else { return(RedirectToAction("Inbox")); } } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/Admin/ErrorPage")); } }
public CLayer.Query Get(int QueryId) { CLayer.Query query = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pQueryId", DataPlug.DataType._BigInt, QueryId)); DataTable dt = Connection.GetTable("query_Get", param); if (dt.Rows.Count > 0) { query = new CLayer.Query(); query.QueryId = Connection.ToLong(dt.Rows[0]["QueryId"]); query.Name = Connection.ToString(dt.Rows[0]["Name"]); query.Email = Connection.ToString(dt.Rows[0]["Email"]); query.Phone = Connection.ToString(dt.Rows[0]["Phone"]); query.Subject = Connection.ToString(dt.Rows[0]["Subject"]); query.Body = Connection.ToString(dt.Rows[0]["Body"]); query.Status = Connection.ToInteger(dt.Rows[0]["Status"]); query.CreatedOn = Connection.ToDate(dt.Rows[0]["CreatedOn"]); } return(query); }
public static int Save(CLayer.Query querydata) { DataLayer.Query query = new DataLayer.Query(); querydata.Validate(); return(query.Save(querydata)); }
public ActionResult Edit(int id, int mgid) { try { if (Convert.ToBoolean(mgid)) { switch (mgid) { case (int)CLayer.ObjectStatus.MsgType.Query: ViewBag.Head = "Query"; ViewBag.MsgType = mgid; break; case (int)CLayer.ObjectStatus.MsgType.Complaint: ViewBag.Head = "Complaint"; ViewBag.MsgType = mgid; break; case (int)CLayer.ObjectStatus.MsgType.Feedback: ViewBag.Head = "Feedback"; ViewBag.MsgType = mgid; break; default: ViewBag.Head = "Query"; ViewBag.MsgType = (int)CLayer.ObjectStatus.MsgType.Query; break; } } else { ViewBag.MsgType = (int)CLayer.ObjectStatus.MsgType.Query; } QueryModel qry = new QueryModel() { QueryId = 0 }; CLayer.Query query = BLayer.Query.Get(id); if (query != null) { qry = new QueryModel() { QueryId = query.QueryId, Name = query.Name, Email = query.Email, Phone = query.Phone, Subject = query.Subject, Body = query.Body, CreatedOn = query.CreatedOn, Status = query.Status } } ; if (qry.Status < 2) { BLayer.Query.SetStatus(id, (int)QueryModel.status.Viewed); } return(PartialView("_Query", qry)); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/Admin/ErrorPage")); } }