public bool Linq_Sua(int slide_id, string image, string link, string slide_title, string slide_title1) { tbSlide update = db.tbSlides.Where(x => x.slide_id == slide_id).FirstOrDefault(); update.slide_title = slide_title; if (image != "x") { update.slide_image = image; } //update.slide_summary = slide_summary; //update.slide_content = content; update.slide_link = link; //update.slide_title1 = slide_title1; try { db.SubmitChanges(); return(true); } catch { return(false); } }
public bool Linq_Sua(int slide_id, string image, string link, string slide_title, string slide_title1) { tbSlide update = db.tbSlides.Where(x => x.slide_id == slide_id).FirstOrDefault(); try { update.slide_title = slide_title; if (image != null) { update.slide_image = image; } update.slide_link = link; update.slide_title1 = slide_title1; } catch { }; try { db.SubmitChanges(); return(true); } catch { return(false); } }
protected void btnXoa_Click(object sender, EventArgs e) { cls_Slide cls; List <object> selectedKey = grvList.GetSelectedFieldValues(new string[] { "slide_id" }); if (selectedKey.Count > 0) { foreach (var item in selectedKey) { cls = new cls_Slide(); tbSlide checkImage = (from i in db.tbSlides where i.slide_id == Convert.ToInt32(item) select i).SingleOrDefault(); if (cls.Linq_Xoa(Convert.ToInt32(item))) { alert.alert_Success(Page, "Xóa thành công", ""); } else { alert.alert_Error(Page, "Xóa thất bại", ""); } } } else { alert.alert_Warning(Page, "Bạn chưa chọn dữ liệu", ""); } }
public bool Linq_Xoa(int slide_id) { tbSlide delete = db.tbSlides.Where(x => x.slide_id == slide_id).FirstOrDefault(); db.tbSlides.DeleteOnSubmit(delete); try { db.SubmitChanges(); return(true); } catch { return(false); } }
public bool Linq_Them(string image, string link, string slide_title, string slide_title1) { tbSlide insert = new tbSlide(); insert.slide_title = slide_title; insert.slide_image = image; insert.slide_date = DateTime.Now; insert.slide_link = link; insert.slide_title1 = slide_title1; insert.hidden = true; db.tbSlides.InsertOnSubmit(insert); try { db.SubmitChanges(); return(true); } catch { return(false); } }