public CardRegistrationManagement(MainWindow owner)
{
InitializeComponent();
this.IsEnabled = false;
this.Unloaded += new RoutedEventHandler(UserControl_Unloaded);
_kiosk = owner;
try
{
using (DB_Manager.CardAndCarManagement ccm = new DB_Manager.CardAndCarManagement())
{
DataTable dt = ccm.GetData(_kiosk.rfidReader.LastID.Replace(" ", ""));
if (dt != null)
{
dgv1.ItemsSource = dt.DefaultView;
}
else
{
DataTable table = new DataTable();
table.Columns.Add("RFID", typeof(string));
table.Columns.Add("ทะเบียนรถ", typeof(string));
table.Columns.Add("วันที่บันทึก", typeof(DateTime));
table.Columns.Add("วันที่หมดอายุ", typeof(DateTime));
table.Columns.Add("สถานะ", typeof(string));
table.Rows.Add(_kiosk.rfidReader.LastID.Replace(" ", ""), " -", DateTime.Now.Date, null, "* NEW");
dgv1.ItemsSource = table.DefaultView;
}
}
}
catch (Exception ex) { }
this.IsEnabled = true;
}
private void ThreadProc_OperatorCardActivation()
{
try
{
Thread.Sleep(100); // wait for progres bar
if (_kiosk.Testing) // สำหรับทดสอบสร้างหน้าต่างเท่านั้น
{
using (DB_Manager.CardAndCarManagement opm = new DB_Manager.CardAndCarManagement())
{
Thread.Sleep(1000);
string carTag = string.Empty;
if (!opm.GetCarTag(_kiosk.rfidReader.LastID.Replace(" ", ""), out carTag))
{
Helper.ShowNewPage(_kiosk, this, PageName.Warning_OptCarTagInfoNotFound);
}
else
{
_kiosk.CurrentCarTag = carTag;
using (DB_Manager.BO23TestManagement tm = new DB_Manager.BO23TestManagement())
{ _kiosk.CurrentOnlineDSBO23 = tm.GetBO23(_kiosk.CurrentCarTag); }
Helper.ShowNewPage(_kiosk, this, PageName.OptBO23);
}
}
}
else
{
using (DB_Manager.CardAndCarManagement opm = new DB_Manager.CardAndCarManagement())
{
string carTag = string.Empty;
if (!opm.GetCarTag(_kiosk.rfidReader.LastID.Replace(" ", ""), out carTag))
{
Helper.ShowNewPage(_kiosk, this, PageName.Warning_OptCarTagInfoNotFound);
}
else
{
_kiosk.CurrentCarTag = carTag;
ServiceReference1.SearchModel result;
if (OnlineService.SearchBO23(_kiosk.OrgCode, _kiosk.CurrentCarTag, out result))
{
_kiosk.CurrentOnlineDSBO23 = result.ds;
Helper.ShowNewPage(_kiosk, this, PageName.OptBO23);
}
else
{
Helper.ShowNewPage(_kiosk, this, PageName.Warning_OptCarTagInfoNotFound);
}
}
}
}
}
catch (Exception ex)
{
_kiosk.log.AppendText(ex.Message);
System.Diagnostics.Debug.WriteLine(ex.Message);
Helper.ShowNewPage(_kiosk, this, PageName.Error_Systematic);
}
}
public static bool RegSaveSelectedCardInfo(MainWindow kiosk)
{
try
{
using (DB_Manager.CardAndCarManagement ccm = new DB_Manager.CardAndCarManagement())
{
DataRow dr = DB_Manager.CardAndCarManagement.FormatDataTable().NewRow();
dr["OID"] = kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["OID"]];
dr["RFIDCode"] = kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["RFIDCode"]];
dr["CarTag"] = kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["CarTag"]];
dr["CreatedDate"] = kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["CreatedDate"]];
dr["ExpiryDate"] = kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["ExpiryDate"]];
dr["IsActive"] = kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["IsActive"]];
dr["Comment"] = DBNull.Value;
int resCode;
string resDesc = string.Empty;
string logText = "Update CardAndCarManagement";
kiosk.log.AppendText(logText);
System.Diagnostics.Debug.WriteLine(logText);
if (!ccm.Update(dr, out resCode, out resDesc))
{
logText = resDesc;
kiosk.log.AppendText(logText);
System.Diagnostics.Debug.WriteLine(logText);
return(false);
}
else
{
logText = resDesc;
kiosk.log.AppendText(logText);
System.Diagnostics.Debug.WriteLine(logText);
return(true);
}
}
}
catch (Exception ex) { kiosk.log.AppendText(ex.Message); return(false); }
}
void loadData()
{
try
{
using (DB_Manager.CardAndCarManagement ccm = new DB_Manager.CardAndCarManagement())
{
DataTable table = new DataTable();
table.Columns.Add(DB_Manager.CardAndCarManagement.TableDict["RFIDCode"], typeof(string));
table.Columns.Add(DB_Manager.CardAndCarManagement.TableDict["CarTag"], typeof(string));
table.Columns.Add(DB_Manager.CardAndCarManagement.TableDict["CreatedDate"], typeof(DateTime));
table.Columns.Add(DB_Manager.CardAndCarManagement.TableDict["ExpiryDate"], typeof(DateTime));
table.Columns.Add(DB_Manager.CardAndCarManagement.TableDict["IsActive"], typeof(string));
table.Rows.Add(
(_kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["RFIDCode"]]),
(_kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["CarTag"]]),
(_kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["CreatedDate"]]),
(_kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["ExpiryDate"]]),
(_kiosk.SelectedRegCarInfo[DB_Manager.CardAndCarManagement.TableDict["IsActive"]]));
dgv1.ItemsSource = table.DefaultView;
}
}
catch { }
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
if (OnlineService.SearchCarTag(txtCarTag.Text))
{
using (DB_Manager.CardAndCarManagement ccm = new DB_Manager.CardAndCarManagement())
{
DataTable dt;
dt = DB_Manager.CardAndCarManagement.FormatDataTable();
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
dt.Rows[0]["RFIDCode"] = txtRFID.Text;
dt.Rows[0]["CarTag"] = txtCarTag.Text;
dt.Rows[0]["CarDescription"] = "-";
try { dt.Rows[0]["ExpiryDate"] = dpExpireDate.SelectedDate; }
catch { }
dt.Rows[0]["IsActive"] = "ACTIVE";
dt.Rows[0]["Comment"] = "-";
int resCode;
string resDesc;
ccm.Insert(dt.Rows[0], out resCode, out resDesc);
}
}
else
{
_kiosk.log.AppendText("SearchCarTag:" + txtCarTag.Text + " false.");
System.Diagnostics.Debug.WriteLine("SearchCarTag:" + txtCarTag.Text + " false.");
}
}
catch (Exception ex)
{
_kiosk.log.AppendText(ex.Message);
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
