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