public bool INSERT(FuelCar_Object obj) { obj.FuelID = Guid.NewGuid(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_FuelCar_INSERT(obj.FuelID, obj.FuelName); return(true); }
public bool INSERT(CompanyCar_Object obj) { obj.CompanyID = Guid.NewGuid(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_CompanyCar_INSERT(obj.CompanyID, obj.CompanyName, obj.Status, obj.Description); return(true); }
public bool INSERT(WheelDrive_Object obj) { obj.WheelDriveId = Guid.NewGuid(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_WheelDrive_INSERT(obj.WheelDriveId, obj.WheelDriveName); return(true); }
public List <AccountObject> GetAll() { var list = new CarOnlineEntities().WEB_CARONLINE_SP_Account_GetAll().ToList(); List <AccountObject> lst = new List <AccountObject>(); foreach (var item in list) { AccountObject obj = new AccountObject(); obj.AccountID = item.AccountID; obj.ID_Facebook = item.ID_Facebook; obj.ID_Gmail = item.ID_Gmail; obj.UserName = item.UserName; obj.Password = item.Password; obj.Avatar = item.Avatar; obj.FullName = item.FullName; obj.RoleID = item.RoleID.GetValueOrDefault(); obj.NumberOfLikeProfile = item.NumberOfLikeProfile.GetValueOrDefault(); obj.NumberOfPost = item.NumberOfPost.GetValueOrDefault(); obj.NumberOfFlow = item.NumberOfFlow.GetValueOrDefault(); obj.NumberOfComment = item.NumberOfComment.GetValueOrDefault(); obj.Mobile = item.Mobile; obj.Active = (bool)item.Active; obj.BirthDay = item.BirthDay.GetValueOrDefault(); obj.JoinDay = item.JoinDay.GetValueOrDefault(); obj.Email = item.Email; obj.Address = item.Address; obj.IsDeleted = item.IsDeleted.GetValueOrDefault(false); obj.RoleObj = new RoleDao().GetById(obj.RoleID); lst.Add(obj); } return(lst); }
public bool INSERT(GearCar_Object obj) { obj.CarGearId = Guid.NewGuid(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_GearCar_INSERT(obj.CarGearId, obj.CarGearName); return(true); }
public bool INSERT(DesignCar_Object obj) { obj.DesignId = Guid.NewGuid(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_DesignCar_INSERT(obj.DesignId, obj.DesignName); return(true); }
public static AccountObject CheckGoogleId(string sGoogleId) { using (var db = new CarOnlineEntities()) { var item = db.WEB_CARONLINE_SP_Account_GetByGmailId(sGoogleId).FirstOrDefault(); return(item != null ? new AccountObject { AccountID = item.AccountID, ID_Facebook = item.ID_Facebook, ID_Gmail = item.ID_Gmail, UserName = item.UserName, Password = item.Password, Avatar = item.Avatar, FullName = item.FullName, NumberOfLikeProfile = item.NumberOfLikeProfile.GetValueOrDefault(), NumberOfPost = item.NumberOfPost.GetValueOrDefault(), NumberOfFlow = item.NumberOfFlow.GetValueOrDefault(), NumberOfComment = item.NumberOfComment.GetValueOrDefault(), Mobile = item.Mobile, Active = item.Active.GetValueOrDefault(), BirthDay = item.BirthDay.GetValueOrDefault(), JoinDay = item.JoinDay.GetValueOrDefault(), Email = item.Email, Address = item.Address } : null); } }
public bool INSERT(ExteriorFurnitureColor_Object obj) { obj.ExteriorFurnitureColorID = Guid.NewGuid(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_ExteriorFurnitureColor_INSERT(obj.ExteriorFurnitureColorID, obj.ExteriorFurnitureColorName); return(true); }
public AccountObject CheckUsername(string username) { var list = new CarOnlineEntities().WEB_CARONLINE_SP_Account_CheckUserName(username); foreach (var item in list) { AccountObject obj = new AccountObject(); obj.AccountID = item.AccountID; obj.ID_Facebook = item.ID_Facebook; obj.ID_Gmail = item.ID_Gmail; obj.RoleID = (byte)item.RoleID; obj.UserName = item.UserName; obj.Password = item.Password; obj.Avatar = item.Avatar; obj.FullName = item.FullName; obj.NumberOfLikeProfile = item.NumberOfLikeProfile.GetValueOrDefault(); obj.NumberOfPost = item.NumberOfPost.GetValueOrDefault(); obj.NumberOfFlow = item.NumberOfFlow.GetValueOrDefault(); obj.NumberOfComment = item.NumberOfComment.GetValueOrDefault(); obj.Mobile = item.Mobile; obj.Active = (bool)item.Active; obj.BirthDay = item.BirthDay.GetValueOrDefault(); obj.JoinDay = item.JoinDay.GetValueOrDefault(); obj.Email = item.Email; obj.Address = item.Address; obj.IsDeleted = item.IsDeleted.GetValueOrDefault(); return(obj); } return(null); }
public bool INSERT(CarStatus_Object obj) { obj.CarStatusID = Guid.NewGuid(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_CarStatus_INSERT(obj.CarStatusID, obj.CarStatusName); return(true); }
public List <Comment_Object> GetByPostId(Guid?postId) { using (var db = new CarOnlineEntities()) { var data = db.WEB_CARONLINE_SP_Comment_GetByPostId(postId); var list = new List <Comment_Object>(); foreach (var item in data) { Comment_Object obj = new Comment_Object(); obj.CommentId = item.CommentId; obj.ContentComment = item.ContentComment; obj.CreateDate = item.CreateDate; obj.PostId = item.PostId; obj.TotalOfLike = item.TotalOfLike; obj.UserCreateCommnet = new AccountObject { Avatar = item.Avatar, FullName = item.FullName, Mobile = item.Mobile }; list.Add(obj); } return(list); } }
public List <TypeOfCar_Object> GetAll2() { List <TypeOfCar_Object> lit = new List <TypeOfCar_Object>(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_TypeOfCar_GetAll2(); foreach (var item in da) { TypeOfCar_Object obj = new TypeOfCar_Object(); obj.TypeOfCarID = item.TypeOfCarID; obj.TypeName = item.TypeName; obj.Status = item.Status; obj.Description = item.Description; obj.IsDeleted = item.IsDeleted; obj.DesignCarObject = new DesignCar_Object { DesignName = item.DesignName }; obj.CompanyCarObject = new CompanyCar_Object { CompanyName = item.CompanyName }; lit.Add(obj); } return(lit); }
public bool Delete(Guid id) { using (var db = new CarOnlineEntities()) { var result = db.WEB_CARONLINE_SP_UtilitiesCategory_Delete(id); return(result > 0); } }
public static bool CheckMail(string sEmail) { using (var db = new CarOnlineEntities()) { var obj = db.WEB_CARONLINE_SP_Account_GetByEmail(sEmail).FirstOrDefault(); return(obj != null); } }
public int CountComment(Guid PostID) { using (var db = new CarOnlineEntities()) { int count = (int)db.WEB_CARONLINE_SP_CountComment(PostID).First(); return(count); } }
public bool Delete(Guid id) { using (var db = new CarOnlineEntities()) { var result = db.WEB_CARONLINE_SP_DigitalDetail_Delete(id); return(result > 0); } }
public List <PostObject> GetByDateCreate_Paging(int pageIndex, int pageSize, int?Location) { using (var db = new CarOnlineEntities()) { var data = db.WEB_CARONLINE_SP_Post_GetByDateCreate_Paging(pageIndex, pageSize, Location).ToList(); var list = new List <PostObject>(); list.AddRange(data.Select(item => new PostObject { AccountID = item.AccountID, CarCode = item.Carcode, CarPrice = item.CarPrice, CarStatusID = item.CarStatusID, KmWent = item.KmWent, LastContactDay = item.LastContactDay, MadeInId = item.MadeInId, Note = item.Note, PostContent = item.PostContent, PostDay = item.PostDay, PostId = item.PostId, PostTitle = item.PostTitle, SaleStatusCarID = item.SaleStatusCarID, TypeOfCarID = item.TypeOfCarID, AccountPostJoin = new AccountObject() { AccountID = item.AccountID.GetValueOrDefault(), Address = item.Address_AccountPostJoin, FullName = item.FullName_AccountPostJoin, }, CarStatusObjectJoin = new CarStatus_Object() { CarStatusID = item.CarStatusID.GetValueOrDefault(), }, MadeInCarObjectJoin = new MadeInCar_Object() { MadeInID = item.MadeInId.GetValueOrDefault(), }, SaleStatusCarObjectJoin = new SaleStatusCarObject() { SaleStatusCarID = item.SaleStatusCarID.GetValueOrDefault(), }, TypeOfCarObjectJoin = new TypeOfCar_Object() { TypeOfCarID = item.TypeOfCarID.GetValueOrDefault() }, ImageObjectFirstShow = new Image_Object { //ImageName = item.ImageName, //ImageAlt = item.ImageAlt, //Rank = item.Rank } })); return(list); } }
public bool InsertOrUpdate(bool opt, UtilitiesCategory_Object utilitiesCategoryObject) { using (var db = new CarOnlineEntities()) { var result = db.WEB_CARONLINE_SP_UtilitiesCategory_InsertOrUpdate(opt, utilitiesCategoryObject.UtilitiesCategoryId, utilitiesCategoryObject.UtilitiesCategoryName); return(result > 0); } }
public bool InsertOrUpdate(bool opt, DigitalCategory_Object digitalCategoryObject) { using (var db = new CarOnlineEntities()) { var result = db.WEB_CARONLINE_SP_DigitalCategory_InsertOrUpdate(opt, digitalCategoryObject.DigitalCategoryId, digitalCategoryObject.DigitalCategoryName); return(result > 0); } }
public bool InsertOrUpdate(bool opt, Comment_Object commentObject) { using (var db = new CarOnlineEntities()) { var result = db.WEB_CARONLINE_SP_Comment_InsertOrUpdate(opt, commentObject.CommentId, commentObject.PostId, commentObject.UserId, commentObject.ContentComment, commentObject.TotalOfLike, commentObject.CreateDate); return(result > 0); } }
public bool InsertOrUpdate(bool opt, DigitalDetail_Object digitalDetailObject) { using (var db = new CarOnlineEntities()) { var result = db.WEB_CARONLINE_SP_DigitalDetail_InsertOrUpdate(opt, digitalDetailObject.DigitalDetailId, digitalDetailObject.PostId, digitalDetailObject.DigitalCategoryId, digitalDetailObject.Applyed, digitalDetailObject.IsDeleted); return(result > 0); } }
public bool InsertOrUpdate(bool opt, UtilitiesDetail_Object utilitiesDetailObject) { using (var db = new CarOnlineEntities()) { var result = db.WEB_CARONLINE_SP_UtilitiesDetail_InsertOrUpdate(opt, utilitiesDetailObject.UtilitiesDetaiId, utilitiesDetailObject.PostId, utilitiesDetailObject.UtilitiesCategoryId, utilitiesDetailObject.Applyed, utilitiesDetailObject.IsDeleted); return(result > 0); } }
public DigitalCategory_Object GetById(Guid id) { using (var db = new CarOnlineEntities()) { var obj = db.WEB_CARONLINE_SP_DigitalCategory_GetById(id).FirstOrDefault(); return(obj != null ? new DigitalCategory_Object { DigitalCategoryId = obj.DigitalCategoryID, DigitalCategoryName = obj.DigitalCategoryName } : null); } }
public UtilitiesCategory_Object GetById(Guid id) { using (var db = new CarOnlineEntities()) { var obj = db.WEB_CARONLINE_SP_UtilitiesCategory_GetById(id).FirstOrDefault(); return(obj != null ? new UtilitiesCategory_Object { UtilitiesCategoryId = obj.UtilitiesCategoryId, UtilitiesCategoryName = obj.UtilitiesCategoryName } : null); } }
public CarStatus_Object GetByID(Guid ID) { CarStatus_Object obj = new CarStatus_Object(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_CarStatus_GetByID(ID); foreach (var item in da) { obj.CarStatusID = item.CarStatusID; obj.CarStatusName = item.CarStatusName; obj.IsDeleted = item.IsDeleted; } return(obj); }
public WheelDrive_Object GetByID(Guid ID) { WheelDrive_Object obj = new WheelDrive_Object(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_WheelDrive_GetByID(ID); foreach (var item in da) { obj.WheelDriveId = item.WheelDriveId; obj.WheelDriveName = item.WheelDriveName; obj.IsDeleted = item.IsDeleted; } return(obj); }
public ExteriorFurnitureColor_Object GetByID(Guid ID) { ExteriorFurnitureColor_Object obj = new ExteriorFurnitureColor_Object(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_ExteriorFurnitureColor_GetByID(ID); foreach (var item in da) { obj.ExteriorFurnitureColorID = item.ExteriorFurnitureColorID; obj.ExteriorFurnitureColorName = item.ExteriorFurnitureColorName; obj.IsDeleted = item.IsDeleted; } return(obj); }
public DesignCar_Object GetByID(Guid ID) { DesignCar_Object obj = new DesignCar_Object(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_DesignCar_GetByID(ID); foreach (var item in da) { obj.DesignId = item.DesignId; obj.DesignName = item.DesignName; obj.IsDeleted = item.IsDeleted; } return(obj); }
public GearCar_Object GetByID(Guid ID) { GearCar_Object obj = new GearCar_Object(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_GearCar_GetByID(ID); foreach (var item in da) { obj.CarGearId = item.CarGearId; obj.CarGearName = item.CarGearName; obj.IsDeleted = item.IsDeleted; } return(obj); }
public FuelCar_Object GetByID(Guid ID) { FuelCar_Object obj = new FuelCar_Object(); var da = new CarOnlineEntities().WEB_CARONLINE_SP_FuelCar_GetByID(ID); foreach (var item in da) { obj.FuelID = item.FuelID; obj.FuelName = item.FuelName; obj.IsDeleted = item.IsDeleted; } return(obj); }