public TranVisitorModel GetVisitorInOut(string visitorID)
{
try {
TranVisitorModel tranVisitor = new TranVisitorModel();
DataTable dt_Pkaip = new DataTable();
DataTable dt1 = new DataTable();
string sql = " select InOutTran_ID,CarID,CscMain_ID,Indate ";
sql = sql + " from PkInoutTran ";
sql = sql + " where CscMain_ID = '" + visitorID + "' and CompleteFlag = 0 ";
sql = sql + " order by Indate ";
dt1 = db.QueryDataTable(sql);
tranVisitor = (from c in dt1.AsEnumerable()
select new TranVisitorModel
{
InOutTran_ID = c["InOutTran_ID"].ToString(),
CarID = c["CarID"].ToString(),
CscMain_ID = c["CscMain_ID"].ToString(),
Indate = Convert.ToDateTime(c["Indate"])
}).SingleOrDefault();
return(tranVisitor);
} catch (Exception ex) {
throw ex;
}
}
public TranVisitorModel GetVisitorInOut(string visitorID)
{
HttpContext context = HttpContext.Current;
var Userdata = (UserLoginModel)context.Items["user_data"];
TranVisitorModel data_visitor = new TranVisitorModel();
StampModel _stampModel = new StampModel();
data_visitor = this.stampservice.GetVisitorInOut(visitorID);
// return webData;
return(data_visitor);
}
