public void ResetID(string entity, long id)
{
try
{
AttendanceDataContext dc = AttendanceDataContextFactory.Createattendance(_ConnStr);
IntegerID ii = dc.GetTable <IntegerID>().SingleOrDefault(item => item.Entity == entity);
if (ii == null)
{
ii = new IntegerID()
{
Entity = entity, Value = id
};
dc.GetTable <IntegerID>().InsertOnSubmit(ii);
dc.SubmitChanges();
}
else
{
ii.Value = id;
dc.SubmitChanges();
}
}
catch (Exception ex)
{
LJH.GeneralLibrary.ExceptionHandling.ExceptionPolicy.HandleException(ex);
}
}
public long?CreateID(string entity)
{
long?id = null;
AttendanceDataContext dc = AttendanceDataContextFactory.Createattendance(_ConnStr);
IntegerID ii = dc.GetTable <IntegerID>().SingleOrDefault(item => item.Entity == entity);
if (ii == null)
{
ii = new IntegerID()
{
Entity = entity, Value = 2
};
dc.GetTable <IntegerID>().InsertOnSubmit(ii);
dc.SubmitChanges();
id = 1;
}
else
{
id = ii.Value;
ii.Value += 1;
dc.SubmitChanges();
}
return(id);
}
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);
}
