public static bool SaveAboutus(tbl_AboutUs _AboutUs) { bool _result = true; using (PortfolioDBEntities db = new PortfolioDBEntities()) { try { if (_AboutUs.AboutUs_id == 0) { db.tbl_AboutUs.Add(_AboutUs); } else { db.tbl_AboutUs.Attach(_AboutUs); db.Entry(_AboutUs).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } catch (Exception) { _result = false; } } return(_result); }
public static tbl_User Login(string username, string password) { using (PortfolioDBEntities db = new PortfolioDBEntities()) { return(db.tbl_User.Where(a => a.Username == username && a.UserPassword == password).SingleOrDefault()); } }
public static bool SaveExperienceDetail(tbl_Experiences _Experience) { bool _result = true; using (PortfolioDBEntities db = new PortfolioDBEntities()) { try { if (_Experience.Experience_id == 0) { _Experience.User_id = 1; db.tbl_Experiences.Add(_Experience); } else { db.tbl_Experiences.Attach(_Experience); db.Entry(_Experience).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } catch (Exception) { _result = true; } } return(_result); }
public static tbl_Experiences get_experience(int?id) { using (PortfolioDBEntities db = new PortfolioDBEntities()) { return(db.tbl_Experiences.Where(a => a.Experience_id == id).SingleOrDefault()); } }
public static List <tbl_Experiences> get_all_experience() { using (PortfolioDBEntities db = new PortfolioDBEntities()) { return(db.tbl_Experiences.ToList()); } }
public static List <tbl_Educations> get_education() { using (PortfolioDBEntities db = new PortfolioDBEntities()) { return(db.tbl_Educations.ToList()); } }
public static tbl_AboutUs get_aboutus(int?id) { using (PortfolioDBEntities db = new PortfolioDBEntities()) { return(db.tbl_AboutUs.Where(a => a.AboutUs_id == id).SingleOrDefault()); } }
public static tbl_Profile get_profile(int?id) { using (PortfolioDBEntities db = new PortfolioDBEntities()) { return(db.tbl_Profile.Where(a => a.User_id == id).SingleOrDefault()); } }