public void Test(string startsWith, string endsWith)
{
ISqlRepository repo = new SqlRepository("sqlDefaultConnection");
var branches = repo.GetAll <Branch>();
var branch = repo.FindAll <Branch>(b => b.Id == 1);
branches = repo.FindAll <Branch>(b => b.Address2.EndsWith(endsWith) && b.Name == "البيداء");
branches = repo.FindAll <Branch>(b => b.Address2.StartsWith(startsWith));
branches = repo.FindAll <Branch>(b => b.Address2 == null);
}
public void Test()
{
ISqlRepository repo = new SqlRepository("sqlDefaultConnection");
var branches = repo.GetAll <Branch>();
var branch = repo.FindAll <Branch>(b => b.Id == 1);
branches = repo.FindAll <Branch>(b => b.Address2.EndsWith("Munawwarah") && b.Name == "البيداء");
branches = repo.FindAll <Branch>(b => b.Address2.StartsWith("Al Madina"));
branches = repo.FindAll <Branch>(b => b.Address2 == null);
var bs = new List <Branch>();
}
public void it_executes_operations_on_repository()
{
Database.SetInitializer(new DropCreateDatabaseAlways <EmployeeDb>());
using IRepository <Employee> employeeRepository = new SqlRepository <Employee>(new EmployeeDb());
AddEmployee(employeeRepository);
CountEmployees(employeeRepository);
QueryEmployees(employeeRepository);
DumpPeople(employeeRepository);
AddManagers(employeeRepository);
IEnumerable <Person> temp = employeeRepository.FindAll();
}
public string ReceiveMessages(string chatRoomId, string userId)
{
IRepository<Message> messagesRepository = new SqlRepository<Message>(_dataContext);
IRepository<User> userRepository = new SqlRepository<User>(_dataContext);
string str = "";
var user = userRepository.FindOne(u => u.Id == Convert.ToInt16(userId));
List<Message> messages =
messagesRepository.FindAll(
m => m.Date > user.TimeLogIn - new TimeSpan(0, 1, 0) && m.RoomId == Convert.ToInt16(chatRoomId)).
ToList();
for (int i = 0; i < messages.Count(); i++)
{
var userName = userRepository.FindOne(u => u.Id == messages[i].UserId);
str += string.Format("{0}:{1}:{2} <{3}>: {4} \n\r", messages[i].Date.Hour, messages[i].Date.Minute,messages[i].Date.Second, userName.Name, messages[i].Text);
}
return str;
}
internal virtual IQueryable <T> Get()
{
return(Repository.FindAll());
}
