public override bool InsertElement(StudentClasses o)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntities.SP_INSERT_STUDENT_CLASS(o.ClassId, o.StudentId, o.DateStart.ToString(), null, null, null,
null, null, null, o.TotalPrice, o.Price1, o.Price2, o.Price3, o.MustPay, null, null, null, null) > 0);
}
public override bool DeleteElement(Student oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
oEntities.SP_IMIC_Delete_Student(oT.Id);
return(true);
}
public override List <StudentClasses> CheckElementById(object Id)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETHOCPHI_BYSTUDENTID_STUDENT_CLASS(int.Parse("" + Id)).ToList();
List <StudentClasses> olisStudentClasses = new List <StudentClasses>();
Commons oCommons = new Commons();
foreach (var o in oData)
{
StudentClasses oStudentClasses = new StudentClasses();
oStudentClasses.Id = o.Id;
oStudentClasses.ClassId = (int)o.ClassId;
oStudentClasses.ClassName = o.ClassName;
oStudentClasses.DateStart = (DateTime)o.DateStart;
//oStudentClasses.Email = string.IsNullOrEmpty(o.Email) ? ""
// : oCommons.DecryptInfo(o.Email);
//oStudentClasses.FullName = o.FullName;
//oStudentClasses.Mobile = string.IsNullOrEmpty(o.Mobile) ? ""
// : oCommons.DecryptInfo(o.Mobile);
//oStudentClasses.Sex = (int)o.Sex;
//oStudentClasses.sSex = o.sSex;
oStudentClasses.StudentId = (int)o.StudentId;
oStudentClasses.TotalPrice = string.IsNullOrEmpty("" + o.TotalPrice) ? 0 : (int)o.TotalPrice;
oStudentClasses.Price1 = string.IsNullOrEmpty("" + o.Price1) ? 0 : (int)o.Price1;
oStudentClasses.Price2 = string.IsNullOrEmpty("" + o.Price2) ? 0 : (int)o.Price2;
oStudentClasses.Price3 = string.IsNullOrEmpty("" + o.Price3) ? 0 : (int)o.Price3;
oStudentClasses.MustPay = string.IsNullOrEmpty("" + o.MustPay) ? 0 : (int)o.MustPay;
olisStudentClasses.Add(oStudentClasses);
}
return(olisStudentClasses);
}
public RecruitmentInfo GetByID_Rec(int id)
{
RecruitmentInfo oRec = new RecruitmentInfo();
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var data = oEntity.SP_GetByID_RecruitmentInfo(id);
foreach (var item in data)
{
oRec.Avatar = item.Avatar;
oRec.CenterId = item.CenterId;
oRec.Contents = item.Contents;
oRec.DateCreate = item.DateCreate;
oRec.DateEnd = item.DateEnd;
oRec.DateStart = item.DateStart;
oRec.Description = item.Description;
oRec.Id = item.Id;
oRec.ImagePath = item.ImagePath;
oRec.Name = item.Name;
oRec.OrderNumber = item.OrderNumber;
oRec.Request = item.Request;
oRec.Status = item.Status;
}
return(oRec);
}
public override ExpertInfo getElementById(object id)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETELEMENT_BYID_EXPERT_INFO((int)id).ToList();
ExpertInfo oExpertInfo = new ExpertInfo();
Commons oCommons = new Commons();
if (oData != null)
{
foreach (var o in oData)
{
if (o.Sex == 1) oExpertInfo.sSex = "Nam"; else oExpertInfo.sSex = "Nữ";
oExpertInfo.Id = o.Id;
oExpertInfo.ExpertName = o.ExpertName;
oExpertInfo.DateBirthday = o.DateBirthday;
oExpertInfo.Email = oCommons.DecryptInfo(o.Email);
oExpertInfo.Mobile = oCommons.DecryptInfo(o.Mobile);
oExpertInfo.Address = o.Address;
oExpertInfo.CenterName = o.CenterName;
oExpertInfo.YearsExperience = o.YearsExperience;
oExpertInfo.UniversityDegree = o.UniversityDegree;
oExpertInfo.CenterId = o.CenterId;
return oExpertInfo;
}
}
return oExpertInfo;
}
public override bool InsertAndUpdate(CommentSupport oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
oEntities.SP_INSERTUPDATE_COMMENTSUPPORT(oT.Flag, oT.Id, oT.CommentName, oT.Desription, oT.UserId, oT.UserName, oT.StudentId, oT.DateCreate);
return(true);
}
public override bool InsertElement(CenterInfo oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Creat_CenterInfo(oT.CenterName, null, oT.Phone, oT.Fax, oT.Address, oT.Website,
oT.Email, oT.Description) > 0 ? true : false);
}
public override List <stanfRole> getElements()
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
List <stanfRole> lstRole = new List <stanfRole>();
var data = oEntities.SP_GETALL_ROLES().ToList();
foreach (var o in data)
{
stanfRole obj = new stanfRole
{
CreatedByOnDate = o.CreatedByOnDate,
CreatedByUserId = o.CreatedByUserId,
Description = o.Description,
IconFile = o.IconFile,
LastModifiedByUserId = o.LastModifiedByUserId,
LastModifiedOnDate = o.LastModifiedOnDate,
OrderNumber = o.OrderNumber,
RoleGroupId = o.RoleGroupId,
RoleId = o.RoleId,
RoleName = o.RoleName
};
lstRole.Add(obj);
}
return(lstRole);
}
public override List <RecruitmentInfo> getElements()
{
List <RecruitmentInfo> lstRec = new List <RecruitmentInfo>();
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
var lst = oEntity.SP_GetAll_Recruitment();
foreach (var item in lst)
{
RecruitmentInfo oRec = new RecruitmentInfo();
oRec.Avatar = item.Avatar;
oRec.CenterId = item.CenterId;
oRec.Contents = item.Contents;
oRec.DateCreate = item.DateCreate;
oRec.DateEnd = item.DateEnd;
oRec.DateStart = item.DateStart;
oRec.Description = item.Description;
oRec.Id = item.Id;
oRec.ImagePath = item.ImagePath;
oRec.Name = item.Name;
oRec.Number = item.Number;
oRec.OrderNumber = item.OrderNumber;
oRec.Request = item.Request;
oRec.Status = item.Status;
lstRec.Add(oRec);
}
return(lstRec);
}
public override bool DeleteElement(CommentSupport oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
oEntities.SP_DELETE_COMMENT_SUPPORT(oT.Id);
return(true);
}
public override bool InsertElement(StudentListsTempSelected oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
oEntities.SP_IMIC_Insert_Student_Of_Classes(oT.ClassId, oT.StudentId, oT.Description);
return(true);
}
public override bool InsertElement(JobTitle oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Creat_JobTitle(oT.JobTitle1, oT.Description, oT.ImageName, oT.ImagePath, oT.OrderNumber)
> 0?true:false);
}
public override bool InsertElement(Ou oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Creat_PhongBan(oT.OuName, oT.ImagePath, oT.Description, oT.Email, oT.Phone, oT.Fax, oT.Website)
> 0?true:false);
}
public override List <StudentLists> getElements()
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_HienThi_DanhSach_HocVien_By03Month().ToList();
List <StudentLists> lisStudent = new List <StudentLists>();
Commons oCommons = new Commons();
foreach (var o in oData)
{
StudentLists oStudentLists = new StudentLists();
oStudentLists.Id = o.Id;
oStudentLists.FullName = o.FullName;
oStudentLists.SexString = o.SexString;
oStudentLists.Sex = o.sex;
oStudentLists.Mobile = string.IsNullOrEmpty(o.Mobile) ? "" : o.Mobile /*oCommons.DecryptInfo(o.Mobile)*/;
oStudentLists.DateBirthday = o.DateBirthday;
oStudentLists.Email = string.IsNullOrEmpty(o.Email) ? "" : o.Email /*oCommons.DecryptInfo(o.Email)*/;
oStudentLists.Address = o.Address;
oStudentLists.DateBirthday = o.DateBirthday;
oStudentLists.UserId = o.UserId;
oStudentLists.UserName = o.UserName;
oStudentLists.CourseId = o.courseid;
oStudentLists.CourseName = o.CourseName;
oStudentLists.StatusId = o.StatusId;
oStudentLists.StatusName = o.StatusName;
oStudentLists.Description = o.Description;
oStudentLists.DateCreate = (DateTime)o.DateCreate;
lisStudent.Add(oStudentLists);
}
return(lisStudent.Count <= 0 ? null : lisStudent);
}
public override List<ExpertInfo> getElements()
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETALL_EXPERT_INFO().ToList();
List<ExpertInfo> oLisExpertInfo = new List<ExpertInfo>();
if (oData != null)
{
foreach (var o in oData)
{
string sTemp;
if (o.Sex == 1) sTemp = "Nam"; else sTemp = "Nữ";
ExpertInfo oExpertInfo = new ExpertInfo
{
Id = o.Id,
ExpertName = o.ExpertName,
DateBirthday = o.DateBirthday,
Email = new Commons().DecryptInfo(o.Email),
Mobile = new Commons().DecryptInfo(o.Mobile),
Address = o.Address,
CenterName = o.CenterName,
YearsExperience = o.YearsExperience,
UniversityDegree = o.UniversityDegree,
sSex = sTemp
};
oLisExpertInfo.Add(oExpertInfo);
}
}
return oLisExpertInfo;
}
public override bool InsertAndUpdate(Classes oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
oEntities.SP_Insert_And_Update_Class(oT.Id, oT.ClassName, oT.FromDate, oT.ToDate, oT.PlaceTraining, oT.NumberStudents, oT.Description, oT.Status);
return(true);
}
public override bool UpdateElement(Classes oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
oEntities.SP_UPDATE_EXPERT_CLASSES(oT.Id, oT.ExpertId);
return(true);
}
public override List <Account> getElements()
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
List <Account> lstAcc = new List <Account>();
var Data = oEntities.SP_GETALL_USER().ToList();
foreach (var o in Data)
{
Account oUser = new Account
{
UserId = o.UserId,
UserName = o.UserName,
Password = o.Password,
Email = o.Email,
DisplayName = o.DisplayName,
IsSuperUser = o.IsSuperUser,
Sex = o.Sex,
Phone = o.Phone,
isAdmin = o.isAdmin
};
if (oUser.Sex == 0)
{
oUser.DisplaySex = "Nam";
}
else
if (oUser.Sex == 1)
{
oUser.DisplaySex = "Nữ";
}
lstAcc.Add(oUser);
}
return(lstAcc);
}
public override Account getElementById(object id)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_GETELEMENTBYID_USER((int)id).ToList();
foreach (var o in oData)
{
Account oUser = new Account
{
UserId = o.UserId,
UserName = o.UserName,
Password = o.Password,
Email = o.Email,
DisplayName = o.DisplayName,
IsSuperUser = o.IsSuperUser,
Sex = o.Sex,
Phone = o.Phone
};
if (oUser.Sex == 0)
{
oUser.DisplaySex = "Nam";
}
else
if (oUser.Sex == 1)
{
oUser.DisplaySex = "Nữ";
}
return(oUser);
}
return(null);
}
public override List <Account> CheckElementByObject(Account oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_CHECK_LOGIN(oT.UserName, oT.Password).ToList();
List <Account> lisUser = new List <Account>();
foreach (var o in oData)
{
Account oUser = new Account
{
UserId = o.UserId,
UserName = o.UserName,
Password = o.Password,
Email = o.Email,
DisplayName = o.DisplayName,
IsSuperUser = o.IsSuperUser,
Sex = o.Sex,
Phone = o.Phone,
isSuccess = true,
isAdmin = o.isAdmin
};
if (oUser.Sex == 0)
{
oUser.DisplaySex = "Nam";
}
else
if (oUser.Sex == 1)
{
oUser.DisplaySex = "Nữ";
}
lisUser.Add(oUser);
break;
}
return(lisUser.Count <= 0 ? null : lisUser);
}
public override List <ListStudents> CheckElementById(object Id)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
var oData = oEntities.SP_IMIC_Get_List_Student_Of_Classes(int.Parse("" + Id)).ToList();
List <ListStudents> lisTemp = new List <ListStudents>();
if (oData != null)
{
Commons oComs = new Commons();
foreach (var o in oData)
{
ListStudents oListStudents = new ListStudents
{
Id = o.Id,
Email = o.Email,
Mobile = o.Mobile,
ClassName = o.ClassName,
FullName = o.FullName,
//ExpertName =
};
lisTemp.Add(oListStudents);
}
}
return(lisTemp);
}
public override List <stanfTabPermission> CheckElementById(object Id)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
List <stanfTabPermission> lstTabPermission = new List <stanfTabPermission>();
var data = oEntity.SP_GETELEMENT_BYUSERID_TABPERMISSION((int)Id).ToList();
foreach (var o in data)
{
stanfTabPermission objTabPermission = new stanfTabPermission
{
CreatedByUserId = o.CreatedByUserId,
PermissionId = o.PermissionId,
CreatedOnDate = o.CreatedOnDate,
DisplayRoleName = o.RoleName,
IsAdd = o.IsAdd,
IsDelete = o.IsDelete,
IsEdit = o.IsEdit,
IsList = o.IsList,
IsReport = o.IsReport,
LastModifiedByUserId = o.LastModifiedByUserId,
LastModifiedOnDate = o.LastModifiedOnDate,
PermissionList = o.PermissionList,
RoleId = o.RoleId,
TabPermissionId = o.TabPermissionId,
UserId = o.UserId
};
lstTabPermission.Add(objTabPermission);
}
return(lstTabPermission);
}
/// <summary>
/// Thiết lập thông tin cho Entity FrameWorks
/// </summary>
/// <returns></returns>
public TrainingCenterEntities getTrainingCenterInfo()
{
string providerName = "System.Data.SqlClient";
ConnectionEntity objEntity = getConnEntityInfo();
SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
sqlBuilder.DataSource = objEntity.serverName;
sqlBuilder.InitialCatalog = objEntity.databaseName;
sqlBuilder.UserID = objEntity.userName;
sqlBuilder.Password = objEntity.password;
sqlBuilder.MultipleActiveResultSets = true;
string providerString = sqlBuilder.ToString();
EntityConnectionStringBuilder objEcsb = new EntityConnectionStringBuilder();
objEcsb.Provider = providerName;
objEcsb.ProviderConnectionString = providerString;
objEcsb.Metadata = @"res://*/CMSModels.csdl|res://*/CMSModels.ssdl|res://*/CMSModels.msl";
EntityConnection objConnection = new EntityConnection(objEcsb.ToString());
TrainingCenterEntities objTraining = new TrainingCenterEntities(objEcsb.ToString());
return(objTraining);
}
public static TrainingCenterEntities getTrainingCenter(Account oAccount)
{
Commons objCommon = new Commons(oAccount);
TrainingCenterEntities objTraining = objCommon.getTrainingCenterInfo();
return(objTraining);
}
public override bool InsertAndUpdate(Employee oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Update_Employee(oT.Id, oT.EmployeeName, oT.Sex, oT.DateBirhday, oT.Mobile, oT.Phone, oT.Email, oT.UniversityName, oT.Address
, oT.IdentityNumber, oT.DateOfIssue, oT.PlaceOfIssue, oT.PlaceBirthday, oT.PersonalTaxCode, oT.Description, null, oT.DateCreate, oT.DateRegister, oT.JobTitleId,
oT.CenterId, oT.OuId, oT.EmployeeCV) > 0?true:false);
}
public override bool InsertElement(Account oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntities.SP_INSERT_USER(oT.UserName, null, null, oT.IsSuperUser, oT.Phone
, oT.Email, oT.DisplayName, oT.Password, null, null, false, mAcount.UserId, null
, null, null, null, null, null, oT.Sex, null, null, oT.isAdmin) > 0);
}
public override bool InsertAndUpdate(RecruitmentInfo oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Update_Recruitment(oT.Id, oT.Name, oT.Description, oT.Contents, DateTime.Now, oT.DateStart,
oT.DateEnd, oT.Number, oT.Request, oT.CenterId, oT.OrderNumber, oT.Avatar, oT.ImagePath, oT.Status) > 0 ?
true : false);
}
public override bool InsertElement(OfflineStudentRegisters oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
oEntities.SP_IMIC_Insert_StudentRegisterOnline("" + oT.RegisterDetailId, oT.FullName,
oT.Email, oT.Phone, oT.Address, oT.Message, oT.CreatedTime, oT.UserName, oT.UpdateDateTime);
return(true);
}
public override bool InsertAndUpdate(Candidate oT)
{
TrainingCenterEntities oEntity = ConnectionEntities.getTrainingCenter(mAcount);
return(oEntity.SP_Update_Candidate(oT.Id, null, null, oT.FullName, oT.DateBirthday, oT.Sex, oT.Address, oT.Description,
oT.YearsExperience, oT.UniversityDegree, oT.CenterId, null, oT.ImagePath, oT.Contents, oT.DocumentPath,
DateTime.Now, DateTime.Now, null, oT.DateSent, oT.Notes, oT.RecruitmentId, null, oT.JobTitleId, null)
> 0 ? true : false);
}
public override bool InsertAndUpdate(ExpertInfo oT)
{
TrainingCenterEntities oEntities = ConnectionEntities.getTrainingCenter(mAcount);
Commons oCommons = new Commons();
if (oT.sSex == "Nam") oT.Sex = 1; else oT.Sex = 0;
oT.Email = oCommons.EncryptInfo(oT.Email);
oT.Mobile = oCommons.EncryptInfo(oT.Mobile);
return oEntities.SP_INSERTUPDATE_EXPERT_INFO(oT.iFlag, oT.Id, oT.ExpertName, oT.DateBirthday, oT.Sex, oT.Address, oT.Description, oT.YearsExperience, oT.UniversityDegree, oT.CenterId, oT.Email, oT.Mobile, oT.ExpertCV) > 0 ? true : false;
}
