public int releaseslot(HolderPerson HLD)
{
try
{
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 == HLD.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}", HLD.EmpNo, HLD.ParkingSlotNumber, date, date, 0, 1);
return(affectedRows = true ? 1 : 0);
}
else
{
return(0);
}
}
}catch (Exception ex)
{
throw ex;
}
}
public HolderUnitTest()
{
Hp = new HolderPerson()
{
FirstName = "sindhuja", LastName = "rudroju", EmpNo = 519180, MobileNumber = 9948484684, OperationType = 1, ParkingSlotNumber = "2", username = "******", UserType = "Holder"
};
this.container = new WindsorContainer();
this.container.Register(Classes.FromAssemblyNamed("Smps.Infrastructure").Where(type => type.IsPublic).WithService.DefaultInterfaces().LifestyleTransient());
this.container.Register(Classes.FromAssemblyNamed("Smps.core").Where(type => type.IsPublic).WithService.DefaultInterfaces().LifestyleTransient());
}
public int Releaseslot(HolderPerson usr)
{
try
{
return(IHP.releaseslot(usr));
}
catch (NoDataFoundException)
{
//throw the exception
throw;
}
catch (Exception)
{
//throw the exception
throw new NotImplementedException();
}
}
