public void Test_releaseslotRepo() { int Resdb; Hpr = new HolderPersonRepository(); int res = Hpr.releaseslot(Hp); HolderDetail holder = new HolderDetail(); List <HolderDetail> list = new List <HolderDetail>(); DateTime thisDay = DateTime.Today; var dateAndTime = DateTime.Now; var date = dateAndTime.Date; using (SMPSEntities123 objectContext = new SMPSEntities123()) { list = objectContext.HolderDetails.Where <HolderDetail>(h => h.EmpNo == Hp.EmpNo && h.SlotReleasedDate == date).ToList(); if (list.Count <= 0) { var affectedRows = objectContext.Database.ExecuteSqlCommand("holderdatainsertion @EmpNo={0},@ParkingSlotNumber={1},@CreatedDate={2},@SlotReleasedDate={3},@AllocationType={4},@OperationType={5}", Hp.EmpNo, Hp.ParkingSlotNumber, date, date, 0, 1); Resdb = affectedRows = true ? 1 : 0; } else { Resdb = 0; } } Assert.AreEqual(res.GetType(), Resdb.GetType()); }
public HolderPerson(IHolderPersonRepository holderPerson) { try { //Storing the object instance. this.Rep = holderPerson; } catch (Exception) { throw; } }