//public ResponseData SearchVisitor(VisitorInfo visitorinfo)
//{
// try
// {
// Visitor visitors = new Visitor();
// visitors = db.Visitors.Where(x => x.Phone.Equals(visitorinfo.Phone)).FirstOrDefault();
// if (visitors != null)
// {
// visitorinfo = new VisitorInfo();
// visitorinfo.VisitorID = visitors.VisitorID;
// visitorinfo.Name = visitors.Name;
// visitorinfo.Phone = visitors.Phone;
// visitorinfo.Company = visitors.Company;
// visitorinfo.Email = visitors.Email;
// }
// return new ResponseData() { visitorinfo = visitorinfo };
// }
// catch (Exception ex)
// {
// return new ResponseData() { ErrorMessage = ex.Message };
// }
//}
public ResponseData SearchVisitor(GetVisitorRequestParameter filter)
{
try
{
Visitor visitor = db.Visitors.Where(x => x.Phone.Equals(filter.PhoneNumber)).FirstOrDefault();
VisitorInfo visitorinfo = new VisitorInfo();
if (visitor != null)
{
visitorinfo.VisitorID = visitor.VisitorID;
visitorinfo.Name = visitor.Name;
visitorinfo.Phone = visitor.Phone;
visitorinfo.Company = visitor.Company;
visitorinfo.Email = visitor.Email;
}
return(new ResponseData()
{
visitorinfo = visitorinfo
});
}
catch (Exception ex)
{
return(new ResponseData()
{
ErrorMessage = ex.Message
});
}
}
public VisitorInfo SearchingVisitor(GetVisitorRequestParameter filter)
{
ResponseData response = meetingservice.SearchVisitor(filter);
VisitorInfo visitorinfo = response.visitorinfo;
return(visitorinfo);
}
private void visitorSaveButton_Click(object sender, EventArgs e)
{
VisitorInfo visitorInfo = new VisitorInfo();
VisitorZoneManager visitorZoneManager = new VisitorZoneManager();
visitorInfo.Name = nameTextBox.Text;
visitorInfo.Email = emailTextBox.Text;
visitorInfo.ContactNumber = int.Parse(contactNoTextBox.Text);
int visitorId = visitorInfoManager.Save(visitorInfo);
if (visitorId > 0)
{
foreach (var index in zoneCheckedListBox.CheckedItems)
{
Zone zone = (Zone)index;
VisitorZone visitorZone = new VisitorZone();
visitorZone.VisitorId = visitorId;
visitorZone.ZoneId = zone.Id;
visitorZoneManager.Save(visitorZone);
}
MessageBox.Show("Visitor Inserted Successfully! ");
nameTextBox.Clear();
emailTextBox.Clear();
contactNoTextBox.Clear();
}
else
{
MessageBox.Show("Error Occurs");
}
}
public bool Add(VisitorInfo model)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
try
{
dbOperator.BeginTransaction();
dbOperator.ClearParameters();
bool result = AddVisitorInfo(model, dbOperator);
if (!result)
{
throw new MyException("保存访客信息失败");
}
if (model.ParkVisitors != null && model.ParkVisitors.Count > 0)
{
foreach (var item in model.ParkVisitors)
{
dbOperator.ClearParameters();
result = AddVisitorCar(item, dbOperator);
if (!result)
{
throw new MyException("保存访客车辆信息失败");
}
}
}
dbOperator.CommitTransaction();
return(result);
}
catch
{
dbOperator.RollbackTransaction();
throw;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// 2019-07-15-임종우 : ESD 교육이수 정보 처리
if (Request.QueryString["mode"].Equals("esdTime"))
{
Visitor bll = new Visitor();
VisitorInfo obj = new VisitorInfo();
obj.VisitorCode = Convert.ToInt32(Request.QueryString["visitorCode"]);
int result = bll.updateEdsData(obj);
}
else
{
VisitorData bll = new VisitorData();
VisitorDataInfo obj = new VisitorDataInfo();
obj.VisitorDataCode = Convert.ToInt32(Request.QueryString["visitorDataCode"]);
if (Request.QueryString["mode"].Equals("inTime"))
{
int result = bll.updateInTime(obj);
}
else if (Request.QueryString["mode"].Equals("outTime"))
{
int result = bll.updateOutTime(obj);
}
}
String key = HttpUtility.UrlEncode(Request.QueryString["key"]);
Page.RegisterClientScriptBlock("alert", JavaScriptBuilder.alert("Đã hoàn thành (처리 하였습니다).", "visitDataList.aspx?keyWord=" + Request.QueryString["keyWord"] + "&key=" + key + "&page=" + Request.QueryString["page"]));
}
public async Task InvokeAsync(HttpContext context, IStatisticsManager statisticsManager)
{
if (statisticsManager == null)
{
throw new ArgumentNullException(nameof(statisticsManager));
}
string visitorId = context.Request.Cookies["VisitorId"];
if (context.Request != null && visitorId == null)
{
VisitorInfo visitor = new VisitorInfo();
visitor.Id = Guid.NewGuid();
visitor.LastVisitAt = DateTime.Now;
visitor.UserAgent = context.Request.Headers[HeaderNames.UserAgent];
visitor.IpAddress = context.Request.HttpContext.Connection.RemoteIpAddress.ToString();
visitor.UserId = context.Request.HttpContext.User.FindFirst(ClaimTypes.NameIdentifier)?.Value;
// Save in database
statisticsManager.SaveVisitor(visitor);
// Save in cookies
context.Response.Cookies.Append("VisitorId", visitor.Id.ToString(), new CookieOptions()
{
Path = "/",
HttpOnly = true,
Secure = false,
});
}
await _next(context);
}
/// <summary>
/// 내방객 정보 가져오기(주민번호 이용)
/// </summary>
/// <param name="visitorRegNumber1"></param>
/// <param name="visitorRegNumber2"></param>
/// <returns></returns>
public VisitorInfo getVisitor(string visitorRegNumber1, string visitorRegNumber2)
{
log.Debug(@"=================START getVisitor=================");
log.Debug(@"visitorRegNumber1 = " + visitorRegNumber1);
log.Debug(@"visitorRegNumber2 = " + visitorRegNumber2);
VisitorInfo obj = new VisitorInfo();
StringBuilder sql_select_visitor = new StringBuilder();
sql_select_visitor.Append("SELECT a.visitorCode,a.visitorName,a.visitorPhone1,a.visitorPhone2,a.visitorPhone3,");
sql_select_visitor.Append("a.visitorRegNumber1,a.visitorRegNumber2,a.visitorPassportNumber,a.companyCode,a.reject,a.rejectContent,a.regDate,b.companyName,a.visitorFlag,a.esdFlag,a.esdDate");
sql_select_visitor.Append(" FROM Visitor a LEFT OUTER JOIN Company b ON a.companyCode=b.companyCode");
sql_select_visitor.Append(" WHERE visitorRegNumber1='" + visitorRegNumber1 + "' AND visitorRegNumber2='" + visitorRegNumber2 + "'");
//Execute the query
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_select_visitor.ToString(), null))
{
if (rdr.Read())
{
obj = bindVisitor(rdr, obj);
}
}
log.Debug(@"=================END getVisitor=================");
return(obj);
}
/// <summary>
/// 내방객 수정
/// </summary>
/// <param name="visitor"></param>
/// <returns></returns>
public int updatetVisitor(VisitorInfo visitor)
{
log.Debug("=================START updatetVisitor=================");
log.Debug("visitor = " + visitor.ToString());
StringBuilder sql_update = new StringBuilder();
sql_update.Append("UPDATE Visitor SET");
sql_update.Append(" visitorName='" + visitor.VisitorName + "',");
sql_update.Append("visitorPhone1='" + visitor.VisitorPhone1 + "',");
sql_update.Append("visitorPhone2='" + visitor.VisitorPhone2 + "',");
sql_update.Append("visitorPhone3='" + visitor.VisitorPhone3 + "',");
sql_update.Append("visitorRegNumber1='" + visitor.VisitorRegNumber1 + "',");
sql_update.Append("visitorRegNumber2='" + visitor.VisitorRegNumber2 + "',");
sql_update.Append("visitorPassportNumber='" + visitor.VisitorPassportNumber + "',");
sql_update.Append("companyCode='" + visitor.CompanyCode + "',");
sql_update.Append("reject='" + visitor.Reject + "',");
sql_update.Append("rejectContent='" + visitor.RejectContent + "',");
sql_update.Append("visitorFlag=" + visitor.VisitorFlag);
sql_update.Append(" WHERE visitorCode="+ visitor.VisitorCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_update.ToString(), null);
log.Debug(@"=================END updatetVisitor=================");
return(result);
}
public void AddVisitor(VisitorInfo visitor)
{
try
{
DatabaseHelper.Insert <VisitorInfo>(visitor);
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
private void saveVisitorInfo()
{
try
{
labelMessageVisitorInfo.Text = string.Empty;
using (VisitorRT receiverTransfer = new VisitorRT())
{
List <VisitorInfo> VisitorInfoList = new List <VisitorInfo>();
VisitorInfoList = receiverTransfer.GetVisitorInfoIPnType(labelMessageIP.Text, labelMessageIPType.Text);
if (VisitorInfoList != null && VisitorInfoList.Count > 0)
{
VisitorInfo vIsitor = new VisitorInfo();
vIsitor = receiverTransfer.GetVisitorID(labelMessageIP.Text, labelMessageIPType.Text);
VisitorInfoDetail visitorDetailes = CreateVisitordetails();
visitorDetailes.VisitorInfoID = vIsitor.IID;
using (VisitorInfoDetailRT visitorDetailesRT = new VisitorInfoDetailRT())
{
visitorDetailesRT.AddVisitorInfo(visitorDetailes);
}
}
else
{
VisitorInfo visitor = CreateVisitor();
VisitorInfoDetail visitorDetailes = CreateVisitordetails();
receiverTransfer.AddVisitor(visitor);
visitorDetailes.VisitorInfoID = visitor.IID;
using (VisitorInfoDetailRT visitorDetailesRT = new VisitorInfoDetailRT())
{
visitorDetailesRT.AddVisitorInfo(visitorDetailes);
}
if (visitor.IID > 0 && visitorDetailes.IID > 0)
{
labelMessageVisitorInfo.Text = "Data successfully saved...";
labelMessageVisitorInfo.ForeColor = System.Drawing.Color.Green;
}
else
{
labelMessageVisitorInfo.Text = "Data not saved...";
labelMessageVisitorInfo.ForeColor = System.Drawing.Color.Red;
}
}
}
//LoadUserGrp();
}
catch (Exception ex)
{
labelMessageVisitorInfo.Text = "Error : " + ex.Message;
labelMessageVisitorInfo.ForeColor = System.Drawing.Color.Red;
}
}
public bool EditVisitorInfo(VisitorInfo model)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
try
{
model.DataStatus = (int)DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("update VisitorInfo set PlateNumber=@PlateNumber,VisitorMobilePhone=@VisitorMobilePhone,VisitorCount=@VisitorCount,BeginDate=@BeginDate,EndDate=@EndDate,AccountID=@AccountID,CreateTime=@CreateTime,VisitorState=@VisitorState,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate");
strSql.Append(" ,DataStatus=@DataStatus,VID=@VID,LookSate=@LookSate,IsExamine=@IsExamine,VisitorName=@VisitorName,VisitorSex=@VisitorSex,Birthday=@Birthday,CertifType=@CertifType,");
strSql.Append(" CertifNo=@CertifNo,CertifAddr=@CertifAddr,EmployeeID=@EmployeeID,CardNo=@CardNo,OperatorID=@OperatorID,VisitorCompany=@VisitorCompany,VistorPhoto=@VistorPhoto,CertifPhoto=@CertifPhoto,VisitorSource=@VisitorSource,Remark=@Remark,CarModelID=@CarModelID");
strSql.Append(" where RecordID=@RecordID");
dbOperator.ClearParameters();
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("PlateNumber", model.PlateNumber);
dbOperator.AddParameter("VisitorMobilePhone", model.VisitorMobilePhone);
dbOperator.AddParameter("VisitorCount", model.VisitorCount);
dbOperator.AddParameter("BeginDate", model.BeginDate);
dbOperator.AddParameter("EndDate", model.EndDate);
dbOperator.AddParameter("AccountID", model.AccountID);
dbOperator.AddParameter("CreateTime", model.CreateTime);
dbOperator.AddParameter("VisitorState", model.VisitorState);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("DataStatus", model.DataStatus);
dbOperator.AddParameter("VID", model.VID);
dbOperator.AddParameter("LookSate", model.LookSate);
dbOperator.AddParameter("IsExamine", model.IsExamine);
dbOperator.AddParameter("VisitorName", model.VisitorName);
dbOperator.AddParameter("VisitorSex", model.VisitorSex);
dbOperator.AddParameter("Birthday", model.Birthday);
dbOperator.AddParameter("CertifType", model.CertifType);
dbOperator.AddParameter("CertifNo", model.CertifNo);
dbOperator.AddParameter("CertifAddr", model.CertifAddr);
dbOperator.AddParameter("EmployeeID", model.EmployeeID);
dbOperator.AddParameter("CardNo", model.CardNo);
dbOperator.AddParameter("OperatorID", model.OperatorID);
dbOperator.AddParameter("VisitorCompany", model.VisitorCompany);
dbOperator.AddParameter("VistorPhoto", model.VistorPhoto);
dbOperator.AddParameter("CertifPhoto", model.CertifPhoto);
dbOperator.AddParameter("VisitorSource", model.VisitorSource);
dbOperator.AddParameter("Remark", model.Remark);
dbOperator.AddParameter("CarModelID", model.CarModelID);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
catch
{
dbOperator.RollbackTransaction();
throw;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Visitor bll = new Visitor();
VisitorInfo obj = new VisitorInfo();
obj = bll.getVisitor(Request.QueryString["regNumber1"], Request.QueryString["regNumber2"]);
//if (exists) searchResult = "1";
//else searchResult = "0";
searchResult = obj.VisitorCode.ToString() + ":|:" + obj.VisitorName + ":|:" + obj.Reject + ":|:" + obj.RejectContent;
}
/// <summary>
/// 내방객 목록
/// </summary>
/// <param name="txtKey"></param>
/// <returns></returns>
public List <VisitorInfo> listVisitor(String keyWord, String key, Boolean reject)
{
log.Debug("=================START listVisitor=================");
log.Debug("keyWord = " + keyWord);
log.Debug("key = " + key);
log.Debug("reject = " + reject);
List <VisitorInfo> list = new List <VisitorInfo>();
StringBuilder sql_select_list = new StringBuilder();
sql_select_list.Append(" SELECT ");
sql_select_list.Append(" a.visitorCode,a.visitorName,a.visitorPhone1,a.visitorPhone2,a.visitorPhone3,");
sql_select_list.Append(" a.visitorRegNumber1,a.visitorRegNumber2,a.visitorPassportNumber,a.companyCode,a.reject,a.rejectContent,a.regDate,b.companyName,a.visitorFlag,a.esdFlag,a.esdDate ");
sql_select_list.Append(" FROM Visitor a LEFT OUTER JOIN Company b ON a.companyCode=b.companyCode ");
if (!String.IsNullOrEmpty(key))
{
sql_select_list.Append(" WHERE " + keyWord + " LIKE '%" + key + "%'");
//sql_select_list.Append(" WHERE " + keyWord + " = '" + key + "'");
if (reject == true)
{
sql_select_list.Append(" AND reject=1");
}
}
else
{
if (reject == true)
{
sql_select_list.Append(" WHERE reject=1");
}
}
sql_select_list.Append(" ORDER BY a.visitorCode DESC");
//Execute the query against the database
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_select_list.ToString(), null))
{
// Scroll through the results
while (rdr.Read())
{
VisitorInfo obj = new VisitorInfo();
obj = bindVisitor(rdr, obj);
list.Add(obj);
}
}
log.Debug(@"=================END listVisitor=================");
return(list);
}
public async Task <IActionResult> Create([Bind("Id,VisitorIp,CityId,CityName,VisitUrl,AppVersion,AddTime")] VisitorInfo visitorInfo)
{
if (ModelState.IsValid)
{
context.Add(visitorInfo);
await context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(visitorInfo));
}
public static bool Edit(VisitorInfo model)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
IParkVisitor factory = ParkVisitorFactory.GetFactory();
return(factory.EditVisitorInfo(model));
}
public void AddErrLog(string strMsg, string strStackTrace)
{
VisitorInfo visitorInfo = STATClient.GetVisitorInfo();
if (visitorInfo != null)
{
visitorInfo.ErrMessage = strMsg;
visitorInfo.StackTrace = strStackTrace;
Visitor.Add(visitorInfo);
}
}
protected void Application_End()
{
//获取当前时间（结束时间）
DateTime EndTime = DateTime.Now;
//修改表中的结束时间
VisitorInfo visitor = new VisitorInfo();
//string time = HttpContext.Current.Session["AccessTime"].ToString();
//work.CreateRepository<VisitorInfo>().Update(visitor,time);
//查询访客的浏览开始时间
//int a = work.ExecuteNonQuery(string.Format("select * from VisitorInfo where Id={0}", id));
}
public ResponseData SearchMeeting(MeetingInfo MeetingInfo)
{
try
{
var Meetings = db.Meetings
.Include("EmployeeMeetings.Employee")
.Include("VisitorMeetings.Visitor")
.Where(x => x.MeetingPin == MeetingInfo.MeetingPin && x.MeetingKey == MeetingInfo.MeetingKey).FirstOrDefault();
MeetingInfo = new MeetingInfo();
MeetingInfo.Purpose = Meetings.Purpose;
MeetingInfo.StartTime = Meetings.StartTime;
MeetingInfo.EndTime = Meetings.EndTime;
MeetingInfo.MeetingPin = Meetings.MeetingPin;
MeetingInfo.Employees = new List <EmployeeInfo>();
MeetingInfo.Visitors = new List <VisitorInfo>();
foreach (var employee in Meetings.EmployeeMeetings)
{
EmployeeInfo employeeInfo = new EmployeeInfo();
employeeInfo.Name = employee.Employee.Name;
//employeeInfo.Email = employee.Employee.Email;
employeeInfo.Phone = employee.Employee.Phone;
MeetingInfo.Employees.Add(employeeInfo);
}
foreach (var visitor in Meetings.VisitorMeetings)
{
VisitorInfo visitorinfo = new VisitorInfo();
visitorinfo.Name = visitor.Visitor.Name;
visitorinfo.Email = visitor.Visitor.Email;
visitorinfo.Phone = visitor.Visitor.Phone;
MeetingInfo.Visitors.Add(visitorinfo);
}
return(new ResponseData()
{
meetinginfo = MeetingInfo
});
}
catch (Exception ex)
{
return(new ResponseData()
{
ErrorMessage = ex.Message
});
}
}
public VisitorInfo GetVisitorID(string ip, string type)
{
try
{
OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext();
VisitorInfo VisitorIDList = new VisitorInfo();
VisitorIDList = dbContext.VisitorInfos.Single(d => d.IPAddress == ip && d.IPType == type);
//var activeDesignation = usrGrpList.Where(d => d.IsActive == true).ToList();
//dbContext.Dispose();
return(VisitorIDList);
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
public static int Add(VisitorInfo entity)
{
int result;
if (entity == null)
{
result = 0;
}
else
{
result = BizBase.dbo.InsertModel <VisitorInfo>(entity);
}
return(result);
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[2].ColumnSpan = 3;
e.Row.Cells[3].Visible = false;
e.Row.Cells[4].Visible = false;
e.Row.Cells[5].ColumnSpan = 2;
e.Row.Cells[6].Visible = false;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
VisitorInfo obj = (VisitorInfo)e.Row.DataItem;
e.Row.Cells[2].Text = obj.VisitorPhone1 + "-" + obj.VisitorPhone2 + "-" + obj.VisitorPhone3;
e.Row.Cells[2].ColumnSpan = 3;
e.Row.Cells[3].Visible = false;
e.Row.Cells[4].Visible = false;
if (obj.VisitorFlag != 1)
{
//e.Row.Cells[5].Text = obj.VisitorRegNumber1 + "-" + obj.VisitorRegNumber2.Substring(0, 4) + "***";
e.Row.Cells[5].Text = obj.VisitorRegNumber1;
}
else
{
e.Row.Cells[5].Text = obj.VisitorPassportNumber;
}
e.Row.Cells[5].ColumnSpan = 2;
e.Row.Cells[6].Visible = false;
if (obj.Reject == 0)
{
e.Row.Attributes.Add("style", "cursor:hand");
if (!String.IsNullOrEmpty(obj.VisitorRegNumber1))
{
//e.Row.Attributes.Add("onclick", "selectEnd('" + obj.VisitorCode + "','" + obj.VisitorRegNumber1 + "-" + obj.VisitorRegNumber2.Substring(0, 4) + "***" + "','" + obj.VisitorPassportNumber + "','" + obj.VisitorName + "','" + obj.CompanyName + "','" + obj.VisitorPhone1 + "-" + obj.VisitorPhone2 + "-" + obj.VisitorPhone3 + "','" + index.Value + "');");
e.Row.Attributes.Add("onclick", "selectEnd('" + obj.VisitorCode + "','" + obj.VisitorRegNumber1 + "','" + obj.VisitorPassportNumber + "','" + obj.VisitorName + "','" + obj.CompanyName + "','" + obj.VisitorPhone1 + "-" + obj.VisitorPhone2 + "-" + obj.VisitorPhone3 + "','" + index.Value + "');");
}
else
{
//e.Row.Attributes.Add("onclick", "selectEnd('" + obj.VisitorCode + "','" + obj.VisitorRegNumber1 + obj.VisitorRegNumber2 + "','" + obj.VisitorPassportNumber + "','" + obj.VisitorName + "','" + obj.CompanyName + "','" + obj.VisitorPhone1 + "-" + obj.VisitorPhone2 + "-" + obj.VisitorPhone3 + "','" + index.Value + "');");
e.Row.Attributes.Add("onclick", "selectEnd('" + obj.VisitorCode + "','" + obj.VisitorRegNumber1 + "','" + obj.VisitorPassportNumber + "','" + obj.VisitorName + "','" + obj.CompanyName + "','" + obj.VisitorPhone1 + "-" + obj.VisitorPhone2 + "-" + obj.VisitorPhone3 + "','" + index.Value + "');");
}
}
}
}
public static bool Add(VisitorInfo model)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
try
{
IParkVisitor factory = ParkVisitorFactory.GetFactory();
return(factory.Add(model));
}
catch
{
throw;
}
}
/// <summary>
/// Convert VisitorInfo to Visitor.
/// </summary>
/// <param name="visitorInfo">Visitor info</param>
/// <returns>Visitor</returns>
public static Visitor ToVisitor(this VisitorInfo visitorInfo)
{
if (visitorInfo is null)
{
return(null);
}
return(new Visitor()
{
Id = visitorInfo.Id,
IpAddress = visitorInfo.IpAddress,
LastVisitAt = visitorInfo.LastVisitAt,
UserAgent = visitorInfo.UserAgent,
UserId = visitorInfo.UserId
});
}
public ActionResult WelcomePage()
{
ViewBag.Message = "Our team welcome page.";
var viewPath = this.ControllerContext.RouteData.Values["action"].ToString();
ViewBag.viewPath = viewPath;
HttpRequest req = System.Web.HttpContext.Current.Request;
string browserName = req.Browser.Browser;
ViewBag.browser = browserName;
//string userIpAddress = HttpContext.Request.UserHostAddress;
//ViewBag.ip = userIpAddress;
string ipAddress = string.Empty;
if (HttpContext.Request.ServerVariables["HTTP_X__FORWARDER_FOR"] != null)
{
ipAddress = HttpContext.Request.ServerVariables["HTTP_X__FORWARDER_FOR"].ToString();
}
else if (HttpContext.Request.UserHostAddress.Length != 0)
{
ipAddress = HttpContext.Request.UserHostAddress;
}
ViewBag.ip = ipAddress;
using (TeamEVotingDBEntities teamEVotingDBEntities = new TeamEVotingDBEntities())
{
VisitorInfo visitorInfo = new VisitorInfo();
List <object> list = new List <object>();
list.Add(visitorInfo.Visited_DateTime = DateTime.Now);
list.Add(visitorInfo.VisitorIP = ipAddress);
list.Add(visitorInfo.VisitorBrowser = browserName);
list.Add(visitorInfo.VisitorLandingPage = viewPath);
list.Add(visitorInfo.User_Id = null);
if (visitorInfo.VisitorIP != "::1")
{
object[] allitems = list.ToArray();
teamEVotingDBEntities.Database.ExecuteSqlCommand("INSERT INTO VisitorInfo(Visited_DateTime, VisitorIP, VisitorBrowser, VisitorLandingPage, User_Id) values (@p0,@p1,@p2,@p3,@p4)", allitems);
}
else
{
}
}
return(View());
}
private bool AddVisitorInfo(VisitorInfo model, DbOperator dbOperator)
{
model.DataStatus = (int)DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into VisitorInfo(RecordID,PlateNumber,VisitorMobilePhone,VisitorCount,BeginDate,EndDate,AccountID,CreateTime,VisitorState,LastUpdateTime,HaveUpdate");
strSql.Append(" ,DataStatus,VID,LookSate,IsExamine,VisitorName,VisitorSex,Birthday,CertifType,CertifNo,CertifAddr,EmployeeID,CardNo,OperatorID,VisitorCompany,VistorPhoto,CertifPhoto,VisitorSource,Remark,CarModelID)");
strSql.Append(" values(@RecordID,@PlateNumber,@VisitorMobilePhone,@VisitorCount,@BeginDate,@EndDate,@AccountID,@CreateTime,@VisitorState,@LastUpdateTime,@HaveUpdate");
strSql.Append(" ,@DataStatus,@VID,@LookSate,@IsExamine,@VisitorName,@VisitorSex,@Birthday,@CertifType,@CertifNo,@CertifAddr,@EmployeeID,@CardNo,@OperatorID,@VisitorCompany,@VistorPhoto,@CertifPhoto,@VisitorSource,@Remark,@CarModelID)");
dbOperator.ClearParameters();
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("PlateNumber", model.PlateNumber);
dbOperator.AddParameter("VisitorMobilePhone", model.VisitorMobilePhone);
dbOperator.AddParameter("VisitorCount", model.VisitorCount);
dbOperator.AddParameter("BeginDate", model.BeginDate);
dbOperator.AddParameter("EndDate", model.EndDate);
dbOperator.AddParameter("AccountID", model.AccountID);
dbOperator.AddParameter("CreateTime", model.CreateTime);
dbOperator.AddParameter("VisitorState", model.VisitorState);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("DataStatus", model.DataStatus);
dbOperator.AddParameter("VID", model.VID);
dbOperator.AddParameter("LookSate", model.LookSate);
dbOperator.AddParameter("IsExamine", model.IsExamine);
dbOperator.AddParameter("VisitorName", model.VisitorName);
dbOperator.AddParameter("VisitorSex", model.VisitorSex);
dbOperator.AddParameter("Birthday", model.Birthday);
dbOperator.AddParameter("CertifType", model.CertifType);
dbOperator.AddParameter("CertifNo", model.CertifNo);
dbOperator.AddParameter("CertifAddr", model.CertifAddr);
dbOperator.AddParameter("EmployeeID", model.EmployeeID);
dbOperator.AddParameter("CardNo", model.CardNo);
dbOperator.AddParameter("OperatorID", model.OperatorID);
dbOperator.AddParameter("VisitorCompany", model.VisitorCompany);
dbOperator.AddParameter("VistorPhoto", model.VistorPhoto);
dbOperator.AddParameter("CertifPhoto", model.CertifPhoto);
dbOperator.AddParameter("VisitorSource", model.VisitorSource);
dbOperator.AddParameter("Remark", model.Remark);
dbOperator.AddParameter("CarModelID", model.CarModelID);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
private VisitorInfo CreateVisitor()
{
Session["UserID"] = "1";
VisitorInfo visitorInfo = new VisitorInfo();
try
{
visitorInfo.IPAddress = lblIPAddress.Text;
visitorInfo.IPType = lblIPrealFake.Text;
}
catch (Exception ex)
{
lblVisitorINfo.Text = "Error : " + ex.Message;
lblVisitorINfo.ForeColor = System.Drawing.Color.Red;
}
return(visitorInfo);
}
public int updateEdsData(VisitorInfo visitor)
{
log.Debug("=================START updateEsdData=================");
log.Debug("visitor = " + visitor.ToString());
StringBuilder sql_update = new StringBuilder();
sql_update.Append("UPDATE Visitor SET");
sql_update.Append(" esdFlag = 'Y',");
sql_update.Append(" esdDate = getdate()");
sql_update.Append(" WHERE visitorCode="+ visitor.VisitorCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_update.ToString(), null);
log.Debug(@"=================END updateEsdData=================");
return(result);
}
protected void DetailsView1_DataBound(object sender, EventArgs e)
{
VisitorInfo obj = (VisitorInfo)DetailsView1.DataItem;
DetailsView1.Rows[4].Visible = false;
DetailsView1.Rows[6].Visible = false;
DetailsView1.Rows[7].Visible = false;
if (String.IsNullOrEmpty(obj.VisitorPassportNumber))
{
//DetailsView1.Rows[3].Cells[1].Text = obj.VisitorRegNumber1 + "-" + obj.VisitorRegNumber2;
DetailsView1.Rows[3].Cells[1].Text = obj.VisitorRegNumber1;
}
else
{
DetailsView1.Rows[3].Cells[1].Text = obj.VisitorPassportNumber;
}
DetailsView1.Rows[5].Cells[1].Text = obj.VisitorPhone1 + "-" + obj.VisitorPhone2 + "-" + obj.VisitorPhone3;
DetailsView1.Rows[11].Cells[1].Attributes.Add("align", "center");
DetailsView1.Rows[11].Cells[0].Visible = false;
DetailsView1.Rows[11].Cells[1].ColumnSpan = 2;
HyperLink colCancel = (HyperLink)DetailsView1.Rows[11].Cells[1].Controls[0];
colCancel.ImageUrl = "~/images/icon/cancel.gif";
colCancel.NavigateUrl = "javascript:history.go(-1)";
if (obj.Reject == 0)
{
DetailsView1.Rows[8].Cells[1].Text = "Không (아니오)";
}
else
{
DetailsView1.Rows[8].Cells[1].Text = "<span style=\"color:red\">예</span>";
}
DetailsView1.Rows[9].Cells[1].Text = StringUtil.ConvertToHtml(obj.RejectContent);
Label1.Text = "Xem chi tiết khách thăm (내방객 상세보기):" + obj.VisitorName; // 표시 순서 바꿈 (Thay đổi thứ tự hiển thị) xem chi tiết: visitorName
// obj.VisitorName + "Xem chi tiết khách thăm (내방객 상세보기)"; 원래 code
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
VisitorInfo obj = (VisitorInfo)e.Row.DataItem;
e.Row.Cells[2].Text = obj.VisitorPhone1 + "-" + obj.VisitorPhone2 + "-" + obj.VisitorPhone3;
e.Row.Cells[2].ColumnSpan = 3;
e.Row.Cells[3].Visible = false;
e.Row.Cells[4].Visible = false;
if (String.IsNullOrEmpty(obj.VisitorPassportNumber))
{
e.Row.Cells[5].Text = obj.VisitorRegNumber1 + "-" + obj.VisitorRegNumber2;
}
else
{
e.Row.Cells[5].Text = obj.VisitorPassportNumber;
}
e.Row.Cells[5].ColumnSpan = 2;
e.Row.Cells[6].Visible = false;
HyperLink colModify = (HyperLink)e.Row.Cells[8].Controls[0];
colModify.NavigateUrl = "visitorEdit.aspx?visitorCode=" + obj.VisitorCode + "&mode=modify";
colModify.ImageUrl = "~/images/icon/edit.gif";
HyperLink colDelete = (HyperLink)e.Row.Cells[9].Controls[0];
colDelete.NavigateUrl = "#";
colDelete.Attributes.Add("onclick", "return confirmDelete('visitorDelete.aspx?visitorCode=" + obj.VisitorCode + "');");
colDelete.ImageUrl = "~/images/icon/delete.gif";
for (int i = 0; i < e.Row.Cells.Count; i++)
{
if (i < 8)
{
e.Row.Cells[i].Attributes.Add("onclick", "window.location='visitorView.aspx?visitorCode=" + obj.VisitorCode + "';");
e.Row.Cells[i].Attributes.Add("style", "cursor:hand;");
}
}
}
}
public int Save(VisitorInfo visitorInfo)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO tbl_visitor_info OUTPUT INSERTED.Id VALUES('" + visitorInfo.Name + "','" + visitorInfo.Email + "','" + visitorInfo.ContactNumber + "')";
SqlCommand sqlCommand = new SqlCommand(query, connection);
connection.Open();
int row = (int)sqlCommand.ExecuteScalar();
connection.Close();
if (row > 0)
{
return(row);
}
else
{
return(0);
}
}
