public bool UpdateOffence(OffenceEntity offenceEntity)
{
bool result = false;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_OffenceUpdate");
db.AddInParameter(dbCommand, "@OffenceTypeId", DbType.Guid, offenceEntity.OffenceTypeId);
db.AddInParameter(dbCommand, "@Offence", DbType.String, offenceEntity.Offence);
db.AddInParameter(dbCommand, "@UpdatedBy", DbType.Guid, offenceEntity.UpdatedBy);
db.ExecuteNonQuery(dbCommand);
result = true;
return result;
}
public Guid InsertOffence(OffenceEntity offenceEntity)
{
Guid result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_OffenceInsert");
db.AddInParameter(dbCommand, "@Offence", DbType.String, offenceEntity.Offence);
db.AddInParameter(dbCommand, "@CreatedBy", DbType.Guid, offenceEntity.CreatedBy);
db.AddOutParameter(dbCommand, "@OffenceTypeId", DbType.Guid, 30);
db.ExecuteNonQuery(dbCommand);
result = new Guid(db.GetParameterValue(dbCommand, "@OffenceTypeId").ToString());
return result;
}
public bool UpdateOffence(OffenceEntity offenceEntity)
{
return offenceDao.UpdateOffence(offenceEntity);
}
public Guid InsertOffence(OffenceEntity offenceEntity)
{
return offenceDao.InsertOffence(offenceEntity);
}
