public IActionResult Post([FromBody] visitor objvisitor)
{
using (var scope = new TransactionScope())
{
_visitorRepository.addVisitor(objvisitor);
scope.Complete();
return(CreatedAtAction(nameof(Get), new { id = objvisitor.visitorID }, objvisitor));
}
}
public ActionResult Edit([Bind(Include = "id,full_name,date_of_birth,phone_number")] visitor visitor)
{
if (ModelState.IsValid)
{
db.Entry(visitor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(visitor));
}
/// <summary>
///
/// </summary>
/// <param name="theVisitor">fm.data.visitor delegate</param>
/// <param name="select_statement">sql statement</param>
public override void for_each_row(visitor theVisitor, string select_statement)
{
DataSet newset = this.select(select_statement);
DataTable result = newset.Tables["Table"];
DataRowCollection rows_ = result.Rows;
for (int j = 0; j < rows_.Count; j++)
{
theVisitor(rows_[j]);
}
}
public ActionResult Create([Bind(Include = "id,full_name,date_of_birth,phone_number")] visitor visitor)
{
if (ModelState.IsValid)
{
db.visitors.Add(visitor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(visitor));
}
public ActionResult Put(int id, [FromBody] visitor objvisitor)
{
if (objvisitor != null)
{
using (var scope = new TransactionScope())
{
_visitorRepository.updateVisitor(objvisitor);
scope.Complete();
return(new OkResult());
}
}
return(new NoContentResult());
}
// GET: visitors/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
visitor visitor = db.visitors.Find(id);
if (visitor == null)
{
return(HttpNotFound());
}
return(View(visitor));
}
public void Save()
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
visitor v = new visitor {
visitor_name = this.Name,
visitor_sex = this.Sex.ToString()
};
if (!isnew)
{
v.visitor_id = this.Id;
}
vmdc.visitor.InsertOnSubmit(v);
vmdc.SubmitChanges();
}
}
//signout group if succeed return true and change status to signout otherwise return false
public static Boolean SignOutGroup(string FirstName, string LastName, string PhoneNumber, DateTime dob)
{
visitor FoundVisitor = VisitorDAO.GetVisitor(FirstName, LastName, PhoneNumber, dob);
if (FoundVisitor == null)
{
return(false);
}
else
{
FoundVisitor.signedOut = true;
foreach (visitor V in FoundVisitor.group_visitor.visitor)
{
V.signedOut = true;
}
VisitorDAO.SaveChanges();
return(true);
}
}
public void New()
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
fire_train ft = new fire_train {
train_id = Guid, visitor = this.People.Id, train_date = this.TrainDate
};
vmdc.fire_train.InsertOnSubmit(ft);
visitor v = vmdc.visitor.Single(q => q.visitor_id == this.People.Id);
v.visitor_lastcheck = this.TrainDate;
vmdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw new Exception("培训失败", ex);
}
}
public ActionResult Edit(visitor visitor)
{
try
{
if (ModelState.IsValid)
{
db.Entry(visitor).State = EntityState.Modified;
db.SaveChanges();
TempData["Message2"] = string.Format("Visitor data update successfully.");
GetData();
//return RedirectToAction("Edit", new { VisitorID = visitor.visitorID });
return(RedirectToAction("Details", new { bDate = System.DateTime.Now.AddDays(-365), eDate = System.DateTime.Now }));
}
}
catch (Exception ex)
{
TempData["Message2"] = string.Format("Error editing visitor.");
}
GetData();
return(PartialView(visitor));
}
public void UpdateVisitor(int VisitorID = 0, string FirstName = "", string LastName = "", string Email = "", string PhoneNumber = "", string Address1 = "",
string Address2 = "", string City = "", string State = "", string Zip = "", int PhoneProviderID = 0)
{
visitor visitor = VisitorRepository.GetVisitorByID(VisitorID);
if (visitor != null)
{
visitor.FirstName = FirstName;
visitor.LastName = LastName;
visitor.Email = Email;
visitor.phoneNumber = PhoneNumber;
visitor.Address = Address1;
visitor.Address2 = Address2;
visitor.City = City;
visitor.State = State;
visitor.Zip = Zip;
visitor.PhoneProviderID = PhoneProviderID;
db.Entry(visitor).State = EntityState.Modified;
db.SaveChanges();
}
}
public ActionResult Create(visitor visitor)
{
try
{
if (ModelState.IsValid)
{
db.visitors.Add(visitor);
db.SaveChanges();
VisitorRepository.AddRecord(visitor);
TempData["Message2"] = "Visitor added successfully.";
GetData();
return(RedirectToAction("Create"));
}
}
catch (Exception ex)
{
TempData["Message2"] = "Error adding visitor";
}
GetData();
return(PartialView(visitor));
}
/**
* sign in each visitor and store them into the session
* */
private void SignInEachVisitor()
{
string FirstName = Request["firstName"];
string LastName = Request["lastName"];
string Email = Request["emailAddress"];
string dob = Request["dob"];
if (!Email.Equals("") && !LastName.Equals("") && !FirstName.Equals(""))
{
int groupNum = (int)Session["GroupNumber"];
List <visitor> visitorGroup = (List <visitor>)Session["VisitorGroup"];
visitor v = new visitor();
v.lastName = LastName;
v.firstName = FirstName;
v.medicalDetails = Request["medicalDetails"];
v.address = Request["address"];
v.email = Email;
v.contactNumber = Request["contactNumber"];
v.dob = Convert.ToDateTime(dob);
v.isoverdue = false;
v.signedOut = false;
visitorGroup.Add(v);
groupNum--;
Session["GroupNumber"] = groupNum;
//if all visitors are signed then save to database and direct to home page
if (groupNum == 0)
{
VisitorManager.VisitorSignin(visitorGroup, (List <int>)Session["VisitorTrackIDs"], Convert.ToInt32(Session["TotalDuration"]));
Session.Remove("VisitorGroup");
Response.Redirect("/Visitor", true);
}
}
else
{
ViewData["Error"] = "Invalid Input";
}
}
public void Load()
{
if (this.Id != null)
{
try
{
using (VisitMgtDataContext vmdc = new VisitMgtDataContext())
{
visitor v = vmdc.visitor.Single(q => q.visitor_id == this.Id);
this.isnew = false;
this.Name = v.visitor_name;
this.Sex = (VisitMgt.Sex)Enum.Parse(typeof(VisitMgt.Sex), v.visitor_sex, true);
if (v.visitor_lastcheck != null)
{
this.LastFireTrain = (DateTime)v.visitor_lastcheck;
}
}
}
catch (Exception ex)
{
throw new Exception("获取访客信息失败", ex);
}
}
}
protected void Recurse(int i, int j, NonTerminalSymbol nt, int d, visitor act)
{
ParseTreeNode thisnode = P[i, j, (int)nt];
if (!thisnode.match)
{
return;
}
ParseTreeNodeMatch m = thisnode.list;
if (m != null)
{
for (; m != null; m = m.next)
{
act(this, d, false, nt, m.B, m.C, i, j);
Recurse(i, m.k, m.B, d + 1, act);
Recurse(i + m.k + 1, j - m.k - 1, m.C, d + 1, act);
}
}
else
{
act(this, d, true, nt, 0, 0, i, j);
}
}
private void visitbtn_Click(object sender, EventArgs e)
{
visitor v = new visitor();
v.Show();
}
public void DeleteRecord(visitor record)
{
context.visitors.Remove(record);
context.SaveChanges();
}
public visitor GetVisitorByID(int visitorID)
{
record = myRecords.FirstOrDefault(e => e.visitorID == visitorID);
return(record);
}
public void AddRecord(visitor Record)
{
myRecords.Add(record);
}
public void updateVisitor(visitor objvisitor)
{
_vcontext.Entry(objvisitor).State = EntityState.Modified;
}
public visitor GetVisitorByID(int visitorID)
{
visitor objvisitor = _vcontext.visitors.ToList().Where(v => v.visitorID == visitorID).Single();
return(objvisitor);
}
public void addVisitor(visitor objvisitor)
{
_vcontext.visitors.Add(objvisitor);
Save();
}
//save a visitor to database
public static void SaveVisitor(visitor v)
{
Context.AddObject("visitor", v);
}
public void Unsubscribe(int VisitorID = 0)
{
visitor visitor = VisitorRepository.GetVisitorByID(VisitorID);
VisitorRepository.DeleteRecord(visitor);
}
