protected bool updatePersonGrade(Person person, string toGrade)
{
bool res = true;
try
{
var pdal = new PersonDal();
pdal.Update(new Person
{
PID = person.PID,
Ptel = person.Ptel,
Username = person.Username,
Pname = person.Pname,
Ptime = person.Ptime,
Pgrade = toGrade,
PwechatID = person.PwechatID,
Psex = person.Psex,
Pemail = person.Pemail,
Pcontact = person.Pcontact,
Ppro = person.Ppro,
Pwork_years = person.Pwork_years,
Pjob4u = person.Pjob4u,
Padvs = person.Padvs,
Pact4fire = person.Pact4fire,
Pact4water = person.Pact4water,
Phobbies = person.Phobbies,
Pfield_of_firm = person.Pfield_of_firm
});
}
catch (Exception e) {
res = false;
}
return(res);
}
/// <summary>
/// método lógica de negocio para insertar un persona
/// </summary>
/// <param name="persona"></param>
public static void Insert(Person persona)
{
OperationsLogs.WriteLogsDebug("PersonaBrl", "Insertar", string.Format("{0} Info: {1}",
DateTime.Now.ToString(),
"Empezando a ejecutar el método lógica de negocio para crear un persona"));
try
{
PersonDal.Insertar(persona);
}
catch (SqlException ex)
{
OperationsLogs.WriteLogsRelease("PersonaBrl", "Insertar", string.Format("{0} Error: {1}",
DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message));
throw ex;
}
catch (Exception ex)
{
OperationsLogs.WriteLogsRelease("PersonaBrl", "Insertar", string.Format("{0} Error: {1}",
DateTime.Now.ToString(), DateTime.Now.ToString(), ex.Message));
throw ex;
}
OperationsLogs.WriteLogsDebug("PersonaBrl", "Insertar", string.Format("{0} Info: {1}",
DateTime.Now.ToString(), DateTime.Now.ToString(),
"Termino de ejecutar el método lógica de negocio para insertar persona"));
}
/// <summary>
/// Get person by id Dto
/// </summary>
/// <param name="id">Id person to search</param>
/// <returns>Return object person</returns>
public static PersonDto GetDto(long id, ModelUnibookContainer objContex)
{
PersonDto personDto = null;
try
{
Person person = PersonDal.Get(id, objContex);
personDto = new PersonDto();
personDto.PersonId = person.PersonId;
personDto.Name = person.Name;
personDto.LastName = person.LastName;
personDto.BirthDay = person.Birthday;
personDto.Deleted = person.Deleted;
personDto.Gender = GenderBrl.GetDto(person.Gender.GenderId, objContex);
}
catch (DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(personDto);
}
private void Delete(int id)
{
var dal = new PersonDal();
using (BypassPropertyChecks)
{
dal.DeletePerson(id);
}
}
/// <summary>
/// Gets all.
/// </summary>
/// <returns>
/// All persons from the storage.
/// </returns>
public IEnumerable <PersonDal> GetAll()
{
foreach (Person person in context.Persons)
{
PersonDal temp = person.ToDalPerson();
yield return(temp);
}
}
/// <summary>
/// Deletes the specified DTO.
/// </summary>
/// <param name="dal">The DTO.</param>
/// <exception cref="System.ArgumentException">DTO</exception>
public void Delete(PersonDal dal)
{
if (!people.Contains(dal))
{
throw new ArgumentException($"{nameof(dal)} doesn't contains in the storage");
}
people.Remove(dal);
}
/// <summary>
/// Creates the specified DTO.
/// </summary>
/// <param name="dal">The DTO.</param>
/// <exception cref="System.ArgumentException">DTO</exception>
public void Create(PersonDal dal)
{
if (people.Contains(dal))
{
throw new ArgumentException($"{nameof(dal)} already exist");
}
people.Add(dal);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="objContex"></param>
public static void Delete(int id, PeopleContainer objContex)
{
try
{
PersonDal.Delete(id, objContex);
}
catch (Exception)
{
}
}
/// <summary>
/// Update changes in the context
/// </summary>
/// <param name="objContex"></param>
public static void Update(PeopleContainer objContex)
{
try
{
PersonDal.Update(objContex);
}
catch (Exception)
{
}
}
/// <summary>
/// Partials the map person ORM.
/// </summary>
/// <param name="personDal">The person DAL.</param>
/// <returns>Current ORM person.</returns>
internal static Person PartialMapPersonOrm(this PersonDal personDal)
{
return(new Person
{
Name = personDal.Name,
Surname = personDal.Surname,
Passport = personDal.Passport,
Email = personDal.Email
});
}
/// <summary>
/// Create a new person
/// </summary>
/// <param name="person"></param>
/// <param name="objContex"></param>
public static void Insertar(Person person, PeopleContainer objContex)
{
try
{
PersonDal.Insert(person, objContex);
}
catch (Exception)
{
}
}
/// <summary>
/// Gets the specified identifier.
/// </summary>
/// <param name="passport">The passport.</param>
/// <returns>
/// Current instance of Person.
/// </returns>
/// <exception cref="System.ArgumentException">passport</exception>
public PersonDal Get(string passport)
{
PersonDal result = people.Find(item => item.Passport == passport);
if (ReferenceEquals(result, null))
{
return(null);
}
return(result);
}
/// <summary>
/// Get a person with identifier
/// </summary>
/// <param name="id"></param>
/// <param name="objContex"></param>
/// <returns></returns>
public static Person Get(int id, PeopleContainer objContex)
{
try
{
return(PersonDal.Get(id, objContex));
}
catch (Exception)
{
}
return(null);
}
private void Fetch(int id)
{
var dal = new PersonDal();
var dto = dal.GetPerson(id);
using (BypassPropertyChecks)
{
Id = dto.Id;
FirstName = dto.FirstName;
LastName = dto.LastName;
}
}
public void TestMethod1()
{
AccountDal account = new AccountDal();
account.Insert(new Account {
UserID = Guid.NewGuid(), Username = "******", Password = "******"
});
PersonDal person = new PersonDal();
person.Insert(new Person {
PID = Guid.NewGuid(), Pname = "york", Pgrade = "BoardMember", Padvs = "", Pact4fire = "", Pact4water = "", Pcontact = "", Pemail = "", Pfield_of_firm = "", Phobbies = "", Pjob4u = "", Ppro = "", Psex = "男", Ptel = "135", Ptime = 1234567, PwechatID = "", Pwork_years = 1, Username = "******"
});
}
private void Create()
{
var dal = new PersonDal();
var dto = dal.Create();
using (BypassPropertyChecks)
{
Id = dto.Id;
FirstName = dto.FirstName;
LastName = dto.LastName;
}
BusinessRules.CheckRules();
}
/// <summary>
/// Gets the specified identifier.
/// </summary>
/// <param name="passport">The passport.</param>
/// <returns>
/// Current person.
/// </returns>
/// <exception cref="ArgumentNullException">id</exception>
public PersonDal Get(string passport)
{
Person temp = context.Persons.FirstOrDefault(item => item.Passport == passport);
if (ReferenceEquals(temp, null))
{
return(null);
}
PersonDal result = temp.ToDalPerson();
return(result);
}
protected override void DataPortal_Create()
{
var dal = new PersonDal();
var dto = dal.Create();
using (BypassPropertyChecks)
{
Id = dto.Id;
FirstName = dto.FirstName;
LastName = dto.LastName;
}
BusinessRules.CheckRules();
}
/// <summary>
/// To the BLL person.
/// </summary>
/// <param name="personDal">The personal information.</param>
/// <returns>Equals BLL person.</returns>
public static PersonBll ToBllPerson(this PersonDal personDal)
{
PersonBll temp = new PersonBll(personDal.Name, personDal.Surname, personDal.Passport, personDal.Email);
ObservableCollection <AccountBll> accounts = new ObservableCollection <AccountBll>();
foreach (AccountDal account in personDal.AccountsDal)
{
accounts.Add(account.PartialMapAccountBll());
}
temp.Accounts = accounts;
return(temp);
}
/// <summary>
/// To the DAL person.
/// </summary>
/// <param name="personBll">The person BLL.</param>
/// <returns>Equals DAL person.</returns>
public static PersonDal ToDalPerson(this PersonBll personBll)
{
PersonDal temp = new PersonDal(personBll.Name, personBll.Surname, personBll.Passport, personBll.Email);
ICollection <AccountDal> accounts = new List <AccountDal>();
foreach (AccountBll account in personBll.Accounts)
{
accounts.Add(account.PartialMapAccountDal());
}
temp.AccountsDal = accounts;
return(temp);
}
private void Insert()
{
var dal = new PersonDal();
using (BypassPropertyChecks)
{
var dto = new PersonDto
{
FirstName = this.FirstName,
LastName = this.LastName
};
Id = dal.InsertPerson(dto);
}
}
protected override void DataPortal_Insert()
{
var dal = new PersonDal();
using (BypassPropertyChecks)
{
var dto = new PersonDto
{
FirstName = this.FirstName,
LastName = this.LastName
};
Id = dal.InsertPerson(dto);
}
}
/// <summary>
/// Updates the specified DTO.
/// </summary>
/// <param name="dal">The DTO.</param>
/// <exception cref="System.ArgumentException">DTO</exception>
public void Update(PersonDal dal)
{
PersonDal temp = people.Find(item => item.Id == dal.Id);
if (ReferenceEquals(temp, null))
{
throw new ArgumentException($"{nameof(dal)} doesn't contains in the storage");
}
temp.Name = dal.Name;
temp.Surname = dal.Surname;
temp.Passport = dal.Passport;
temp.Email = dal.Email;
}
protected override void DataPortal_Update()
{
var dal = new PersonDal();
using (BypassPropertyChecks)
{
var dto = new PersonDto
{
Id = this.Id,
FirstName = this.FirstName,
LastName = this.LastName
};
dal.UpdatePerson(dto);
}
}
private void Update()
{
var dal = new PersonDal();
using (BypassPropertyChecks)
{
var dto = new PersonDto
{
Id = this.Id,
FirstName = this.FirstName,
LastName = this.LastName
};
dal.UpdatePerson(dto);
}
}
/// <summary>
/// Deleted a person
/// </summary>
/// <param name="id">Id person to deleted</param>
/// <param name="objContex">Get table to object</param>
public static void Delete(long id, ModelUnibookContainer objContex)
{
try
{
PersonDal.Delete(id, objContex);
}
catch (DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Deletes the specified DAL.
/// </summary>
/// <param name="dal">The DAL.</param>
/// <exception cref="ArgumentNullException">DTO. </exception>
/// <exception cref="ArgumentException">DTO.</exception>
public void Delete(PersonDal dal)
{
if (ReferenceEquals(dal, null))
{
throw new ArgumentNullException($"{nameof(dal)} is null");
}
Person temp = context.Persons.FirstOrDefault(item => item.Id == dal.Id);
if (ReferenceEquals(temp, null))
{
throw new ArgumentException($"{nameof(dal)} doesn't contains in database");
}
context.Persons.Remove(temp);
}
public DaYanService(string username)
{
_persondal = new PersonDal();
_dayandal = new DaYanDal();
var resultp = _persondal.GetEntities(i => i.Username == username);
foreach (var p in resultp)
{
_person = p;
}
var resultd = _dayandal.GetEntities(i => i.PID == _person.PID);
foreach (var d in resultd)
{
_dayan = d;
}
}
/// <summary>
/// Creates the specified DTO.
/// </summary>
/// <param name="dal">The DTO.</param>
/// <exception cref="ArgumentNullException">DAL</exception>
public void Create(PersonDal dal)
{
if (ReferenceEquals(dal, null))
{
throw new ArgumentNullException($"{nameof(dal)} is null");
}
Person temp = new Person()
{
Id = dal.Id,
Name = dal.Name,
Surname = dal.Surname,
Passport = dal.Passport,
Email = dal.Email
};
context.Persons.Add(temp);
}
public ECService(string username)
{
_persondal = new PersonDal();
_ecdal = new XiaoYanDal();
_memdal = new XiaoYanDal();
_account = new AccountDal();
var resultp = _persondal.GetEntities(i => i.Username == username);
foreach (var p in resultp)
{
_person = p;
}
var resulte = _ecdal.GetEntities(i => i.PID == _person.PID);
foreach (var e in resulte)
{
_ec = e;
}
}
