public static bool saveBrand(tbl_Marka _Brands) { bool _result = true; using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { try { if (_Brands.Marka_ID == 0) { db.tbl_Marka.Add(_Brands); } else { db.tbl_Marka.Attach(_Brands); db.Entry(_Brands).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } catch (Exception) { _result = false; } } return(_result); }
public static string getfullname(int id) { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_User.Where(a => a.User_ID == id).Select(a => a.User_NameSurname).SingleOrDefault()); } }
//public static bool saveSlide(tbl_slider _Slider) //{ // bool _result = true; // using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) // { // try // { // if (_Slider.Slider_image_ID == 0) // { // db.tbl_slider.Add(_Slider); // } // else // { // db.tbl_slider.Attach(_Slider); // db.Entry(_Slider).State = System.Data.Entity.EntityState.Modified; // } // db.SaveChanges(); // } // catch (Exception) // { // _result = false; // } // } // return _result; //} public static bool saveSlide(tbl_slider _Slider) { bool _result = true; using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { try { if (_Slider.Slider_image_ID == 0) { db.tbl_slider.Add(_Slider); } else { db.tbl_slider.Attach(_Slider); db.Entry(_Slider).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } catch (Exception) { _result = false; } } return(_result); }
public static List <tbl_AboutUs> get_aboutuslist() { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_AboutUs.ToList()); } }
public static tbl_Contact Get_Contacts(int id) { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_Contact.Where(a => a.Contact_ID == id).SingleOrDefault()); } }
//public static tbl_Marka get_Marka(int id) //{ // using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) // { // return db.tbl_Marka.Where(a => a.Marka_ID == id).SingleOrDefault(); // } //} public static string get_aboutus(int id) { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_AboutUs.Where(a => a.Aboutus_ID == id).Select(a => a.AboutUs).SingleOrDefault()); } }
public static List <tbl_Services> get_Services() { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_Services.ToList()); } }
public static List <tbl_Gallery> get_Images() { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_Gallery.ToList()); } }
public static tbl_Marka get_brand(int?id) { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_Marka.Where(a => a.Marka_ID == id).SingleOrDefault()); } }
public static List <tbl_Marka> get_Marka() { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_Marka.ToList()); } }
public static tbl_slider get_slide(int?id) { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_slider.Where(a => a.Slider_image_ID == id).SingleOrDefault()); } }
public static List <tbl_slider> get_Slider() { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { return(db.tbl_slider.ToList()); } }
public static bool saveAboutus(tbl_AboutUs _About) { bool _result = true; using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { try { if (_About.Aboutus_ID == 0) { db.tbl_AboutUs.Add(_About); } else { db.tbl_AboutUs.Attach(_About); db.Entry(_About).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } catch (Exception) { _result = false; } } return(_result); }
public static tbl_User login(string password, string username) { using (seckinkirtasiyeEntities db = new seckinkirtasiyeEntities()) { var user = db.tbl_User.Where(a => a.User_Username == username && a.User_Password == password).SingleOrDefault(); return(user); } }