public QueryResult <TInfo> GetByID(TID id)
{
QueryResult <TInfo> result = null;
try
{
AttendanceDataContext attendance = AttendanceDataContextFactory.Createattendance(ConnectStr);
TInfo info = GetingItemByID(id, attendance);
if (info != null)
{
result = new QueryResult <TInfo>(ResultCode.Successful, successMsg, info);
}
else
{
result = new QueryResult <TInfo>(ResultCode.Fail, string.Empty, info);
}
}
catch (SqlException ex)
{
result = new QueryResult <TInfo>(ResultCodeResolver.GetFromSqlExceptionNumber(ex.Number), ex.Message, null);
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetByID()");
}
catch (Exception ex)
{
result = new QueryResult <TInfo>(ResultCode.Fail, ex.Message, null);
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetByID()");
}
return(result);
}
public CommandResult Insert(TInfo info)
{
CommandResult result;
try
{
AttendanceDataContext attendance = AttendanceDataContextFactory.Createattendance(ConnectStr);
InsertingItem(info, attendance);
attendance.SubmitChanges();
result = new CommandResult(ResultCode.Successful, successMsg);
}
catch (SqlException ex)
{
result = new CommandResult(ResultCodeResolver.GetFromSqlExceptionNumber(ex.Number), ex.Message);
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "Insert()");
}
catch (Exception ex)
{
result = new CommandResult(ResultCode.Fail, ex.Message);
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "Insert()");
}
return(result);
}
public QueryResultList <TInfo> GetItems(SearchCondition search)
{
QueryResultList <TInfo> result;
try
{
AttendanceDataContext attendance = AttendanceDataContextFactory.Createattendance(ConnectStr);
List <TInfo> infoes;
infoes = GetingItems(attendance, search);
result = new QueryResultList <TInfo>(ResultCode.Successful, successMsg, infoes);
}
catch (SqlException ex)
{
result = new QueryResultList <TInfo>(ResultCodeResolver.GetFromSqlExceptionNumber(ex.Number), ex.Message, new List <TInfo>());
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetItems()");
}
catch (Exception ex)
{
result = new QueryResultList <TInfo>(ResultCode.Fail, ex.Message, new List <TInfo>());
ExceptionPolicy.HandleException(ex, this.GetType().Name + "." + "GetItems()");
}
return(result);
}