public static bool InsertFeedback(string pid, int isliked, int rating, string comment)
{
//bool result = false;
if (string.IsNullOrEmpty(pid))
{
return false;
}
STORE store = mydb.STOREs.SingleOrDefault(s => s.PLACE_ID == pid);
if (store == null)
{
return false;
}
if (HttpContext.Current.Session == null)
{
return false;
}
USER user = HttpContext.Current.Session["user"] as USER;
FEEDBACK feedback = new FEEDBACK() { IS_LIKED=isliked,RATING=rating, COMMENT=comment, RATING_DATE= DateTime.Now,STORE_ID=store.STORE_ID , USER_ID=user.USER_ID};
try
{
mydb.FEEDBACKs.InsertOnSubmit(feedback);
mydb.SubmitChanges();
return true;
}
catch
{
return false;
}
}
public int InsertFeedBack(FEEDBACK fb)
{
db.FEEDBACKs.Add(fb);
db.SaveChanges();
return(fb.ID);
}
public IHttpActionResult PutFEEDBACK(int id, FEEDBACK fEEDBACK)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != fEEDBACK.FeedBackNo)
{
return(BadRequest());
}
db.Entry(fEEDBACK).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!FEEDBACKExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Alterar(FEEDBACK ofeedback, bool attach = true)
{
if (attach)
{
odb.Entry(ofeedback).State = System.Data.Entity.EntityState.Modified;
}
odb.SaveChanges();
}
public IHttpActionResult GetFEEDBACK(int id)
{
FEEDBACK fEEDBACK = db.FEEDBACKs.Find(id);
if (fEEDBACK == null)
{
return(NotFound());
}
return(Ok(fEEDBACK));
}
public ActionResult Details(FEEDBACK fb)
{
int id = int.Parse(Url.RequestContext.RouteData.Values["id"].ToString());
fb.ID_SACH = id;
fb.XACNHAN_MUAHANG = true;
fb.THOIGIAN_DANG = Convert.ToString(DateTime.Now);
db.FEEDBACKs.Add(fb);
db.SaveChanges();
return(View(db.SACHes.Where(s => s.ID_SACH == id).FirstOrDefault()));
}
public ActionResult Create(FEEDBACK oFeedback)
{
if (ModelState.IsValid)
{
db.FEEDBACK.Add(oFeedback);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View(oFeedback));
}
public IHttpActionResult PostFEEDBACK(FEEDBACK fEEDBACK)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.FEEDBACKs.Add(fEEDBACK);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = fEEDBACK.FeedBackNo }, fEEDBACK));
}
public int Insert(FEEDBACK feedback)
{
try
{
db.FEEDBACK.Add(feedback);
db.SaveChanges();
return(feedback.ID);
}
catch (Exception)
{
return(0);
}
}
public ActionResult Comment(string comment, int id)
{
if (!String.IsNullOrEmpty(comment))
{
FEEDBACK fb = new FEEDBACK();
fb.NoiDung = comment;
fb.NgayTao = DateTime.Now;
fb.MaKH = 1;
data.FEEDBACKs.InsertOnSubmit(fb);
data.SubmitChanges();
return(RedirectToAction("Detail", new { id = id }));
}
return(RedirectToAction("Detail", new { id = id }));
}
public IHttpActionResult DeleteFEEDBACK(int id)
{
FEEDBACK fEEDBACK = db.FEEDBACKs.Find(id);
if (fEEDBACK == null)
{
return(NotFound());
}
db.FEEDBACKs.Remove(fEEDBACK);
db.SaveChanges();
return(Ok(fEEDBACK));
}
public ActionResult Index(FEEDBACK feedback)
{
using (platinumTourEntities db = new platinumTourEntities())
{
db.FEEDBACK.Add(new FEEDBACK
{
name = feedback.name,
email = feedback.email,
feedback1 = feedback.feedback1
});
db.SaveChanges();
}
return(View());
}
public ActionResult AddFB(FEEDBACK feedback, string description, int id)
{
if (ModelState.IsValid)
{
feedback.Description = description;
feedback.Status = false;
feedback.StudentId = 2;
feedback.Time = DateTime.Now;
feedback.FacilitiesId = id;
ManageStudent.FEEDBACKs.Add(feedback);
ManageStudent.SaveChanges();
return(Redirect("/Facilities/Index?id=" + id));
}
return(Content("Please check comment"));
}
public HttpResponseMessage AddFeedback(dynamic feedback)
{
try
{
FEEDBACK feed = new FEEDBACK();
feed.COMPLAINTID = feedback.COMPLAINTID;
feed.DATE = DateTime.Now;
feed.FEEDBACKCOMMENT = feedback.FEEDBACK;
feed.JOBID = feedback.JOBID;
db.FEEDBACKs.Add(feed);
db.SaveChanges();
}
catch (Exception)
{
return(null);
}
return(Request.CreateResponse(HttpStatusCode.Created));
}
/// <summary>
/// 发送一个反馈
/// </summary>
/// <param name="feedBackDTO"></param>
/// <returns></returns>
public bool insertOneFeedBack(FeedbackDTO feedBackDTO)
{
try
{
DateTime dateTime = DateTime.Now;
FEEDBACK feedback = new FEEDBACK
{
CUSTOMER_ID = feedBackDTO._customer_id,
SUGGEST_CONTENT = feedBackDTO._suggest_content,
SUGGEST_DATE = dateTime
};
Db.Insertable(feedback).IgnoreColumns(it => new { it.SUGGEST_ID }).ExecuteCommand();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public void Incluir(FEEDBACK oFeedback)
{
//var local = odb.Set<AMIGO>()
// .Local
// .FirstOrDefault(f => f.IDA == oAmigo.IDA);
//odb.Entry(local).State = System.Data.Entity.EntityState.Detached;
//odb.Entry(oAmigo).State = System.Data.Entity.EntityState.Added;
//odb.SaveChanges();
//odb.Entry(oAmigo).State = System.Data.Entity.EntityState.Added;
odb.FEEDBACK.Add(oFeedback);
odb.SaveChanges();
}
public dynamic AddFeedback(dynamic feedback)
{
INF370Entities db = new INF370Entities();
try
{
FEEDBACK feed = new FEEDBACK();
feed.COMPLAINTID = feedback.COMPLAINTID;
feed.DATE = DateTime.Now;
feed.FEEDBACKCOMMENT = feedback.FEEDBACK;
feed.JOBID = feedback.JOBID;
db.FEEDBACKs.Add(feed);
db.SaveChanges();
}
catch (Exception)
{
return(null);
}
return(true);
}
public JsonResult Send(string name, string sdt, string email, string title, string content, string address)
{
FEEDBACK FB = new FEEDBACK();
FB.NAME = name;
FB.PHONE = sdt;
FB.NOIDUNG = content;
FB.EMAIL = email;
FB.TITLE = title;
FB.ADDRESS = address;
var id = new ContactDAO().InsertFeedBack(FB);
if (id > 0)
{
return(Json(new
{
status = true
}));
}
return(Json(new
{
status = false
}));
}
public async Task <bool> insertFeedback(string numRoom, FEEDBACK feedbackInput)
{
var index = 1;
SetResponse response;
var inforFeedback = await getInforFeedback(numRoom);
var listSort = inforFeedback
.Where(item => item != null)
.OrderBy(item => item.STT).ToList();
if (listSort.Count > 0)
{
// has item with room current
var itemLast = listSort.LastOrDefault();
var numIndexLast = itemLast.STT.toInt32();
feedbackInput.STT = (numIndexLast + index).ToString();
response = await client.SetAsync("ThongTinPhanHoi/" + numRoom + "/" + (numIndexLast + index).ToString(), feedbackInput);
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
return(true);
}
}
else
{
// none item with room current
feedbackInput.STT = index.ToString();
response = await client.SetAsync("ThongTinPhanHoi/" + numRoom + "/" + index.ToString(), feedbackInput);
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
return(true);
}
}
return(false);
}
public static void InsertGoogleStore(string storejson)
{
Store s = myConvert.Deserialize<Store>(storejson);
try
{
if (s == null)
{ return; }
Random r = new Random();
int i = r.Next(0, 6);
//string[] users = new string[6] { "gdabli", "harshisame", "nari.dontula", "rungta.sachin", "SiChen", "YongZhuang" };
string[] users = new string[6] { "Gaurav_Dabli", "Harshita_Gupta", "Harshita_Gupta", "Nari_Dontula", "Nari_Dontula", "Yong_Zhuang" };
if (mydb.STOREs.SingleOrDefault(ss => ss.PLACE_ID == s.place_id) != null)
{
return;
}
//{ "geometry": { "location": { "k": 42.360128, "B": -71.055454 } }, "name": "Cheers", "types": ["cafe", "bar", "restaurant", "food", "establishment"], "vicinity": "1 S Market St, Boston", "html_attributions": [] }
STORE store = new STORE() { NAME = s.name, PLACE_ID = s.place_id, PRICE_LEVEL = s.price_level, RATING = s.rating, PHONE = s.formatted_phone_number, WEBSITE = s.website, OWNER = users[i], GOOGLE_URL = s.url };
LOCATION location = new LOCATION() { LATITUDE = s.geometry.location.k, LONGITUDE = s.geometry.location.B };
mydb.LOCATIONs.InsertOnSubmit(location);
store.LOCATION = location;
ADDRESS address = new ADDRESS() { ADDRESS_LINE1 = s.vicinity.Split(',')[0], CITY = s.vicinity.Split(',')[1] };
if (s.address_components != null)
{
foreach (Address_Components ad in s.address_components)
{
foreach (string type in ad.types)
{
switch (type)
{
case "country":
{
address.COUNTRY = ad.long_name;
break;
}
case "postal_code":
{
address.POSTAL_CODE = ad.long_name;
break;
}
case "administrative_area_level_1":
{
address.STATE_PROVINCE_REGION = ad.long_name;
break;
}
}
}
}
}
mydb.ADDRESSes.InsertOnSubmit(address);
store.ADDRESS = address;
if (s.opening_hours != null)
{
foreach (Period period in s.opening_hours.periods)
{
PERIOD p = new PERIOD() { OPEN_DAY = period.open.day, CLOSE_DAY = period.close.day, OPEN_TIME = Convert.ToDateTime(period.open.hours + ":" + period.open.minutes).TimeOfDay, CLOSE_TIME = Convert.ToDateTime(period.close.hours + ":" + period.close.minutes).TimeOfDay };
store.PERIODs.Add(p);
}
}
if (s.reviews != null)
{
foreach (Review review in s.reviews)
{
if (string.IsNullOrEmpty(review.author_name) || review.author_name == "A Google User")
{
continue;
}
USER user = mydb.USERs.SingleOrDefault(u => u.FIRST_NAME + " " + u.LAST_NAME == review.author_name);
if (user == null)
{
string[] name = review.author_name.Split(' ');
if (name.Length > 1)
{
user = new USER() { FIRST_NAME = name[0], LAST_NAME = name[1], USER_ID = name[0] + "_" + name[1], EMAIL = name[0] + "." + name[1] + "@gmail.com", PASSWORD = "******", ROLE = "0", REGISTER_DATE = DateTime.Now };
}
else if (name.Length > 0)
{
user = new USER() { FIRST_NAME = name[0], LAST_NAME = "", USER_ID = name[0], EMAIL = name[0] + "@gmail.com", PASSWORD = "******", ROLE = "0", REGISTER_DATE = DateTime.Now };
}
mydb.USERs.InsertOnSubmit(user);
}
if (user != null)
{
FEEDBACK feed = new FEEDBACK() { COMMENT = review.text, RATING = review.rating };
feed.IS_LIKED = feed.RATING > 2.5 ? 1 : 0;
feed.USER = user;
feed.STORE = store;
mydb.FEEDBACKs.InsertOnSubmit(feed);
}
}
}
if (s.types != null)
{
foreach (string type in s.types)
{
CATEGORY catergory = mydb.CATEGORies.SingleOrDefault(c => c.NAME == type);
if (catergory == null)
{
catergory = new CATEGORY() { NAME = type, LAYER = 1, PARENT = 0 };
mydb.CATEGORies.InsertOnSubmit(catergory);
}
STORE_CATEGORY s_c = new STORE_CATEGORY();
s_c.CATEGORY = catergory;
s_c.STORE = store;
mydb.STORE_CATEGORies.InsertOnSubmit(s_c);
}
}
mydb.SubmitChanges();
}
catch (Exception e)
{
throw e;
}
}
public void Excluir(FEEDBACK oFeedback)
{
_Repository.Excluir(oFeedback);
}
public void Incluir(FEEDBACK oFeedback)
{
_Repository.Incluir(oFeedback);
}
public void Excluir(FEEDBACK oFeedback)
{
odb.FEEDBACK.Attach(oFeedback);
odb.FEEDBACK.Remove(oFeedback);
odb.SaveChanges();
}
