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);
}
