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 int releaseslot(BusinessObjects.Holder1.HolderPerson HLD) { try { return(Rep.releaseslot(HLD)); } catch (Exception) { throw new NotImplementedException(); } }