public TestEmployee Add(TestEmployee item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
// TO DO : Code to save record into database
item.Id = _nextId++;
this._data.Add(item);
return item;
}
public bool Update(TestEmployee item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
// TO DO : Code to update record into database
int index = this._data.FindIndex(p => p.Id == item.Id);
if (index == -1)
{
return false;
}
this._data.RemoveAt(index);
this._data.Add(item);
return true;
}
public static List<TestEmployee> GetEmployees(List<int> ids)
{
List<TestEmployee> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Employees_SelectByIds"
, inputParamMapper: delegate(SqlParameterCollection paramCollection)
{
SqlParameter p = new SqlParameter("@EmployeeIds", System.Data.SqlDbType.Structured);
if (ids != null && ids.Any())
{
p.Value = new Sabio.Data.IntIdTable(ids);
}
paramCollection.Add(p);
}, map: delegate(IDataReader reader, short set)
{
TestEmployee p = new TestEmployee();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetSafeInt32(startingIndex++);
p.LastName = reader.GetSafeString(startingIndex++);
p.FirstName = reader.GetSafeString(startingIndex++);
p.Title = reader.GetSafeString(startingIndex++);
p.Dob = reader.GetSafeDateTime(startingIndex++);
p.Status = reader.GetSafeInt32(startingIndex++);
if (list == null)
{
list = new List<TestEmployee>();
}
list.Add(p);
}
);
return list;
}
internal static List<Domain.Tests.TestEmployee> GetEmployees()
{
List<TestEmployee> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Employees_Select"
, inputParamMapper: null
, map: delegate(IDataReader reader, short set)
{
TestEmployee p = new TestEmployee();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetSafeInt32(startingIndex++);
p.LastName = reader.GetSafeString(startingIndex++);
p.FirstName = reader.GetSafeString(startingIndex++);
p.Title = reader.GetSafeString(startingIndex++);
p.Dob = reader.GetSafeDateTime(startingIndex++);
p.Status = reader.GetSafeInt32(startingIndex++);
if (list == null)
{
list = new List<TestEmployee>();
}
list.Add(p);
}
);
return list;
}
public bool Update(TestEmployee item)
{
throw new NotImplementedException();
}