private void btnSave_Click(object sender, EventArgs e)
{
Stream myStream;
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "txt files (*.csv)|*.csv";
saveFileDialog1.FilterIndex = 2;
saveFileDialog1.RestoreDirectory = true;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
if ((myStream = saveFileDialog1.OpenFile()) != null)
{
// Code to write the stream goes here.
DataSet1TableAdapters.tb_trackingTableAdapter tb_tracking = new DataSet1TableAdapters.tb_trackingTableAdapter();
DataTable dt = tb_tracking.GetData();
Console.WriteLine(dt.Rows.Count);
StreamWriter writer = new StreamWriter(myStream);
foreach (DataRow dr in dt.Rows)
{
String str = dr["asset_id"] + "," + dr["place_id"] + "," + dr["status"];
writer.WriteLine(str);
}
writer.Dispose();
writer.Close();
myStream.Close();
}
}
}
public void ScanData()
{
int result;
if (Int32.TryParse(txtCode.Text, out result))
{
Int32 code = Int32.Parse(txtCode.Text);
DataSet1TableAdapters.tb_assetTableAdapter tb_asset = new DataSet1TableAdapters.tb_assetTableAdapter();
DataTable dt = tb_asset.GetDataByRfidCode(code.ToString());
// MessageBox.Show(dt.Rows.Count.ToString());
DataSet1TableAdapters.tb_trackingTableAdapter tb_tracking = new DataSet1TableAdapters.tb_trackingTableAdapter();
Int32 place_id = Int32.Parse(dlPlace.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
Int32 asset_id = Int32.Parse(dr["id"].ToString());
String check_date = DateTime.Now.ToString("yyyy-MM-dd");;
if (dr["place_id"].ToString() != dlPlace.SelectedValue.ToString())
{
// Console.WriteLine("Wrong Place");
tb_tracking.InsertQuery(asset_id, place_id, check_date, 2);
tb_asset.UpdatePlace(2, 1, place_id, Convert.ToInt32(dr["id"].ToString()), Convert.ToInt32(dr["id"].ToString()));
DataSet1TableAdapters.tb_placeTableAdapter tb_place = new DataSet1TableAdapters.tb_placeTableAdapter();
DataTable dt_place = tb_place.GetDataById(Int32.Parse(dr["place_id"].ToString()));
DataRow dr_place = dt_place.Rows[0];
lbStatus.Text = "ผิดที่ [ในระบบ : " + dr_place["place_name"] + " ]";
lbStatus.BackColor = Color.Red;
}
else
{
tb_tracking.InsertQuery(asset_id, place_id, check_date, 1);
tb_asset.UpdatePlace(1, 1, place_id, Convert.ToInt32(dr["id"].ToString()), Convert.ToInt32(dr["id"].ToString()));
lbStatus.Text = "พบ";
lbStatus.BackColor = this.BackColor;
}
}
else
{
lbStatus.Text = "ไม่พบ";
lbStatus.BackColor = Color.Red;
}
txtCode.Text = "";
txtCode.Focus();
LoadDataToGrid(place_id.ToString());
ShowHighlight(code.ToString());
}
}
