public List <CheckInDto> ReadData(int eventId, string search)
{
string query = "SELECT eventAttendeesID,name,email,other,checked FROM dbo.tblCheckIn WHERE eventID=@id AND name LIKE @search";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", eventId);
cmd.Parameters.AddWithValue("@search", "%" + search + "%");
List <CheckInDto> checkInDtos = new List <CheckInDto>();
try
{
con.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
CheckInDto checkInDto = new CheckInDto();
checkInDto.EventAttendeesID = dataReader.GetInt32(0);
checkInDto.Name = dataReader.GetString(1);
checkInDto.Email = dataReader.GetString(2);
checkInDto.Other = dataReader.GetString(3);
checkInDto.Check = dataReader.GetBoolean(4);
checkInDtos.Add(checkInDto);
}
}
finally
{
con.Close();
}
return(checkInDtos);
}
public void AddCheckInWithExistingPerson()
{
_stubUow.Query <Person>().Returns(info => new List <Person>
{
new Person
{
FirstName = "firstName",
LastName = "lastName",
BirthDate = new DateTime(2017, 7, 19),
Sex = Sex.Female
}
}.AsQueryable());
var checkInDto = new CheckInDto
{
PersonFirstName = "firstName",
PersonLastName = "lastName",
PersonBirthDate = new DateTime(2017, 7, 19),
PersonSex = Sex.Female
};
var checkIn = _checkInService.Add(checkInDto);
Assert.NotEqual(DateTime.MinValue, checkIn.VisitDateTime);
_stubUow.Received().Add(checkIn);
}
public async Task <IActionResult> Post(CheckInDto model)
{
var helper = new Helper(_configuration, _userManager);
var response = helper.VerifyToken(HttpContext);
if (!response.Flagged)
{
return(BadRequest(new { message = response.Message }));
}
if (!model.CheckedIn)
{
return(BadRequest(new { message = "Enter check in value" }));
}
var attendance = new AttendanceModel
{
Id = Guid.NewGuid().ToString(),
CheckedInAt = DateTime.Now,
CheckedOutAt = DateTime.Now,
CheckIn = model.CheckedIn,
OwnerId = response.UserId,
Reason = "no reason",
};
await _attendanceRepository.PostAttendance(attendance);
return(Created("", attendance));
}
public CheckIn Add(CheckInDto checkInDto)
{
using (var transaction = _uow.BeginTransaction())
{
var person = _uow
.Query <Person>()
.SingleOrDefault(p => p.LastName == checkInDto.PersonLastName &&
p.FirstName == checkInDto.PersonFirstName &&
p.BirthDate.Date == checkInDto.PersonBirthDate.Date &&
p.Sex == checkInDto.PersonSex);
if (person == null)
{
person = new Person
{
FirstName = checkInDto.PersonFirstName,
LastName = checkInDto.PersonLastName,
BirthDate = checkInDto.PersonBirthDate,
Sex = checkInDto.PersonSex
}
}
;
var checkIn = new CheckIn {
Person = person, VisitDateTime = DateTime.Now
};
_uow.Add(checkIn);
transaction.Commit();
return(checkIn);
}
}
}
public CheckInDto CheckInByAttendeesID(int eventAttendeesID)
{
SqlCommand cmd = new SqlCommand("SELECT name,email,other,checked FROM tblCheckIn where eventAttendeesID=@eventAttendeesID;", con);
cmd.Parameters.AddWithValue("@eventAttendeesID", eventAttendeesID);
try
{
con.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.Read())
{
CheckInDto checkInDto = new CheckInDto();
checkInDto.EventAttendeesID = eventAttendeesID;
checkInDto.Name = dataReader.GetString(0);
checkInDto.Email = dataReader.GetString(1);
checkInDto.Other = dataReader.GetString(2);
checkInDto.Check = dataReader.GetBoolean(3);
return(checkInDto);
}
}
finally
{
con.Close();
}
return(null);
}
public ActionResult CheckIn(CheckInDto checkInDto)
{
if (ModelState.IsValid)
{
//get the service
//todo use ioc debendency injection here
var service = MyService;
//todo replace this with real authentication and users
checkInDto.UserId = AppUser.Id;
//get the real check in object, and populate the useful field
//var chekcin = Mapper.Map<CheckIn>(checkInDto);
var asset = Mapper.Map <List <Jtext103.BlogSystem.Asset> >(checkInDto.Images);
var chekcin = new Jtext103.OldHouse.Business.Models.CheckIn(new Jtext103.BlogSystem.BasicUser {
Id = checkInDto.UserId
}, checkInDto.TargetId, checkInDto.Titile, checkInDto.Content, asset, HouseService.GetGeoPoint(checkInDto.Lnt + @";" + checkInDto.Lat));
//the house id is redeundent
service.CheckInHouse(chekcin.TargetId, chekcin);
return(RedirectToRoute("HouseDetail", new { id = checkInDto.TargetId, dis = checkInDto.Distance }));
}
else
{
ModelState.AddModelError("", "请一定说点什么吧。");
return(View("NewCheckIn", checkInDto));
}
}
public void AddCheckInWithNewPerson()
{
var checkInDto = new CheckInDto();
var checkIn = _checkInService.Add(checkInDto);
Assert.NotEqual(DateTime.MinValue, checkIn.VisitDateTime);
_stubUow.Received().Add(checkIn);
}
public void CheckIn()
{
BitmapSource srs = (BitmapSource)checkInWindow.ImageSource;
Bitmap bitmap = null;
if (srs != null)
{
using (MemoryStream outStream = new MemoryStream())
{
BitmapEncoder enc = new BmpBitmapEncoder();
enc.Frames.Add(BitmapFrame.Create(srs));
enc.Save(outStream);
bitmap = new Bitmap(outStream);
}
}
try
{
String content = QRModuleLib.QRModule.DecodeFromQRCode(bitmap);
DataEncryption dataEncryption = new DataEncryption(null, content);
content = dataEncryption.InputCode;
if (content == null)
{
checkInWindow.Status = "Waiting....";
}
else
{
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
try
{
int id = int.Parse(content);
CheckInDto checkInDto = checkInDao.CheckInByAttendeesID(id);
if (checkInDto.Check)
{
checkInWindow.Status = "QR code is checked!";
}
else
{
checkInDao.UpdateStatus(id, true);
LoadMemberEvent();
checkInWindow.Status = checkInDto.Name;
}
}
catch
{
checkInWindow.Status = "QR code is not existed!";
}
}
}
catch (NullReferenceException ex)
{
checkInWindow.Status = "Waiting";
}
}
public void AddCheckInWithTransaction()
{
var checkInDto = new CheckInDto();
var stubTransaction = Substitute.For <ITransaction>();
_stubUow.BeginTransaction().Returns(info => stubTransaction);
_checkInService.Add(checkInDto);
_stubUow.Received().BeginTransaction();
stubTransaction.Received().Commit();
}
public CheckIn Update(int id, CheckInDto checkInDto)
{
var checkIn = GetQuery().FirstOrDefault(o => o.Id == id);
if (checkIn == null)
{
throw new NotFoundExpection("Изменяемое посещение не найдено");
}
checkIn.Person.FirstName = checkInDto.PersonFirstName;
checkIn.Person.LastName = checkInDto.PersonLastName;
checkIn.Person.BirthDate = checkInDto.PersonBirthDate.Date;
checkIn.Person.Sex = checkInDto.PersonSex;
_uow.SaveChanges();
return(checkIn);
}
public bool AddEvent()
{
if (addEventWindow.EventName.Length == 0)
{
addEventWindow.Status = "Event name is empty";
return(false);
}
if (addEventWindow.EventName.Length > 50)
{
addEventWindow.Status = "Event name have length lower than 50";
return(false);
}
EventDao eventDao = new EventDao();
eventDao.MakeConnection(Properties.Resources.strConnection);
if (eventDao.Create(new EventDto(addEventWindow.EventName, addEventWindow.Desciption, "", ((App)Application.Current).UserName)))
{
List <CheckBox> groupShowList = (List <CheckBox>)addEventWindow.Group;
int index = 0;
foreach (CheckBox checkBox in groupShowList)
{
if ((bool)checkBox.IsChecked)
{
EventAttendeesDao eventAttendeesDao = new EventAttendeesDao();
List <GroupDto> groupDtos = (List <GroupDto>)addEventWindow.GroupData;
eventAttendeesDao.MakeConnection(Properties.Resources.strConnection);
List <EventAttendeesDto> eventAttendeesDtos = eventAttendeesDao.ReadData(groupDtos[index].Id, "");
foreach (EventAttendeesDto eventAttendeesDto in eventAttendeesDtos)
{
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
CheckInDto checkInDto = new CheckInDto();
checkInDto.EventID = eventDao.GetLastId();
checkInDto.Name = eventAttendeesDto.Name;
checkInDto.Email = eventAttendeesDto.Email;
checkInDto.Other = eventAttendeesDto.Other;
checkInDao.Create(checkInDto);
}
}
index++;
}
}
return(true);
}
public bool Update(CheckInDto dto)
{
SqlCommand cmd = new SqlCommand("Update tblCheckIn set name=@name,email=@email,other=@other where eventAttendeesID=@eventAttendeesID;", con);
cmd.Parameters.AddWithValue("@eventAttendeesID", dto.EventAttendeesID);
cmd.Parameters.AddWithValue("@name", dto.Name);
cmd.Parameters.AddWithValue("@email", dto.Email);
cmd.Parameters.AddWithValue("@other", dto.Other);
int count = 0;
try
{
con.Open();
count = cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
return(count == 1);
}
public bool Create(CheckInDto dto)
{
SqlCommand cmd = new SqlCommand("Insert Into tblCheckIn(name,email,other,eventID,checked) VALUES(@name,@email,@other,@eventID,@checked);", con);
cmd.Parameters.AddWithValue("@name", dto.Name);
cmd.Parameters.AddWithValue("@email", dto.Email);
cmd.Parameters.AddWithValue("@other", dto.Other);
cmd.Parameters.AddWithValue("@eventID", dto.EventID);
cmd.Parameters.AddWithValue("@checked", false);
int count = 0;
try
{
con.Open();
count = cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
return(count == 1);
}
public async Task <IActionResult> AddStockEntry(CheckInDto checkInDto)
{
if (!await _authService.IsPermitted(User, checkInDto.EnvironmentId,
PermissionFlags.IsOwner | PermissionFlags.CanScan))
{
return(Unauthorized());
}
checkInDto.ExpireDate = checkInDto.ExpireDate.AddMinutes(checkInDto.ClientTimezoneOffset);
var entryValues = _mapper.Map <StockEntryValue>(checkInDto);
entryValues.AmountRemaining = 1;
StockEntryValue newEntry = await _repo.AddStockEntry(entryValues, checkInDto.UsualLifetime);
var ret = _mapper.Map <ArticleDto>(newEntry.Article);
await _repo.WriteActivityLog(ActivityLogAction.CheckIn, User, checkInDto.EnvironmentId,
checkInDto.ArticleId, checkInDto.AmountOnStock.ToString());
return(CreatedAtRoute(nameof(LookupArticle),
new { controller = "Articles", barcode = checkInDto.Barcode, environmentId = checkInDto.EnvironmentId }, ret));
}
public ActionResult CheckIn(CheckInDto checkInDto)
{
if (ModelState.IsValid)
{
//get the service
//todo use ioc debendency injection here
var service = MyService;
//todo replace this with real authentication and users
var user = AppUser;
checkInDto.UserId = user.Id;
//get the real check in object, and populate the useful field
var chekcin = Mapper.Map <CheckIn>(checkInDto);
chekcin.CreateTime = DateTime.Now;
//the house id is redeundent
service.CheckInHouse(chekcin.TargetId, chekcin);
return(RedirectToRoute("HouseDetail", new { id = checkInDto.TargetId, dis = checkInDto.Distance }));
}
else
{
ModelState.AddModelError("", "请一定说点什么吧。");
return(View("NewCheckIn", checkInDto));
}
}
public bool AddMemberInEvent()
{
if (detailMemberWindow.DataName.Length == 0)
{
detailMemberWindow.Status = "Member name is empty";
return(false);
}
if (!IsValidEmail(detailMemberWindow.Email))
{
detailMemberWindow.Status = "Email invalidate";
return(false);
}
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
CheckInDto checkInDto = new CheckInDto();
checkInDto.Name = detailMemberWindow.DataName;
checkInDto.Email = detailMemberWindow.Email;
checkInDto.Other = detailMemberWindow.Other;
checkInDto.EventID = detailMemberWindow.Id;
return(checkInDao.Create(checkInDto));
}
public void UpdateCheckIn()
{
_checkIns.Add(new CheckIn
{
Id = 10,
Person = new Person()
});
var checkInDto = new CheckInDto
{
PersonFirstName = "newFirstName",
PersonLastName = "newLastName",
PersonSex = Sex.Female,
PersonBirthDate = new DateTime(2000, 1, 1)
};
var checkIn = _checkInService.Update(10, checkInDto);
Assert.Equal("newFirstName", checkIn.Person.FirstName);
Assert.Equal("newLastName", checkIn.Person.LastName);
Assert.Equal(Sex.Female, checkIn.Person.Sex);
Assert.Equal(new DateTime(2000, 1, 1), checkIn.Person.BirthDate);
_stubUow.Received().SaveChanges();
}
public CheckInDto Post(CheckInDto checkIn)
{
var addedCheckIn = _checkInService.Add(checkIn);
return(_mapper.Map <CheckInDto>(addedCheckIn));
}
public async Task <ActionResult> CheckIn(CheckInDto checkInDto)
{
await hubContext.Clients.All.SendAsync("checkIn", checkInDto);
return(Ok());
}
public CheckInDto Put(int id, [FromBody] CheckInDto checkInDto)
{
var updatedCheckIn = _checkInService.Update(id, checkInDto);
return(_mapper.Map <CheckInDto>(updatedCheckIn));
}
