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