public int DeleteAttentionIndustryByUserID(string userID) { int count = 0; AttentionIndustryDataContext db = new AttentionIndustryDataContext(); var user = from c in db.AttentionIndustry where c.UserID == userID select c; if (user.Count() > 0) { db.AttentionIndustry.DeleteAllOnSubmit(user); count = db.AttentionIndustry.Where(c => c.UserID == userID).Count(); } return(count); }
public AttentionIndustry GetAttentionIndustry(string UserId) { AttentionIndustryDataContext db = new AttentionIndustryDataContext(); if (db.AttentionIndustry.Count() > 0) { var user = db.AttentionIndustry.Single(c => c.UserID == UserId); return(user); } else { return(null); } }
public IList <AttentionIndustry> GetAttentionIndustry() { AttentionIndustryDataContext db = new AttentionIndustryDataContext(); IEnumerable <AttentionIndustry> attInd = from c in db.AttentionIndustry select c; if (attInd != null) { return(attInd.ToList <AttentionIndustry>()); } else { return(new List <AttentionIndustry>()); } }
public int InsertAttentionIndustry(AttentionIndustry attInd) { AttentionIndustryDataContext db = new AttentionIndustryDataContext(); try { db.AttentionIndustry.InsertOnSubmit(attInd); db.SubmitChanges(); return(int.Parse(attInd.UserID.ToString())); } catch { return(0); } }
public int UpdateAttentionIndustryfoByUserID(AttentionIndustry attInd) { AttentionIndustryDataContext db = new AttentionIndustryDataContext(); try { var result = (from item in db.AttentionIndustry where item.UserID == attInd.UserID select item).Single(); result.IndMark1 = attInd.IndMark1; result.IndMark2 = attInd.IndMark2; result.IndMark3 = attInd.IndMark3; db.SubmitChanges(); return(int.Parse(result.UserID.ToString())); } catch { return(0); } }