public DomainEntityUser FindUserForLogin(string username, string password) { DbEntityUser dbEntity = DaoLogin.FindByUsernamePassword(username, password); return((dbEntity == null) ? null : dbEntity.DbEntityToDomainEntity()); }
public static void Update(int id, DbEntityUser dbEntityUser) { string columnsAndValues = $"Dni='{dbEntityUser.Dni}',Name='{dbEntityUser.Name}',Lastname='{dbEntityUser.Lastname}'," + $"BirthDate='{dbEntityUser.BirthDate}',Address='{dbEntityUser.Address}',PhoneNumber='{dbEntityUser.PhoneNumber}'," + $"Email='{dbEntityUser.Email}',Username='******',Password='******',UpdatedBy='{dbEntityUser.UpdatedBy}'"; SqlCommandUpdate <DbEntityUser> .Execute(dbEntityUser, tableName, id, columnsAndValues); }
public static void Create(DbEntityUser dbEntityUser) { string columns = "Dni,Name,Lastname,BirthDate,Address,PhoneNumber,Email,Username,Password,CreatedBy"; string values = $"'{dbEntityUser.Dni}','{dbEntityUser.Name}','{dbEntityUser.Lastname}'," + $"'{dbEntityUser.BirthDate}','{dbEntityUser.Address}','{dbEntityUser.PhoneNumber}'," + $"'{dbEntityUser.Email}','{dbEntityUser.Username}','{dbEntityUser.Password}','{dbEntityUser.CreatedBy}'"; SqlCommandInsert <DbEntityUser> .Execute(dbEntityUser, tableName, columns, values); }
public void Update(int id, DomainEntityUser domainEntity) { DbEntityUser dbEntity = DbEntityUser.DomainEntityToDbEntity(domainEntity); DaoUser.Update(id, dbEntity); }
public void Create(DomainEntityUser domainEntity) { DbEntityUser dbEntity = DbEntityUser.DomainEntityToDbEntity(domainEntity); DaoUser.Create(dbEntity); }