public void deleteLink(int RID) { ebridgeEntities _db = new ebridgeEntities(); RESOURCE_LINK r = _db.RESOURCE_LINK.SingleOrDefault(link => link.RID==RID); if (r != null) { _db.RESOURCE_LINK.Remove(r); _db.SaveChanges(); } else { throw new ApplicationException("Can't find the link"); } }
public void updateLink(int RID, string URL_TEXT, string URL, string ADDTL_TEXT, string ACTIVE, int Rank) { ebridgeEntities _db = new ebridgeEntities(); RESOURCE_LINK r = _db.RESOURCE_LINK.SingleOrDefault(link => link.RID == RID); if (r != null) { r.URL_TEXT=URL_TEXT; r.ADDTL_TEXT=ADDTL_TEXT; r.URL=URL; r.RANK=Rank; r.DATE_TIME=DateTime.Now; _db.SaveChanges(); } else { throw new ApplicationException("Can't find the link"); } }
protected void SendMessage(object sender, EventArgs e) { string DialogBody = CKEditor1.Text.Trim(); if (String.IsNullOrEmpty(DialogBody)) return; ebridgeEntities _db = new ebridgeEntities(); MESSAGE_ALT newMessage = new MESSAGE_ALT(); newMessage.MESSAGE_BODY = HttpUtility.HtmlEncode(DialogBody); newMessage.DATE_TIME = DateTime.Now; if (UserType == "participant") { newMessage.FROM_ID = ParticipantId; } else if (UserType == "counselor") { newMessage.TO_ID = ParticipantId; } _db.MESSAGE_ALT.Add(newMessage); _db.SaveChanges(); getThreadMessages(); }
public void createLink(string URL_TEXT, string URL, string Addtl_Text, int Rank ) { ebridgeEntities _db = new ebridgeEntities(); _db.RESOURCE_LINK.Add( new RESOURCE_LINK { URL_TEXT=URL_TEXT, URL=URL, ADDTL_TEXT=ADDTL_TEXT, RANK=Rank, DATE_TIME=DateTime.Now, SITE_ID="s", CREATED_BY="C001", ACTIVE="True"}); _db.SaveChanges(); }
public static string setHours(string[] hours) { JavaScriptSerializer serial = new JavaScriptSerializer(); string CounselorId= HttpContext.Current.Session["COUNSELOR_ID"] as string; Dictionary<string, string> SchoolInfo = HttpContext.Current.Session["SCHOOL"] as Dictionary<string, string>; if (string.IsNullOrEmpty(CounselorId) || SchoolInfo == null) return "failure"; string _tmp = ""; foreach (string v in hours) { _tmp += v + '|'; } _tmp = _tmp.Substring(0, _tmp.Length - 1); ebridgeEntities _db = new ebridgeEntities(); _db.SITE.Add(new SITE{ DATE_TIME= DateTime.Now, ID=SchoolInfo["code"], HOURS=_tmp}); _db.SaveChanges(); return "success"; }