public PersonResponse GetPersonDetails(decimal personId_)
{
PersonResponse personResponse = new PersonResponse();
EH_Person person = new EH_Person();
using (EHContext context = new EHContext())
{
var personDetails = (from p in context.EH_Person
join prm in context.EH_PersonRoleMapping on p.PersonId equals prm.PersonId
where p.PersonId == personId_
select new
{
PersonId = p.PersonId,
PersonName = p.PersonName,
PersonMailID = p.PersonMailID,
UserName = p.UserName,
password = p.Password,
RoleId = prm.RoleId,
Enabled = p.Enabled
}).FirstOrDefault();
person.PersonId = personDetails.PersonId;
person.PersonName = personDetails.PersonName;
person.PersonMailID = personDetails.PersonMailID;
person.UserName = personDetails.UserName;
person.Password = personDetails.password;
person.Enabled = Convert.ToBoolean(personDetails.Enabled);
person.RoleId = personDetails.RoleId ?? 0;
personResponse = new PersonResponse(person, BaseResponse.ResponseStatus.Success);
}
return(personResponse);
}
public PersonResponse PersonEdit(EH_Person person_)
{
PersonResponse personResponse = new PersonResponse();
using (EHContext context = new EHContext())
{
using (DbContextTransaction contextTransaction = context.Database.BeginTransaction())
{
EH_Person person = context.EH_Person.Where(p => p.PersonId == person_.PersonId && p.Deleted == false).FirstOrDefault();
person.PersonName = person_.PersonName;
person.PersonMailID = person_.PersonMailID;
person.UserName = person_.UserName;
person.Password = person_.Password;
person.Enabled = person_.Enabled;
context.SaveChanges();
EH_PersonRoleMapping personRoleMapping = context.EH_PersonRoleMapping.Where(prm => prm.PersonId == person_.PersonId).FirstOrDefault();
personRoleMapping.RoleId = person_.RoleId;
personRoleMapping.Enabled = person_.Enabled;
context.SaveChanges();
contextTransaction.Commit();
}
}
return(personResponse);
}
public MasterResponse GetAllRoles()
{
MasterResponse masterResponse = null;
List <EH_Role> roles = new List <EH_Role>();
using (EHContext context = new EHContext())
{
roles = context.EH_Role.ToList();
}
masterResponse = new MasterResponse(roles, BaseResponse.ResponseStatus.Success);
return(masterResponse);
}
public PersonResponse GetPersonList()
{
PersonResponse personResponse = new PersonResponse();
EH_Person person;
List <EH_Person> personList = new List <EH_Person>();
using (EHContext context = new EHContext())
{
var persons = (from p in context.EH_Person
join prm in context.EH_PersonRoleMapping on p.PersonId equals prm.PersonId
join r in context.EH_Role on prm.RoleId equals r.RoleId
where p.Deleted == false
select new
{
PersonId = p.PersonId,
PersonName = p.PersonName,
PersonMailID = p.PersonMailID,
UserName = p.UserName,
password = p.Password,
RoleName = r.RoleName,
Enabled = p.Enabled
}).ToList();
foreach (var item in persons)
{
person = new EH_Person();
person.PersonId = item.PersonId;
person.PersonName = item.PersonName;
person.PersonMailID = item.PersonMailID;
person.UserName = item.UserName;
person.Enabled = Convert.ToBoolean(item.Enabled);
person.RoleName = item.RoleName;
personList.Add(person);
}
personResponse = new PersonResponse(personList, BaseResponse.ResponseStatus.Success);
}
return(personResponse);
}
public PersonResponse AuthenticateUser(string userName_, string password_)
{
PersonResponse personResponse = new PersonResponse();
EH_Person person = new EH_Person();
using (EHContext context = new EHContext())
{
var personDetails = (from p in context.EH_Person
join prm in context.EH_PersonRoleMapping on p.PersonId equals prm.PersonId
where p.UserName == userName_ && p.Password == password_
select new
{
PersonName = p.PersonName,
PersonMailID = p.PersonMailID,
UserName = p.UserName,
password = p.Password,
RoleId = prm.RoleId,
Enabled = p.Enabled
}).FirstOrDefault();
if (personDetails != null)
{
person.PersonName = personDetails.PersonName;
person.PersonMailID = personDetails.PersonMailID;
person.UserName = personDetails.UserName;
person.Password = personDetails.password;
person.Enabled = Convert.ToBoolean(personDetails.Enabled);
person.RoleId = personDetails.RoleId ?? 0;
}
else
{
person = null;
}
personResponse = new PersonResponse(person, BaseResponse.ResponseStatus.Success);
}
return(personResponse);
}
public PersonResponse PersonAdd(EH_Person person_)
{
decimal personId;
PersonResponse personResponse = new PersonResponse();
using (EHContext context = new EHContext())
{
using (DbContextTransaction contextTransaction = context.Database.BeginTransaction())
{
EH_Person person = new EH_Person()
{
PersonName = person_.PersonName,
PersonMailID = person_.PersonMailID,
UserName = person_.UserName,
Password = person_.Password,
Enabled = true,
Deleted = false
};
context.EH_Person.Add(person);
context.SaveChanges();
personId = person.PersonId;
EH_PersonRoleMapping personRoleMapping = new EH_PersonRoleMapping()
{
PersonId = personId,
RoleId = person_.RoleId,
Enabled = true,
Deleted = false
};
context.EH_PersonRoleMapping.Add(personRoleMapping);
context.SaveChanges();
contextTransaction.Commit();
}
}
return(personResponse);
}
