public StampModel GetInOutDetail(string visitorId)
{
HttpContext context = HttpContext.Current;
var Userdata = (UserLoginModel)context.Items["user_data"];
StampModel _stampmodel = new StampModel();
_stampmodel = this.stampservice.InOutTranDetail(visitorId, Userdata.CompanyID, Userdata.DeptID, Userdata.AdminLevel.ToString());
///accountPAI.Login("admin", "admin");
return(_stampmodel);
}
public StampModel InOutTranDetail(string visitorId, string terncode, string ternsubcode, string adminlevel)
{
UserLoginModel userLogin = account.Login("admin", "admin");
string json = get_api.getDataOtherAPI("http://www.psspark.com/api/login?username=admin&password=1234");
//string json = get_api.getDataWithToken("http://localhost:8085/stamp/api/getInOutDeatil?visitorId=" + visitorId + "&terncode=" + terncode + "&trensubcode="+ternsubcode+"&adminlevel="+adminlevel, userLogin.Token, "GET");
StampModel stampModel = JsonConvert.DeserializeObject <StampModel>(json);
return(stampModel);
//throw new NotImplementedException();
}
public ActionResult DeleteStamp(int id)
{
using (var dbUse = new UserContext())
{
StampModel st = dbUse.StampModels.Find(id);
if (st == null)
{
return(RedirectToAction("EditorPattern"));
}
dbUse.StampModels.Remove(st);
dbUse.SaveChanges();
return(RedirectToAction("GetStamps"));
}
}
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);
}
private async Task CreateStamp()
{
List <KeyValuePair <string, string> > values = new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("Title", Title)
};
if (FieldValidation.ValidateFields(values))
{
CanSaveStamp = false;
try
{
StampModel typeData = new StampModel()
{
Title = Title,
};
HttpResponseMessage result = null;
if (isUpdate)
{
typeData.ID = ID;
typeData.CreatedBy = SelectedStamp.CreatedBy;
result = await apiHelper.PutStamp(ParentLayout.LoggedInUser.Token, typeData).ConfigureAwait(false);
}
else
{
typeData.CreatedBy = ParentLayout.LoggedInUser.Name;
result = await apiHelper.PostStamp(ParentLayout.LoggedInUser.Token, typeData).ConfigureAwait(false);
}
if (result.IsSuccessStatusCode)
{
MessageBox.Show($"Stamp Saved Successfully", "Success", MessageBoxButton.OK, MessageBoxImage.Information);
await GetStamps();
ClearFields();
IsUpdate = false;
}
else
{
MessageBox.Show("Error in saving stamp", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
CanSaveStamp = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
CanSaveStamp = true;
}
}
}
public bool UpdateStampName(StampModel stamp)
{
using (var dbUse = new UserContext())
{
StampModel st = dbUse.StampModels.Find(stamp.Id);
if (st == null)
{
return(false);
}
st.Name = stamp.Name;
dbUse.Entry(st).State = EntityState.Modified;
dbUse.SaveChanges();
}
return(true);
}
public async Task <HttpResponseMessage> PostStamp(string token, StampModel stampData)
{
try
{
httpClient.DefaultRequestHeaders.Clear();
httpClient.DefaultRequestHeaders.Accept.Clear();
httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
httpClient.DefaultRequestHeaders.Add("Authorization", $"bearer {token}");
using (HttpResponseMessage response = await httpClient.PostAsJsonAsync("/api/Stamp", stampData))
{
return(response);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public StampModel InOutTranDetail(string visitorId, string terncode, string ternsubcode, string adminlevel)
{
try {
DataTable dt = new DataTable();
StampModel _stampModel = new StampModel();
string sql = " select InOutTran_ID,CarID,CscMain_ID,Indate,Picin1,Picin2,Picin3 ";
sql = sql + " from PkInoutTran ";
sql = sql + " where CscMain_ID = '" + visitorId + "' and CompleteFlag = 0 ";
sql = sql + " order by Indate ";
dt = db.QueryDataTable(sql);
var data_input = (from c in dt.AsEnumerable() select new {
inoutTrainID = c["InOutTran_ID"].ToString(),
license_plate = c["CarID"].ToString(),
Time_IN = c["Indate"].ToString(),
VisitorID = c["CscMain_ID"].ToString(),
PicIn1 = c["Picin1"].ToString(),
PicIn2 = c["Picin2"].ToString(),
PicIn3 = c["Picin3"].ToString()
}).SingleOrDefault();
if (data_input == null)
{
return(null);
}
_stampModel.license_plate = data_input.license_plate;
_stampModel.inoutTrainID = data_input.inoutTrainID;
_stampModel.Time_IN = Convert.ToDateTime(data_input.Time_IN);
_stampModel.VisitorID = data_input.VisitorID;
_stampModel.TotalTime = TotalTime(Convert.ToDateTime(data_input.Time_IN));
_stampModel.PicIn1 = getImage(ConfigurationManager.AppSettings["PathImageCar"].ToString() + data_input.PicIn1);
_stampModel.PicIn2 = getImage(ConfigurationManager.AppSettings["PathImageCar"].ToString() + data_input.PicIn2);
_stampModel.PicIn3 = getImage(ConfigurationManager.AppSettings["PathImageCar"].ToString() + data_input.PicIn3);
DataTable dt_inoutTranStamp = new DataTable();
string sql_inouttranStamp = "select ";
sql_inouttranStamp += " ts.InOutTranstamp_ID,";
sql_inouttranStamp += " ts.datetimestamp, ";
sql_inouttranStamp += " ts.StampCode + ' ' + s.ZDesc as Stamp,";
sql_inouttranStamp += " ts.Active1, ";
sql_inouttranStamp += " d.Zdesc as companyname , ";
sql_inouttranStamp += " ts.Terncode,";
sql_inouttranStamp += " ts.Ternsubcode ";
sql_inouttranStamp += " from pkinouttranstamp Ts ";
sql_inouttranStamp += " left join PkDepartments d on ts.Terncode = d.CompanyID and ts.Ternsubcode = d.DeptID ";
sql_inouttranStamp += " left join PkStamp s on ts.StampCode = s.StampCode ";
sql_inouttranStamp += " where ts.InOutTran_ID = '" + data_input.inoutTrainID + "' order by ts.datetimestamp desc ";
dt_inoutTranStamp = this.db.QueryDataTable(sql_inouttranStamp);
var data_inoutTrainStamp = (from c in dt_inoutTranStamp.AsEnumerable()
select new historyStamp
{
Calculation = Convert.ToInt32(c["Active1"]),
Company = c["companyname"].ToString(),
DateTimeStamp = Convert.ToDateTime(c["datetimestamp"]),
StampCode = c["Stamp"].ToString(),
ternCode = c["Terncode"].ToString(),
ternsubCode = c["Ternsubcode"].ToString(),
InOutTranstamp_ID = c["InOutTranstamp_ID"].ToString()
}).OrderByDescending(c => c.DateTimeStamp).ToList();
_stampModel.StampCodeList = StampCodeList(visitorId, terncode, ternsubcode, adminlevel);
_stampModel.historyStamp_list = data_inoutTrainStamp;
return(_stampModel);
}
catch (Exception ex) {
throw ex;
}
}
