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