public async Task <ActionResult> Feedback(FeedBackModel model)
{
try
{
RecaptchaVerificationHelper recaptchaHelper = this.GetRecaptchaVerificationHelper();
if (String.IsNullOrEmpty(recaptchaHelper.Response))
{
TempData["FeedbackStatus"] = false;
TempData["FeedbackMessage"] = "Vui lòng nhập mã bảo mật bên dưới.";
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
RecaptchaVerificationResult recaptchaResult = recaptchaHelper.VerifyRecaptchaResponse();
if (recaptchaResult != RecaptchaVerificationResult.Success)
{
TempData["FeedbackStatus"] = false;
TempData["FeedbackMessage"] = "Vui lòng nhập lại mã bảo mật bên dưới.";
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
TempData["FeedbackStatus"] = model.InsertNewFeedback();
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
catch (Exception exception)
{
LoggingUtil.LogException(exception);
return(RedirectToAction(Constants.SystemFailureHomeAction, Constants.ErrorController));
}
}
public int SaveFeedBack(FeedBackModel model)
{
using (ApiDal apiDal = new ApiDal())
{
return(apiDal.SaveFeedBack(model));
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
var model = new FeedBackModel();
var fb = createFeedBack();
LblStatus.Text = model.InsertFeedBack(fb);
}
public override FeedBackModel GetByIdFeedBack(int id)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_GET_FEEDBACK_BY_ID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = id;
cn.Open();
IDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
FeedBackModel model = new FeedBackModel {
(int)reader["id"],
reader["Title"].ToString,
reader["Description"].ToString,
reader["Date"].ToString,//ko biet kieu ji
reader["Email"].ToString,
(int)reader["STATUS"]
};
}
else
{
return(null);
}
}
}
public PartialViewResult FeedBackPopup(FeedBackModel form)
{
if (form.Mail.IsNullOrEmpty())
{
form.ErrorText = "Необходимо указать E-mail";
return(PartialView(form));
}
if (form.Text.IsNullOrEmpty())
{
form.ErrorText = "Необходимо заполнить текст сообщения";
return(PartialView(form));
}
var replacements = new List <MailReplacement>();
replacements.Add(new MailReplacement("{TYPE}", form.TypeName));
replacements.Add(new MailReplacement("{MAIL}", form.Mail));
replacements.Add(new MailReplacement("{NAME}", form.Name));
replacements.Add(new MailReplacement("{TEXT}", form.Text));
string result = MailingList.Get("FeedBackLetter")
.WithReplacements(replacements)
.Send();
if (result.IsNullOrEmpty())
{
form.ErrorText =
"Ваше сообщение успешно отправлено.";
}
else
{
form.ErrorText = "Произошла ошибка при отправке сообщения. Попробуйте повторить попытку позже";
}
return(PartialView(form));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Common.CheckPermission(Common.Module_Feedback, Common.Permission_View, HttpContext.Current))
{
Response.Redirect("nopermission.aspx");
}
else
{
string idstr = Request.QueryString["id"];
int id = 0;
int.TryParse(idstr, out id);
if (id > 0)
{
FeedBackBLL fbb = new FeedBackBLL();
int total = 0;
List <FeedBackModel> list = new List <FeedBackModel>();
fbb.GetFeedBackList(1, 1, id, null, null, null, null, out total, out list);
if (list.Count == 1)
{
FeedBackModel model = list[0];
title_txt.Text = model.Title;
content_txt.Text = model.Content;
contact_txt.Text = model.Name;
mobile_txt.Text = model.Mobile;
email_txt.Text = model.Email;
date_txt.Text = string.Format("{0:yyyy-MM-dd}", model.CreateTime);
}
}
}
}
private void LoadFeedback()
{
FeedBackBLL fbb = new FeedBackBLL();
int total = 0;
List <FeedBackModel> list = new List <FeedBackModel>();
if (Common.CheckPermission(Common.Module_Feedback, Common.Permission_View, HttpContext.Current))
{
try
{
if (user.Type == AdminType.Managers)
{
fbb.GetFeedBackList(1, 5, null, null, null, null, null, out total, out list);
}
else
{
fbb.GetFeedBackList(1, 5, null, null, null, user.AdminId, true, out total, out list);
}
for (int i = 0; i < list.Count; i++)
{
FeedBackModel model = list[i];
fbbody = fbbody + "<tr><td>" + model.CreateTime + "</td><td><a target=\"_blank\" href=\"feedback.aspx?id=" + model.Title + "\">" + model.Title + "</a></td></tr>";
}
}
catch (Exception ex)
{
WriteLog.WriteExceptionLog("LoadFeedback", ex);
}
}
else
{
feedbackpl.Visible = false;
}
}
public ActionResult FeedBack(FeedBackModel loFeedBack, FormCollection Form)
{
EducationDataContext loEduContext = new EducationDataContext();
loEduContext.FeedBack(loFeedBack, Form["ContactFor"]);
return(RedirectToAction("Index"));
}
public ServiceResponse <string> ModifyFeedBack(FeedBackModel model)
{
var sRes = new ServiceResponse <string>();
try
{
if (FeedBackBAL.ModifyFeedBack(model) > 0)
{
sRes.StatusCode = 200;
}
else
{
sRes.StatusCode = (int)HttpStatusCode.InternalServerError;;
}
}
catch (Exception ex)
{
sRes.StatusCode = (int)HttpStatusCode.InternalServerError;
if (ex.InnerException != null)
{
sRes.Messages.Add(ex.InnerException.ToString());
}
}
return(sRes);
}
public void DeleteFeedBack(int id)
{
FeedBackModel feed = context.FeedBack.FirstOrDefault(x => x.Id == id);
context.Entry(feed).State = EntityState.Deleted;
context.SaveChanges();
}
public ActionResult Mentes(FeedBack feedback)
{
if (!ModelState.IsValid)
{
var vm = new FeedBackModel
{
FeedBack = feedback
};
return(View("Uj", vm));
}
if (feedback.Id == null || feedback.Id == 0)
{
if (feedback.Nev == null)
{
feedback.Nev = "Anonymus";
}
feedback.Datum = DateTime.Now;
feedback.Engedelyezett = false;
feedback.Lattamozott = false;
_context.FeedBack.Add(feedback);
}
_context.SaveChanges();
return(RedirectToAction("Index", "FeedBack"));
}
public ActionResult EditFeedBack(int Id = -1)
{
FeedBackInfo feedBackInfo = FeedBack.GetFeedBackById(Id);
if (feedBackInfo == null)
{
return(PromptView("信息反馈信息不存在"));
}
FeedBackModel model = new FeedBackModel
{
Id = feedBackInfo.Id,
FeedBackTypeId = feedBackInfo.FeedBackTypeId,
Tag = feedBackInfo.Tag,
LinkMan = feedBackInfo.LinkMan,
Tel = feedBackInfo.Tel,
Mobile = feedBackInfo.Mobile,
Email = feedBackInfo.Email,
Title = feedBackInfo.Title,
Body = feedBackInfo.Body,
AddTime = feedBackInfo.AddTime,
Reply = feedBackInfo.Reply,
ReplyTime = feedBackInfo.ReplyTime,
State = feedBackInfo.State,
IsOut = feedBackInfo.IsOut,
Ip = feedBackInfo.Ip,
SearchKey = feedBackInfo.SearchKey
};
ViewData["referer"] = SiteUtils.GetAdminRefererCookie();
return(View(model));
}
public ActionResult EditFeedBack(FeedBackModel model, int Id = -1)
{
FeedBackInfo feedBackInfo = FeedBack.GetFeedBackById(Id);
if (feedBackInfo == null)
{
return(PromptView("信息反馈信息不存在"));
}
if (ModelState.IsValid)
{
feedBackInfo.Tag = model.Tag;
feedBackInfo.LinkMan = model.LinkMan;
feedBackInfo.Tel = model.Tel;
feedBackInfo.Mobile = model.Mobile;
feedBackInfo.Email = model.Email;
feedBackInfo.Title = model.Title;
feedBackInfo.Body = model.Body;
feedBackInfo.Reply = model.Reply;
feedBackInfo.State = model.State;
feedBackInfo.IsOut = model.IsOut;
if (model.State.Equals(1))
{
feedBackInfo.ReplyTime = DateTime.Now;
}
FeedBack.UpdateFeedBackInfo(feedBackInfo);
return(PromptView("信息反馈修改成功"));
}
ViewData["referer"] = SiteUtils.GetAdminRefererCookie();
return(View(model));
}
public ActionResult AddSolution(FeedBackModel loSolution)
{
AdminDataContext loAdminContext = new AdminDataContext();
loAdminContext.AddSolution(loSolution);
SmtpClient Client = new SmtpClient("smtp.gmail.com");
Random rnd = new Random();
string to = loSolution.EmailID;
string from = "*****@*****.**";//"*****@*****.**";
string subject = "Solution for Complaint on Online Education System";
string body = "<font>Hello dear " + loSolution.UserName + "<br /> Thanks for Contacting Us<br /><p> As your Complaint for Complaint ID - " + loSolution.ComplaintID + " as " + loSolution.Subjet + "we have tried to solve your complaint. The Solution is as below <br /></p><p>" + loSolution.Solution + "</p>Hope It will helpful to you <br/> </r>Thanks From Edu Team</font>";
MailMessage mail = new MailMessage(from, to, subject, body);
mail.IsBodyHtml = true;
Client.EnableSsl = true;
Client.Port = 443;
Client.UseDefaultCredentials = false;
Client.DeliveryMethod = SmtpDeliveryMethod.Network;
Client.Credentials = new NetworkCredential("*****@*****.**", "Admin.Online");//("*****@*****.**", "CFvgbhnj12#");
Client.Send(mail);
ViewBag.msg = "Email Sent";
return(RedirectToAction("Index"));
}
// GET: Admin/FeedBackandComplaint
public ActionResult Index()
{
AdminDataContext loAdminContext = new AdminDataContext();
FeedBackModel loFeedBack = new FeedBackModel();
loFeedBack.loComplaints = loAdminContext.GetComplaintsList();
var s = 0;
var U = 0;
foreach (var data in loFeedBack.loComplaints)
{
if (data.Solution == null)
{
U++;
}
else
{
s++;
}
}
ViewBag.Solved = s;
ViewBag.UnSolved = U;
ViewBag.TotalComplaints = loFeedBack.loComplaints.Count();
return(View(loFeedBack));
}
public string LogFeedBack(FeedBackModel feedBackModel)
{
string success = "";
try
{
using (var mdb = new OggleBoobleMySqContext())
{
mdb.FeedBacks.Add(new FeedBack()
{
FeedBackComment = feedBackModel.FeedBackComment,
FeedBackType = feedBackModel.FeedBackType,
PageId = feedBackModel.PageId,
FeedBackEmail = feedBackModel.FeedBackEmail,
VisitorId = feedBackModel.VisitorId,
Occured = DateTime.Now
});
mdb.SaveChanges();
success = "ok";
}
}
catch (Exception ex)
{
success = Helpers.ErrorDetails(ex);
}
return(success);
}
public int SaveFeedBack(FeedBackModel model)
{
using (ApiBusiness apiBusiness = new ApiBusiness())
{
return(apiBusiness.SaveFeedBack(model));
}
}
public ActionResult GetComplaints(string ID, string status)
{
AdminDataContext loAdminContext = new AdminDataContext();
FeedBackModel loFeedBack = new FeedBackModel();
loFeedBack.loComplaints = loAdminContext.GetComplaintsList((ID == "") ? null : ID, (status == "") ? null : status);
return(View("~/Areas/Admin/Views/FeedBackandComplaint/_GetComplaintsForSearch.cshtml", loFeedBack));
}
// GET: Home
public ActionResult Index()
{
EducationDataContext loEducontext = new EducationDataContext();
FeedBackModel loData = new FeedBackModel();
loData.loUserModel = new EducationDataContext().UserDataForIndex();
return(View("index", loData));
}
public IHttpActionResult CreateComment(FeedBackModel feedBackModel)
{
Comment feedBack = feedBackModel.ToFeedBack();
_command.AddComment(feedBack);
var model = feedBack.ToFeedBackResponseModel();
return(PostResults.Created(this, model));
}
public static Comment ToFeedBack(this FeedBackModel model)
{
return(new Comment
{
Message = model.Message,
Author = model.Author,
Email = model.Email,
CreatedAt = DateTime.Now
});
}
public void AddSolution(FeedBackModel loSolution)
{
List <SqlParameter> ProcParam = new List <SqlParameter>();
ProcParam.Add(new SqlParameter("ComplaintID", loSolution.ComplaintID.handleDBNull()));
ProcParam.Add(new SqlParameter("Solution", loSolution.Solution.handleDBNull()));
ProcParam.Add(new SqlParameter("Date", DateTime.Now.Date.ToShortDateString()));
new AdminDataContext().Database.ExecuteSqlCommand("exec AddSolution @ComplaintID,@Solution,@Date", ProcParam.ToArray());
}
public FeedBackModel registerStudent(FeedBack studentregd)
{
FeedBackModel stdregreply = new FeedBackModel();
MyService.Add(studentregd);
stdregreply.Description = studentregd.Description;
stdregreply.ParentId = 2;
stdregreply.FeedBackDate = DateTime.Today;
return(stdregreply);
}
public int ModifyFeedBack(FeedBackModel model)
{
SqlParameter[] param =
{
new SqlParameter("@Type", model.Type),
new SqlParameter("@Name", model.Name),
new SqlParameter("@EmailAddress", model.EmailAddress),
new SqlParameter("@PhoneNumber", model.PhoneNumber),
new SqlParameter("@Message", model.Message)
};
return(Convert.ToInt16(SqlHelper.ExecuteScalar(System.Data.CommandType.StoredProcedure, "USP_FeedbackContact", param)));
}
public void SaveFeedBack(FeedBackModel feedBack)
{
if (feedBack.Id == default)
{
context.Entry(feedBack).State = EntityState.Added;
}
else
{
context.Entry(feedBack).State = EntityState.Modified;
}
context.SaveChanges();
}
public ActionResult Create(FeedBackModel rm)
{
DateTime today = DateTime.Now;
FeedBack rep = new FeedBack()
{
FeedBackDate = today,
Description = rm.Description,
ParentId = (int)Session["idu"],
};
RepService.Add(rep);
RepService.Commit();
return(RedirectToAction("Index", "Home"));
}
public IHttpActionResult PostNewFeed(FeedBackModel student)
{
using (var ctx = new PidevContext())
{
ctx.Reputations.Add(new FeedBack()
{
FeedBackId = student.FeedBackId,
Description = student.Description,
ParentId = 2,
FeedBackDate = DateTime.Today
});
ctx.SaveChanges();
}
return(Ok());
}
public int SaveFeedBack(FeedBackModel model)
{
tblFeedback feedBackObj = new tblFeedback();
if (model != null)
{
feedBackObj.Headline = model.FeedBackHeadline;
feedBackObj.Feedback = model.FeedBack;
feedBackObj.ConsumerProfilePicture = ConvertBase64StringToByteArray(model.ProfilePicture);
feedBackObj.Consumer_ID = db.tblConsumers.Where(x => x.Login_ID == Session.Login_ID).FirstOrDefault().ID;
feedBackObj.ConsumerName = model.UserName;
db.tblFeedbacks.Add(feedBackObj);
db.SaveChanges();
}
return(feedBackObj.ID > 0 ? feedBackObj.ID : 0);
}
public override bool UpdateFeedBack(FeedBackModel model)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_UPDATE_FEEDBACK", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = model.Id;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = model.Title;
cmd.Parameters.Add("@Descriotion", SqlDbType.NVarChar).Value = model.Description;
cmd.Parameters.Add("@Date", SqlDbType.Date).Value = model.Date;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = model.Email;
cmd.Parameters.Add("@STATUS", SqlDbType.Int).Value = model.Status;
cn.Open();
int re = ExecuteNonQuery(cmd);
return (re == 1);
}
}
public override bool InsertFeedBack(FeedBackModel model)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_ADD_FEEDBACK", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = model.Id;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = model.Title;
cmd.Parameters.Add("@Descriotion", SqlDbType.NVarChar).Value = model.Description;
cmd.Parameters.Add("@Date", SqlDbType.Date).Value = model.Date;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = model.Email;
cmd.Parameters.Add("@STATUS", SqlDbType.Int).Value = model.Status;
cn.Open();
int re = ExecuteNonQuery(cmd);
return(re == 1);
}
}
public PartialViewResult FeedBackPopup()
{
var model = new FeedBackModel()
{
Type = "offer"
};
if (HttpContext.User.Identity.IsAuthenticated)
{
var db = new DB();
var user = db.Users.FirstOrDefault(x => x.UserId == HttpContext.GetCurrentUserUID());
if (user != null)
{
model.Mail = user.MembershipData.Email;
model.Name = user.Profile.FullName;
}
}
return(PartialView(model));
}
public override FeedBackModel GetByIdFeedBack(int id)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_GET_FEEDBACK_BY_ID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = id;
cn.Open();
IDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
FeedBackModel model = new FeedBackModel {
(int)reader["id"],
reader["Title"].ToString,
reader["Description"].ToString,
reader["Date"].ToString,//ko biet kieu ji
reader["Email"].ToString,
(int)reader["STATUS"]
};
}
else
return null;
}
}
public abstract int InsertFeedBack(FeedBackModel model);
