public ActionResult PostMessage(feedBack data)
{
String respns = "insert into Contact(Name,Email,Contact,Message) values('" + data.txtName + "','" + data.txtEmail + "','" + data.txtPhone + "','" + data.txtMessage + "')";
instance.Query(respns);
return(View("Redirect"));
}
public async Task <IActionResult> PutfeedBack(int id, feedBack feedBack)
{
if (id != feedBack.fid)
{
return(BadRequest());
}
_context.Entry(feedBack).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!feedBackExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <feedBack> > PostfeedBack(feedBack feedBack)
{
_context.feedBack.Add(feedBack);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetfeedBack", new { id = feedBack.fid }, feedBack));
}
// GET: Customer/Delete/5
public ActionResult Delete(feedBack feedbackID)
{
var d = buyHomeEntities.feedBacks.Where(x => x.feedbackID == feedbackID.feedbackID).FirstOrDefault();
buyHomeEntities.feedBacks.Remove(d);
buyHomeEntities.SaveChanges();
return(RedirectToAction("viewFeedBack"));
}
public ActionResult SendMsg(feedBack log)
{
//object of the feed back class that is used to passs the record in the table by using the class of the controller or model class and using the getter setter method of the class
feedBack obj_Feed = new feedBack();
//passin the query to the controller of the main class that is used to insert the reocrd
String query = "insert into Contact(Name,Email,Msg) values('" + log.Name + "','" + log.Email + "','" + log.Message + "')";
//calling the method of the model class
obj_Feed.send(query);
//redirecting the user to the feed back page after giving the feed back to the user
return(View("return_Feed"));
}
private void btn_sendReview_Click(object sender, EventArgs e)
{
feedBack feedBack = new feedBack();
feedBack.maHV = txt_memberName.Text;
feedBack.date = dtP_reviewDate.Value;
feedBack.feedback = txt_review.Text;
feedBackDB database = new feedBackDB();
if (database.Insert(feedBack))
{
MessageBox.Show("Gửi phản hồi thành công.");
Log.Insert("Gửi phản hồi từ khách hàng " + txt_memberName);
txt_memberName.Text = "";
txt_review.Text = "";
}
else
{
MessageBox.Show("Gửi phản hồi thất bại, vui lòng thử lại.");
}
}
public bool Insert(feedBack feedback)
{
sqlQuery = "insert into Feedback (maKH,thoigian,feedback)" +
" values('" + feedback.maHV + "', '" + feedback.date + "', N'" + feedback.feedback + "')";
conString.ConString constring = new conString.ConString(); //this will hide the database info ... sort of
try
{
using (var con = new SqlConnection(constring.initString()))
{
using (var cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
}
}
catch (SqlException ex)
{
return(false);
}
}
public ActionResult saveFeedback(int num)
{
CSVFile csv = CSVInjector.csv;
ChartVisualizationObject chViz = ChartVisualizationObjectInjector.CVObject;
feedBack fb = new feedBack();
int recCount = chViz.chartTypes.Count();
if (recCount > num)
{
fb.recommendation = chViz.chartTypes[num];
}
else
{
fb.recommendation = chViz.more_chartTypes[num - recCount];
}
fb.tableID = (int)Session["CurrentTableId"];
int colCount = csv.Data.Count();
fb.numOfDim = colCount;
fb.intention = csv.Intension;
fb.dim1_IsContinuous = csv.Data[0].IsContinous ? 1 : 0;
fb.dim1_context = csv.Data[0].Context;
fb.dim1_Cardinality = csv.Data[0].NumDiscreteValues;
if (colCount == 7)
{
fb.dim7_IsContinuous = csv.Data[6].IsContinous ? 1 : 0;
fb.dim7_context = csv.Data[6].Context;
fb.dim7_Cardinality = csv.Data[6].NumDiscreteValues;
}
if (colCount > 5)
{
fb.dim6_IsContinuous = csv.Data[5].IsContinous ? 1 : 0;
fb.dim6_context = csv.Data[5].Context;
fb.dim6_Cardinality = csv.Data[5].NumDiscreteValues;
}
if (colCount > 4)
{
fb.dim5_IsContinuous = csv.Data[4].IsContinous ? 1 : 0;
fb.dim5_context = csv.Data[4].Context;
fb.dim5_Cardinality = csv.Data[4].NumDiscreteValues;
}
if (colCount > 3)
{
fb.dim4_IsContinuous = csv.Data[3].IsContinous ? 1 : 0;
fb.dim4_context = csv.Data[3].Context;
fb.dim4_Cardinality = csv.Data[3].NumDiscreteValues;
}
if (colCount > 2)
{
fb.dim3_IsContinuous = csv.Data[2].IsContinous ? 1 : 0;
fb.dim3_context = csv.Data[2].Context;
fb.dim3_Cardinality = csv.Data[2].NumDiscreteValues;
}
if (colCount > 1)
{
fb.dim2_IsContinuous = csv.Data[1].IsContinous ? 1 : 0;
fb.dim2_context = csv.Data[1].Context;
fb.dim2_Cardinality = csv.Data[1].NumDiscreteValues;
}
db.feedBacks.Add(fb);
db.SaveChanges();
return(Json(null, JsonRequestBehavior.AllowGet));
}
