//-------------------------------------------------------------------------------------------------------------------------- //-------------------------------------------------------------------------------------------------------------------------- //-------------------------------------------------------------------------------------------------------------------------- //_________________________________ User Mangagement ____________________________________________________________________ // check if the user alleready exist public bool addNewInterior(classInterior i) { var newInterior = new InteriorTable { Name = i.name, Description = i.Description, DesignerID = 1, RoomType = i.roomType, Image = i.imge, TotalPrice = i.total, Available = 1, Date = DateTime.Now, FurnitureID = 1, DesignType = i.cateory }; db.InteriorTables.InsertOnSubmit(newInterior); try { db.SubmitChanges(); return(true); }catch (Exception ex) { ex.GetBaseException(); return(false); } }
// Getting Interior from the dataBase public classInterior getInterior(string cat) { if (cat == "") { var interior = (from i in db.InteriorTables orderby i.Date ascending select i).FirstOrDefault(); classInterior geted = new classInterior { name = interior.Name, Description = interior.Description, imge = interior.Image }; return(geted); } else { var interior = (from i in db.InteriorTables where i.DesignType.Equals(cat) orderby i.Date ascending select i).FirstOrDefault(); classInterior geted = new classInterior { name = interior.Name, Description = interior.Description, imge = interior.Image }; return(geted); } }