private void SaveCustomizeFld(bool FldHideValue, string FldName)
{
using (var db = new SOKNAEntities())
{
//Hide the field
if (FldHideValue)
{
if (!db.PersonHiddenFlds.Any(h => h.FieldName == FldName && h.Person_Id == this.Id))
{
PersonHiddenFlds p = new PersonHiddenFlds();
p.Person_Id = this.Id;
p.FieldName = FldName;
db.PersonHiddenFlds.Add(p);
}
}
//Show the field
else
{
if (db.PersonHiddenFlds.Any(h => h.FieldName == FldName && h.Person_Id == this.Id))
{
var fldHiddenItem = (from h in db.PersonHiddenFlds
where (h.FieldName == FldName && h.Person_Id == this.Id)
select h).First();
if (fldHiddenItem != null)
{
db.PersonHiddenFlds.Remove(fldHiddenItem);
}
}
}
db.SaveChanges();
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.QuestionBank.Add(_QuestionBanks);
db.SaveChanges();
}
}
public static IEnumerable GetArticlesComboList()
{
using (var db = new SOKNAEntities())
{
var Res = db.Articles.Select(r => new { Name = r.Titles, Id = r.Id }).ToList();
return(Res);
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.Articles.Add(_Articles);
db.SaveChanges();
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.RequestQuestionSenario.Add(_RequestQuestionSenario);
db.SaveChanges();
}
}
public static IEnumerable GetEnumsComboList(string EnumType)
{
using (var db = new SOKNAEntities())
{
var Res = db.Enums.Where(r => r.EnumKey == EnumType).OrderBy(enm => enm.Entity_Order).Select(r => new { Name = r.NameL1, Id = r.EnumValue }).ToList();
return(Res);
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.Enums.Add(_Enums);
db.SaveChanges();
}
}
public static IEnumerable GetUsersNamesComboList()
{
using (var db = new SOKNAEntities())
{
var Res = db.Users.Select(r => new { Name = r.Person.FirstOrDefault().FullName, Id = r.Id }).ToList();
return(Res);
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.Nationality.Add(_Nationality);
db.SaveChanges();
}
}
public static IEnumerable GetCategoriesComboList(string CatTyp)
{
using (var db = new SOKNAEntities())
{
var Res = db.Category.Where(r => r.CatType == CatTyp).Select(r => new { Name = r.CategoryName, Id = r.Id }).ToList();
return(Res);
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.Category.Add(_Categories);
db.SaveChanges();
}
}
public static PersonDAL GetPersonPhotoByUserId(int?senderUser_Id)
{
using (var db = new SOKNAEntities())
{
var Res = db.Person.First(r => r.User_Id == senderUser_Id);
return(new PersonDAL(Res.Id));
}
}
public static IEnumerable GetRegisterRequestsComboList()
{
using (var db = new SOKNAEntities())
{
var Res = db.RegisterRequests.Select(r => new { Name = r.Person.FullName, Id = r.Id }).ToList();
return(Res);
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.RegisterRequests.Add(_RegisterRequests);
db.SaveChanges();
}
}
public static IEnumerable GetNationalitysComboList()
{
using (var db = new SOKNAEntities())
{
var Res = db.Nationality.Select(r => new { Name = r.NameL1, Id = r.Id }).ToList().OrderBy(r => r.Name);
return(Res);
}
}
public static IEnumerable GetQuestionsComboList()
{
using (var db = new SOKNAEntities())
{
var Res = db.QuestionBank.Select(r => new { Name = r.Question, Id = r.Id }).ToList();
return(Res);
}
}
public static IEnumerable GetRolePermissionsComboList()
{
using (var db = new SOKNAEntities())
{
var Res = db.RolePermissions.Select(r => new { Name = r.Permissons.NameL1, Id = r.Id }).ToList();
return(Res);
}
}
public static IEnumerable GetChatRoomMessagesComboList()
{
using (var db = new SOKNAEntities())
{
var Res = db.ChatRoomMessage.Select(r => new { Name = r.Message, Id = r.Id }).ToList();
return(Res);
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.RelationRequest.Add(_RelationRequest);
db.SaveChanges();
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.RolePermissions.Add(_RolePermissions);
db.SaveChanges();
}
}
public static IEnumerable GetRelationRequestComboList()
{
using (var db = new SOKNAEntities())
{
var Res = db.RelationRequest.Select(r => new { Name = r.Id, Id = r.Id }).ToList();
return(Res);
}
}
public static IEnumerable GetUsersComboList()
{
using (var db = new SOKNAEntities())
{
var Res = db.Users.Select(r => new { Name = r.UserName, Id = r.Id }).ToList();
return(Res);
}
}
public void Create()
{
using (var db = new SOKNAEntities())
{
db.Users.Add(this._users);
db.SaveChanges();
}
}
public UserDAL(string UserName, string Password)
{
Db = new SOKNAEntities();
var Res = Db.Users.Where(u => u.UserName == UserName && u.UserPassword == Password);
if (Res.Count() > 0)
{
_users = Res.First();
}
}
public static List <QuestionBankDAL> GetQuestionsList()
{
List <QuestionBankDAL> List = new List <QuestionBankDAL>();
using (var db = new SOKNAEntities())
{
var Res = db.QuestionBank.ToList();
Res.ForEach(r => List.Add(new QuestionBankDAL(r)));
}
return(List);
}
public static List <RolePermissionsDAL> GetRolePermissionsListByRolId(int Role_Id)
{
List <RolePermissionsDAL> List = new List <RolePermissionsDAL>();
using (var db = new SOKNAEntities())
{
var Res = db.RolePermissions.Where(x => x.Roles_Id == Role_Id).ToList();
Res.ForEach(r => List.Add(new RolePermissionsDAL(r)));
}
return(List);
}
public static List <RolePermissionsDAL> GetRolePermissionsList()
{
List <RolePermissionsDAL> List = new List <RolePermissionsDAL>();
using (var db = new SOKNAEntities())
{
var Res = db.RolePermissions.ToList();
Res.ForEach(r => List.Add(new RolePermissionsDAL(r)));
}
return(List);
}
public static int GetPersonId(int User_Id)
{
using (var db = new SOKNAEntities())
{
var Res = (from Usr in db.Users
join Per in db.Person on Usr.Id equals Per.User_Id
where Usr.Id == User_Id
select Per.Id).FirstOrDefault();
return(Res);
}
}
public static List <RelationRequestDAL> GetRelationRequestList()
{
List <RelationRequestDAL> List = new List <RelationRequestDAL>();
using (var db = new SOKNAEntities())
{
var Res = db.RelationRequest.ToList();
Res.ForEach(r => List.Add(new RelationRequestDAL(r)));
}
return(List);
}
public static List <UserDAL> GetUsersList()
{
List <UserDAL> List = new List <UserDAL>();
using (var db = new SOKNAEntities())
{
var Res = db.Users.ToList();
Res.ForEach(r => List.Add(new UserDAL(r)));
}
return(List);
}
