public VisitorInformation AddVisitorInformation(VisitorInformationForCreation visitorInformationViewModel) { var pathToSave = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/NationalIdImages"); var fileName = string.Empty; if (visitorInformationViewModel.Image != null) { fileName = visitorInformationViewModel.Image.FileName; var fullPath = Path.Combine(pathToSave, fileName); using (var stream = new FileStream(fullPath, FileMode.Create)) { visitorInformationViewModel.Image.CopyTo(stream); } } var visitorInformation = new VisitorInformation { Name = visitorInformationViewModel.Name, Address = visitorInformationViewModel.Address, Email = visitorInformationViewModel.Email, Governrate = visitorInformationViewModel.Governrate, IdNumber = visitorInformationViewModel.IdNumber, Phone = visitorInformationViewModel.Phone, Image = fileName }; _db.VisitorInformations.Add(visitorInformation); _db.SaveChanges(); return(visitorInformation); }
public JsonResult VisitorDetailsJson() { var test = Sitecore.Context.Item; var vi = new VisitorInformation(); var trackerDto2 = vi.GetTrackerDto(); return(Json(trackerDto2, JsonRequestBehavior.AllowGet)); }
private static List<VisitorInformation> QueryAllVisitorList() { List<VisitorInformation> VisitorList = new List<VisitorInformation>(); MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection(); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); msqlCommand.Connection = msqlConnection; msqlCommand.CommandText = "Select * From regvisitor;"; MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader(); while (msqlReader.Read()) { VisitorInformation Visitor = new VisitorInformation(); Visitor.id = msqlReader.GetString("id"); Visitor.name = msqlReader.GetString("name"); Visitor.addres = msqlReader.GetString("address"); Visitor.contact = msqlReader.GetString("phone"); Visitor.idinfo = msqlReader.GetString("idcardno"); Visitor.viitortype = msqlReader.GetString("visitortype"); Visitor.purpose = msqlReader.GetString("purpose"); Visitor.empId = msqlReader.GetString("visitwhom"); Visitor.signintime = msqlReader.GetDateTime("signtime"); Visitor.remark = msqlReader.GetString("remark"); Visitor.expcttie = msqlReader.GetString("timewilltake"); Visitor.permisionBy = msqlReader.GetString("prmsnGrntdby"); Visitor.allowBy = msqlReader.GetString("allowvisitBy"); Visitor.empId = msqlReader.GetString("employId"); VisitorList.Add(Visitor); } } catch (Exception er) { } finally { //always close the connection msqlConnection.Close(); } return VisitorList; }
private static int DoRegisterNewVisetorindb(VisitorInformation NewVisitor) { int returnVal = 0; MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection(); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); //define the connection used by the command object msqlCommand.Connection = msqlConnection; msqlCommand.CommandText = "INSERT INTO regvisitor(id,name,address,phone,idcardno,visitortype,purpose,visitwhom,signtime,remark,timewilltake) " + "VALUES(@id,@name,@address,@phone,@idcardno,@visitortype,@purpose,@visitwhom,@signtime,@remark,@timewilltake)"; msqlCommand.Parameters.AddWithValue("@id", NewVisitor.id); msqlCommand.Parameters.AddWithValue("@name", NewVisitor.name); msqlCommand.Parameters.AddWithValue("@address", NewVisitor.addres); msqlCommand.Parameters.AddWithValue("@phone", NewVisitor.contact); msqlCommand.Parameters.AddWithValue("@idcardno", NewVisitor.idinfo); msqlCommand.Parameters.AddWithValue("@visitortype", NewVisitor.viitortype); msqlCommand.Parameters.AddWithValue("@purpose", NewVisitor.purpose); msqlCommand.Parameters.AddWithValue("@visitwhom", NewVisitor.empId); msqlCommand.Parameters.AddWithValue("@signtime", NewVisitor.signintime); msqlCommand.Parameters.AddWithValue("@remark", NewVisitor.remark); msqlCommand.Parameters.AddWithValue("@timewilltake", NewVisitor.expcttie); msqlCommand.ExecuteNonQuery(); returnVal = 1; } catch (Exception er) { returnVal = 0; } finally { //always close the connection msqlConnection.Close(); } return returnVal; }
public static VisitorInformation GetVisitorInfo(string visitorId) { VisitorInformation visitor = new VisitorInformation(); MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection(); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); msqlCommand.Connection = msqlConnection; msqlCommand.CommandText = "Select * From regvisitor WHERE id=@id;"; msqlCommand.Parameters.AddWithValue("@id", visitorId); MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader(); msqlReader.Read(); visitor.name = msqlReader.GetString("name"); visitor.idinfo = msqlReader.GetString("idcardno"); } catch (Exception er) { } finally { //always close the connection msqlConnection.Close(); } return visitor; }
public static int DoEnterVisetor(VisitorInformation Newvisitor) { return DoRegisterNewVisetorindb(Newvisitor); }