public Guid InsertCourt(CourtEntity courtEntity)
{
Guid result;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_CourtInsert");
db.AddInParameter(dbCommand, "@Court", DbType.String, courtEntity.Court);
db.AddInParameter(dbCommand, "@CourtTypeId", DbType.Guid, courtEntity.CourtTypeId);
db.AddInParameter(dbCommand, "@PoliceStation", DbType.String, courtEntity.PoliceStation);
db.AddInParameter(dbCommand, "@CreatedBy", DbType.Guid, courtEntity.CreatedBy);
db.AddOutParameter(dbCommand, "@CourtId", DbType.Guid, 30);
db.ExecuteNonQuery(dbCommand);
result = new Guid(db.GetParameterValue(dbCommand, "@CourtId").ToString());
return result;
}
public bool UpdateCourt(CourtEntity courtEntity)
{
bool result = false;
Database db = DatabaseFactory.CreateDatabase(Constant.DiaryDBConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("usp_CourtUpdate");
db.AddInParameter(dbCommand, "@CourtId", DbType.Guid, courtEntity.CourtId);
db.AddInParameter(dbCommand, "@Court", DbType.String, courtEntity.Court);
db.AddInParameter(dbCommand, "@CourtTypeId", DbType.Guid, courtEntity.CourtTypeId);
db.AddInParameter(dbCommand, "@PoliceStation", DbType.String, courtEntity.PoliceStation);
db.AddInParameter(dbCommand, "@UpdatedBy", DbType.Guid, courtEntity.UpdatedBy);
db.ExecuteNonQuery(dbCommand);
result = true;
return result;
}
public bool UpdateCourt(CourtEntity courtEntity)
{
return courtDao.UpdateCourt(courtEntity);
}
public Guid InsertCourt(CourtEntity courtEntity)
{
return courtDao.InsertCourt(courtEntity);
}
