protected void Button2_Click(object sender, EventArgs e) { VisitorDetail vd = new VisitorDetail(); if (!(string.IsNullOrEmpty(TextBox1.Text))) { string name = TextBox1.Text; var data = (from t in db.VisitorDetails where (t.Fname == name && t.Status == "Signed In") select new { t.VisitorId, t.Fname, t.Lname, t.Idtype, t.Idnum }).ToList(); if (data.Count == 0) { Label3.Visible = true; Label3.Text = "No Records Found With Name :" + name; } else { GridView1.DataSource = data; GridView1.DataBind(); } } else { Label3.Visible = true; Label3.Text = "Please Enter ID or Name to search"; } }
protected void btnsave_Click(object sender, EventArgs e) { string fname = tbfname.Text; string lname = tblname.Text; string company = tbcompany.Text; string visiting = tbvisit.Text; string idtype = ddlidtype.SelectedItem.ToString(); string idnum = tbidnum.Text; string vnum = ""; if (!(tbvnum.Text == null)) { vnum = tbvnum.Text; } string contact = tbcno.Text; string purpose = tbpurpose.Text; VisitorDetail vd = new VisitorDetail(); vd.Fname = fname; vd.Lname = lname; vd.Company = company; vd.Visiting = visiting; vd.Idtype = idtype; vd.Idnum = idnum; vd.Vnumber = vnum; vd.Contactno = contact; vd.Purpose = purpose; vd.Status = "Signed In"; vd.ctime = DateTime.Now; db.VisitorDetails.Add(vd); lbResult.Visible = true; var res = db.SaveChanges(); int id = vd.VisitorId; if (res > 0) { lbResult.Text = "The Visitor's Details Has Been Saved Successfully with the Visitors ID :" + id; } else { lbResult.Text = "Fail"; } tbfname.Text = ""; tblname.Text = ""; tbcompany.Text = ""; tbvisit.Text = ""; ddlidtype.SelectedItem.Value = "Select"; tbidnum.Text = ""; tbvnum.Text = ""; tbcno.Text = ""; tbpurpose.Text = ""; }