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 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();
try
{
//WebRequestLogManager objWebRequestLogManager = new WebRequestLogManager();
//decimal requestId = objWebRequestLogManager.AddRequest(string.Format("Project {0}, Page {1}, Method {2}, currentCulture {3}, clientID {4}, statusids {5}, partnertypecodes {6}", "ELSBackendBLL", "masterManager.cs", "GetAllPartners", culture, clientId, statusids, partnertypecodes), 0, CommonFunctions.RequestSource.WEB.ToString());
PersonDB personDB = new PersonDB();
personResponse = personDB.PersonEdit(person_);
//objWebRequestLogManager.AddResponse(masterResponse.Status.ToString(), requestId, 0);
}
//catch (CustomException ex)
//{
// masterResponse = new MasterResponse(ex.ResponseStatus);
//}
catch (Exception ex)
{
//var Error = "Exception : " + ex.Message + ", Inner Exception : " + (ex.InnerException == null ? "" : ex.InnerException.Message);
//ExceptionLogDB.LogException("ELSBAL", "MasterManager.cs", "GetAllRoles", CommonFunctions.RequestSource.WEB.ToString(), Error);
personResponse = new PersonResponse(BaseResponse.ResponseStatus.Error);
}
return(personResponse);
}
public PersonResponse PersonEdit(EH_Person person_)
{
PersonResponse personResponse = new PersonResponse();
PersonManager personManager = new PersonManager();
personResponse = personManager.PersonEdit(person_);
return(personResponse);
}
public ActionResult PersonAdd(PersonModel personModel_)
{
PersonResponse personResponse = new PersonResponse();
PersonHelper personHelper = new PersonHelper();
EH_Person person = new EH_Person();
person.PersonName = personModel_.PersonName;
person.PersonMailID = personModel_.PersonMailID;
person.UserName = personModel_.UserName;
person.Password = personModel_.Password;
person.RoleId = personModel_.RoleId;
personResponse = personHelper.PersonAdd(person);
return(RedirectToAction("PersonAdd"));
}
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);
}
/// <summary>
/// initialize constructor with values
/// </summary>
/// <param name="person_"></param>
/// <param name="responseStatus_"></param>
public PersonResponse(EH_Person person_, ResponseStatus responseStatus_)
: base(responseStatus_)
{
Person = person_;
}
