public ActionResult Create(int servicesId, string userfeedbackEmail, string userfeedbackMsg)
{
//creating a feedback for the selected service via "POST" method
Debug.WriteLine("userFeedbackEmail" + userfeedbackEmail);
Debug.WriteLine("userFeedbackMsg" + userfeedbackMsg);
Userfeedback userfeedback = new Userfeedback();
userfeedback.servicesId = servicesId;
userfeedback.userfeedbackEmail = userfeedbackEmail;
userfeedback.userfeedbackMsg = userfeedbackMsg;
db.Userfeedbacks.Add(userfeedback);
db.SaveChanges();
/*string query = "insert into Faqs(departmentId, faqQuestion, faqAnswer) values (@departmentId, @faqQuestion, @faqAnswer)";
* SqlParameter[] sqlparams = new SqlParameter[3];
* sqlparams[0] = new SqlParameter("@departmentId", departmentId);
* sqlparams[1] = new SqlParameter("@faqQuestion", faqQuestion);
* sqlparams[2] = new SqlParameter("@faqAnswer", faqAnswer);
*
* db.Database.ExecuteSqlCommand(query, sqlparams);*/
//after creating the feedback remain on the create page
return(RedirectToAction("Create"));
}
private void button4_Click(object sender, EventArgs e)//反馈
{
Userfeedback ub = new Userfeedback();
ub.Owner = this;
this.Hide();
ub.ShowDialog();
}
public ActionResult Delete(int id)
{
Debug.WriteLine("userFeedbackId" + id);
//delete the details of the selected feedback where the id matches in the database table
Userfeedback userfeedback = db.Userfeedbacks.Find(id);
db.Userfeedbacks.Remove(userfeedback);
db.SaveChanges();
return(RedirectToAction("Details"));
}
public ActionResult Edit(int id, string userfeedbackMsg)
{
//updating the field via "POST" method
Debug.WriteLine("userFeedbackId" + id);
Debug.WriteLine("userFeedbackMsg" + userfeedbackMsg);
Userfeedback userfeedback = db.Userfeedbacks.Find(id);
userfeedback.userfeedbackMsg = userfeedbackMsg;
db.SaveChanges();
return(RedirectToAction("Details"));
}
public ActionResult Show(int?id)
{
Debug.WriteLine(id);//displaying id of particular feedback
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Userfeedback userfeedback = db.Userfeedbacks.Find(id);
if (userfeedback == null)
{
return(HttpNotFound());
}
return(View(userfeedback));
}
private static bool ValidateFeedback(Userfeedback userFeedback)
{
bool ValidFeedback = true;
StringBuilder sb = new StringBuilder();
if (userFeedback.feedback == string.Empty)
{
ValidFeedback = false;
sb.Append(Environment.NewLine + "Empty Feedbacks aren't allowed");
}
if (ValidFeedback == false)
{
throw new MovieException.MTSException(sb.ToString());
}
return(ValidFeedback);
}
public static bool AddUserFeedbackBL(Userfeedback newuserfeedback)
{
bool feedbackAdded = false;
try
{
if (ValidateFeedback(newuserfeedback))
{
feedbackAdded = MovieDAL.UserFeedbackDAL.AddUserFeedbackDAL(newuserfeedback);
}
}
catch (MovieException.MTSException e)
{
throw e;
}
catch (Exception ex)
{
throw ex;
}
return(feedbackAdded);
}
