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);
}
