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)); }