private void GetDetails() { string path = ReadText.ReadFilePath("datapath"); // string filepath = path + "\\ClubInfo.txt"; string birdDetailsPath = path + "\\PigeonDetails\\" + txtMemberID.Text + "\\" + txtrfid.Text + ".txt"; if (EntryList != "" && EntryList.Contains(txtrfid.Text)) { MessageBox.Show("Bird Already Entry.", "Information"); this.txtrfid.Text = ""; } else { if (File.Exists(birdDetailsPath)) { string[] pigeonDetailsCollection = ReadText.ReadTextFile(birdDetailsPath); txtRingNumber.Text = pigeonDetailsCollection[0]; txtSex.Text = pigeonDetailsCollection[3]; txtColor.Text = pigeonDetailsCollection[4]; txtCategory.Text = pigeonDetailsCollection[2]; LoadImage(txtrfid.Text, txtMemberID.Text); Save(); } else { MessageBox.Show("Bird not found!", "Error"); this.txtrfid.Text = ""; this.txtrfid.Focus(); } } }
public static string GetClub() { try { string sysDir = AppDomain.CurrentDomain.BaseDirectory; string filepath = sysDir + "club.txt"; if (!File.Exists(filepath)) { frmSetClub clubform = new frmSetClub(); clubform.ShowDialog(); } else { if (File.Exists(filepath)) { string[] clublist = ReadText.ReadTextFile(filepath); return(clublist[0]); } else { return(""); } } return(""); } catch (Exception ex) { throw ex; } }
private void ReadEntryLogs() { try { DataTable entrylistlogs = new DataTable(); DataColumn dc1 = new DataColumn(); dc1.ColumnName = "Retry"; DataColumn dc2 = new DataColumn(); dc2.ColumnName = "MemberIDNo"; DataColumn dc3 = new DataColumn(); dc3.ColumnName = "TagID"; DataColumn dc4 = new DataColumn(); dc4.ColumnName = "Ring"; DataColumn dc5 = new DataColumn(); dc5.ColumnName = "Remarks"; entrylistlogs.Columns.Add(dc1); entrylistlogs.Columns.Add(dc2); entrylistlogs.Columns.Add(dc3); entrylistlogs.Columns.Add(dc4); entrylistlogs.Columns.Add(dc5); //string path = ReadText.ReadFilePath("datapath"); //string dateString = this.DateRelease.Year.ToString() + this.DateRelease.Month.ToString().PadLeft(2, '0') + this.DateRelease.Day.ToString().PadLeft(2, '0'); string pathSyncApplication = AppDomain.CurrentDomain.BaseDirectory + "SyncApplication"; string filepath = pathSyncApplication + "\\entrylogs.txt"; if (File.Exists(filepath)) { string[] pigeonCollection = ReadText.ReadTextFile(filepath); foreach (string item in pigeonCollection) { string[] value = item.Split('|'); DataRow dr = entrylistlogs.NewRow(); dr["RETRY"] = "RETRY"; dr["MemberIDNo"] = value[0].ToString(); dr["TagID"] = value[1].ToString(); dr["Ring"] = value[2].ToString(); dr["Remarks"] = value[3].ToString(); entrylistlogs.Rows.Add(dr); } } dtList.DataSource = entrylistlogs; //lblcount.Text = "Total Birds: " + entrylistlogs.Rows.Count.ToString(); } catch (Exception ex) { throw ex; } }
private Boolean SavetoFile(string MemberIDNo, string RFID) { try { // string[] pigeonEntry = {RFID}; string path = ReadText.ReadFilePath("datapath"); string dateString = this.dateTimePicker1.Value.Year.ToString() + this.dateTimePicker1.Value.Month.ToString().PadLeft(2, '0') + this.dateTimePicker1.Value.Day.ToString().PadLeft(2, '0'); string entryDirectory = path + "\\entry\\" + dateString; string filepath = entryDirectory + "\\" + MemberIDNo + ".txt"; string[] pigeonEntry = SetPigeonList(ActionType, this.txtRingNumber.Text, RFID).ToArray(); if (File.Exists(filepath)) { File.Delete(filepath); } if (!Directory.Exists(entryDirectory)) { Directory.CreateDirectory(entryDirectory); } if (File.Exists(filepath)) { string[] entryList = ReadText.ReadTextFile(filepath); if (entryList.Contains(RFID)) { MessageBox.Show("Bird Already Entry."); return(false); } else { System.IO.File.WriteAllLines(filepath, pigeonEntry); //entrylist } } else { System.IO.File.WriteAllLines(filepath, pigeonEntry); //entrylist } return(true); } catch (Exception ex) { throw ex; } }
private void GetMemberName(string memberID) { try { string path = ReadText.ReadFilePath("datapath"); string filepath = path + "\\members\\" + memberID + ".txt"; if (File.Exists(filepath)) { string[] memberDetails = ReadText.ReadTextFile(filepath); this.txtName.Text = memberDetails[1].ToString(); } } catch (Exception ex) { throw ex; } }
private bool CheckRemarks(string remarks, string filepath) { try { if (File.Exists(filepath)) { string[] pigeonCollection = ReadText.ReadTextFile(filepath); if (pigeonCollection.Contains(remarks)) { return(true); } } return(false); } catch (Exception ex) { throw ex; } }
static void Main(string[] args) { string path = AppDomain.CurrentDomain.BaseDirectory; string filepath = path + "resultinfo.txt"; string Actionfilepath = path + "Action.txt"; string[] pigeonCollection = ReadText.ReadTextFile(filepath); string[] actionValue = ReadText.ReadTextFile(Actionfilepath); if (actionValue[0].ToUpper() == "RESULTRACE") { MemberID = pigeonCollection[0]; DateRelease = pigeonCollection[1]; DataPath = pigeonCollection[2].Trim(); GetResult("RACE"); } if (actionValue[0].ToUpper() == "RESULTTRAINING") { MemberID = pigeonCollection[0]; DateRelease = pigeonCollection[1]; DataPath = pigeonCollection[2].Trim(); GetResult("TRAINING"); } else if (actionValue[0].ToUpper() == "RESULTDB") { ClubName = pigeonCollection[0]; DateRelease = pigeonCollection[1]; DataPath = pigeonCollection[2].Trim(); ReleaseDate = Convert.ToDateTime(pigeonCollection[3]); SyncResultToDatabase(); } else if (actionValue[0].ToUpper() == "ENTRYDB") { ClubName = pigeonCollection[0]; DateRelease = pigeonCollection[1]; DataPath = pigeonCollection[2].Trim(); ReleaseDate = Convert.ToDateTime(pigeonCollection[3]); SyncEntryToDatabase(); } }
private void SetClub_Load(object sender, EventArgs e) { string sysDir = AppDomain.CurrentDomain.BaseDirectory; string filepath = sysDir + "club.txt"; string datapath = sysDir + "datapath.inf"; this.textBox1.Focus(); if (File.Exists(filepath)) { string[] clublist = ReadText.ReadTextFile(filepath); this.textBox1.Text = clublist[0].ToString().Replace(@"\", ""); this.button1.Text = "Update"; } if (File.Exists(datapath)) { string[] pathlist = ReadText.ReadTextFile(datapath); this.txtDataPath.Text = pathlist[0].ToString(); //this.button1.Text = "Update"; } }
private void GetMemberName(string memberID) { try { string path = ReadText.ReadFilePath("datapath"); string filepath = path + "\\members\\" + memberID + ".txt"; if (File.Exists(filepath)) { string[] memberDetails = ReadText.ReadTextFile(filepath); this.txtName.Text = memberDetails[1].ToString(); } else { MessageBox.Show("Invalid MemberID", "Error"); ClearControl(); } } catch (Exception ex) { throw ex; } }
private void UpdateLogs(string remarks, string filepath) { try { if (File.Exists(filepath)) { string[] pigeonCollection = ReadText.ReadTextFile(filepath); File.Delete(filepath); foreach (var item in pigeonCollection) { if (item != remarks) { if (File.Exists(filepath)) { using (StreamWriter sw = File.AppendText(filepath)) { sw.WriteLine(item); } } else { using (StreamWriter sw = File.CreateText(filepath)) { sw.WriteLine(item); } } } } } } catch (Exception ex) { throw ex; } }
private void GetPigeonList() { try { DataTable pigeonList = new DataTable(); DataColumn dc1 = new DataColumn(); dc1.ColumnName = " "; DataColumn dc2 = new DataColumn(); dc2.ColumnName = " "; DataColumn dc3 = new DataColumn(); dc3.ColumnName = "SeqNo"; DataColumn dc4 = new DataColumn(); dc4.ColumnName = "BandNumber"; DataColumn dc5 = new DataColumn(); dc5.ColumnName = "TagID"; DataColumn dc6 = new DataColumn(); dc6.ColumnName = "Name"; DataColumn dc7 = new DataColumn(); dc7.ColumnName = "MobileNumner"; //DataColumn dc8 = new DataColumn(); //dc8.ColumnName = "Color"; pigeonList.Columns.Add(dc1); pigeonList.Columns.Add(dc2); pigeonList.Columns.Add(dc3); pigeonList.Columns.Add(dc4); pigeonList.Columns.Add(dc5); pigeonList.Columns.Add(dc6); pigeonList.Columns.Add(dc7); //pigeonList.Columns.Add(dc8); string path = ReadText.ReadFilePath("datapath"); string filepath = path + "\\pigeonlist\\" + MemberID + ".txt"; if (File.Exists(filepath)) { string[] pigeonCollection = ReadText.ReadTextFile(filepath); int seqNumber = 1; foreach (string item in pigeonCollection) { string[] value = item.Split('|'); DataRow dr = pigeonList.NewRow(); dr[" "] = "ADD"; dr[" "] = "REMOVE"; dr["SeqNo"] = seqNumber.ToString(); dr["BandNumber"] = value[1].ToString(); dr["TagID"] = value[2].ToString(); //string path = ReadText.ReadFilePath("datapath"); string pigeonMobileListPath = path + "\\PigeonMobileList\\" + value[2].ToString() + ".txt"; if (File.Exists(pigeonMobileListPath)) { string[] pigeonMobileCollection = ReadText.ReadTextFile(pigeonMobileListPath); string[] values = pigeonMobileCollection[0].ToString().Split('|'); dr["Name"] = values[0].ToString().Trim(); dr["MobileNumner"] = values[1].ToString().Trim(); } pigeonList.Rows.Add(dr); seqNumber++; } } dataGridView1.DataSource = pigeonList; lblcount.Text = "Total Birds: " + pigeonList.Rows.Count.ToString(); } catch (Exception ex) { throw ex; } }
private void GetPigeonList(string memberid) { try { DataTable pigeonList = new DataTable(); //DataColumn dc1 = new DataColumn(); //dc1.ColumnName = "EDIT"; //DataColumn dc2 = new DataColumn(); //dc2.ColumnName = "DELETE"; DataColumn dc2 = new DataColumn(); dc2.ColumnName = "SeqID"; DataColumn dc4 = new DataColumn(); dc4.ColumnName = "BandNumber"; DataColumn dc5 = new DataColumn(); dc5.ColumnName = "TagID"; DataColumn dc6 = new DataColumn(); dc6.ColumnName = "Category"; DataColumn dc7 = new DataColumn(); dc7.ColumnName = "Sex"; DataColumn dc8 = new DataColumn(); dc8.ColumnName = "Color"; DataColumn dc3 = new DataColumn(); dc3.ColumnName = "Arrival"; DataColumn dc9 = new DataColumn(); dc9.ColumnName = "Flight"; DataColumn dc10 = new DataColumn(); dc10.ColumnName = "Speed"; //pigeonList.Columns.Add(dc1); pigeonList.Columns.Add(dc2); pigeonList.Columns.Add(dc4); pigeonList.Columns.Add(dc5); pigeonList.Columns.Add(dc6); pigeonList.Columns.Add(dc7); pigeonList.Columns.Add(dc8); pigeonList.Columns.Add(dc3); pigeonList.Columns.Add(dc9); pigeonList.Columns.Add(dc10); string path = ReadText.ReadFilePath("datapath"); string dateString = this.dateTimePicker1.Value.Year.ToString() + this.dateTimePicker1.Value.Month.ToString().PadLeft(2, '0') + this.dateTimePicker1.Value.Day.ToString().PadLeft(2, '0'); //string entryDirectory = path + "entry\\" + dateString; //string filepath = entryDirectory + "\\" + memberid + ".txt"; string resultDirectory = path + "\\result\\" + dateString; string filepath = resultDirectory + "\\" + memberid + ".txt"; //string filepathList = entryDirectory + "\\" + MemberID + ".txt"; if (File.Exists(filepath)) { string[] entryCollection = ReadText.ReadTextFile(filepath); int counter = 1; foreach (var rfid in entryCollection) { string birdDetailsPath = path + "\\PigeonDetails\\" + memberid + "\\" + rfid + ".txt"; string[] pigeonDetailsCollection = ReadText.ReadTextFile(birdDetailsPath); DataRow dr = pigeonList.NewRow(); //dr["EDIT"] = "EDIT"; //dr["DELETE"] = "DELETE"; dr["SeqID"] = counter; dr["BandNumber"] = pigeonDetailsCollection[0].ToString(); dr["TagID"] = pigeonDetailsCollection[1].ToString(); dr["Category"] = pigeonDetailsCollection[2].ToString(); dr["Color"] = pigeonDetailsCollection[4].ToString(); dr["Sex"] = pigeonDetailsCollection[3].ToString(); String resultDetailsPath = resultDirectory + "\\" + memberid + "\\" + rfid + ".txt"; if (File.Exists(resultDetailsPath)) { string[] resultDetails = ReadText.ReadTextFile(resultDetailsPath); dr["Arrival"] = resultDetails[3] + " " + resultDetails[4]; if (resultDetails.Count() > 5) { dr["Flight"] = resultDetails[5]; dr["Speed"] = resultDetails[6]; } } pigeonList.Rows.Add(dr); counter++; } } dtList.DataSource = pigeonList; lblcount.Text = "Total Birds: " + pigeonList.Rows.Count.ToString(); } catch (Exception ex) { throw ex; } }
private static void SyncEntryToDatabase() { try { string path = DataPath; string dateString = DateRelease; string rootApplicationDirectory = AppDomain.CurrentDomain.BaseDirectory; string entryDirectory = path + "entry\\" + dateString; String EntryLogs = rootApplicationDirectory + "\\entrylogs.txt"; //delete log file if (File.Exists(EntryLogs)) { File.Delete(EntryLogs); } if (Directory.Exists(entryDirectory)) { String[] filelist = Directory.GetFiles(entryDirectory); foreach (var item in filelist) { string filepath = item; string[] filename = filepath.Split('\\'); if (File.Exists(filepath)) { string[] entryList = ReadText.ReadTextFile(filepath); string[] filenameValue = filename[filename.Length - 1].Split('.'); foreach (var entry in entryList) { string bandedFileName = path + "PigeonDetails\\" + filenameValue[0] + "\\" + entry + ".txt"; string MobileFileName = path + "\\PigeonMobileList\\" + entry + ".txt"; if (File.Exists(bandedFileName)) { string[] pigeondetails = ReadText.ReadTextFile(bandedFileName); BusinessLayer.EclockEntryBLL entryBll = new EclockEntryBLL(); DomainObjects.Entry entryObject = new DomainObjects.Entry(); entryObject.Clubname = ClubName; entryObject.MemberIDNo = filenameValue[0]; entryObject.ReleaseDate = ReleaseDate; entryObject.RingNumber = pigeondetails[0]; entryObject.RaceCategoryName = pigeondetails[2]; entryObject.RaceCategoryGroupName = "EClock"; entryObject.RFID = entry; entryObject.MobileNumber = ""; if (File.Exists(MobileFileName)) { string[] pigeonMobileCollection = ReadText.ReadTextFile(MobileFileName); string[] values = pigeonMobileCollection[0].ToString().Split('|'); entryObject.MobileNumber = values[1].ToString().Trim(); } DataSet dtResult = new DataSet(); dtResult = entryBll.EclockEntrySave(entryObject); if (dtResult.Tables.Count > 0) { if (dtResult.Tables[0].Rows.Count > 0) { String Remarks = dtResult.Tables[0].Rows[0]["Remarks"].ToString(); if (Remarks.ToUpper() != "SUCCESS") { String LogContents = filenameValue[0] + "|" + entry + "|" + pigeondetails[0] + "|" + Remarks + "|"; Console.WriteLine("----------------"); Console.WriteLine(filenameValue[0]); Console.WriteLine(entry); Console.WriteLine(pigeondetails[0]); Console.WriteLine(Remarks); Console.WriteLine("----------------"); if (File.Exists(EntryLogs)) { using (StreamWriter sw = File.AppendText(EntryLogs)) { sw.WriteLine(LogContents); } } else { using (StreamWriter sw = File.CreateText(EntryLogs)) { sw.WriteLine(LogContents); } } } else { Console.WriteLine("----------------"); Console.WriteLine(filenameValue[0]); Console.WriteLine(entry); Console.WriteLine(pigeondetails[0]); Console.WriteLine(Remarks); Console.WriteLine("----------------"); } } } } } } } } } catch (Exception ex) { throw ex; } }
private static void GetResult(string action) { try { Eclock eclock = new Eclock(); string serialPort = eclock.GetPort(); string[] ports = SerialPort.GetPortNames(); string comPortNumber = ""; string rtype = ""; if (action == "TRAINING") { rtype = "T"; } foreach (var item in ports) { if (serialPort.Contains(item)) { comPortNumber = item; } } SerialPort comPort = new SerialPort(comPortNumber, 9600, Parity.None, 8, StopBits.One); if (!String.IsNullOrEmpty(comPortNumber)) { DataPath = DataPath.Trim(); string entryDirectory = DataPath + "entry\\" + DateRelease; string filepath = entryDirectory + "\\" + MemberID + ".txt"; if (File.Exists(filepath)) { string[] entryCollection = ReadText.ReadTextFile(filepath); string resultDirectory = DataPath + "result\\" + DateRelease; string memberDirectory = resultDirectory + "\\" + MemberID; string filepathList = resultDirectory + "\\" + MemberID + ".txt"; if (File.Exists(filepathList)) { File.Delete(filepathList); } eclock.SendData("$Stat$", comPort); System.Threading.Thread.Sleep(1000); foreach (var item in entryCollection) { bool transmit = false; while (!transmit) { //eclock.SendData(, comPort); String inComingData = eclock.ReceiveDataResult("$Race$" + rtype + item + "#", comPort); if (inComingData != "") { PrintData(inComingData, item); //eclock.SendData("Done" + item + "#", commPort); transmit = true; } } } eclock.SendData("$Done$|#", comPort); } } //Console.ReadLine(); Console.WriteLine("Result Sync Completed...."); System.Threading.Thread.Sleep(2000); } catch (Exception ex) { throw ex; } }
private void GetPigeonList(string memberid) { try { DataTable pigeonList = new DataTable(); DataColumn dc1 = new DataColumn(); dc1.ColumnName = "EDIT"; DataColumn dc2 = new DataColumn(); dc2.ColumnName = "DELETE"; DataColumn dc3 = new DataColumn(); dc3.ColumnName = "SeqNo"; DataColumn dc4 = new DataColumn(); dc4.ColumnName = "BandNumber"; DataColumn dc5 = new DataColumn(); dc5.ColumnName = "TagID"; DataColumn dc6 = new DataColumn(); dc6.ColumnName = "Category"; DataColumn dc7 = new DataColumn(); dc7.ColumnName = "Sex"; DataColumn dc8 = new DataColumn(); dc8.ColumnName = "Color"; pigeonList.Columns.Add(dc1); pigeonList.Columns.Add(dc2); pigeonList.Columns.Add(dc3); pigeonList.Columns.Add(dc4); pigeonList.Columns.Add(dc5); pigeonList.Columns.Add(dc6); pigeonList.Columns.Add(dc7); pigeonList.Columns.Add(dc8); //add test ring on the top list DataRow drtest = pigeonList.NewRow(); drtest["EDIT"] = ""; drtest["DELETE"] = ""; drtest["SeqNo"] = 1.ToString(); drtest["BandNumber"] = "TEST RING"; drtest["TagID"] = this.txtTestRing.Text; drtest["Category"] = "BOTH"; drtest["Color"] = "NA"; drtest["Sex"] = "NA"; pigeonList.Rows.Add(drtest); string path = ReadText.ReadFilePath("datapath"); string filepath = path + "\\pigeonlist\\" + memberid + ".txt"; if (File.Exists(filepath)) { string[] pigeonCollection = ReadText.ReadTextFile(filepath); int seqNumber = 2; foreach (string item in pigeonCollection) { string[] value = item.Split('|'); DataRow dr = pigeonList.NewRow(); dr["EDIT"] = "EDIT"; dr["DELETE"] = "DELETE"; dr["SeqNo"] = seqNumber.ToString(); dr["BandNumber"] = value[1].ToString(); dr["TagID"] = value[2].ToString(); dr["Category"] = value[3].ToString(); dr["Color"] = value[4].ToString(); dr["Sex"] = value[5].ToString(); pigeonList.Rows.Add(dr); seqNumber++; } } dtList.DataSource = pigeonList; lblcount.Text = "Total Birds: " + pigeonList.Rows.Count.ToString(); } catch (Exception ex) { throw ex; } }
private string[] GetPigeonForEntry(string path) { return(ReadText.ReadTextFile(path)); }
private static void SyncResultToDatabase() { try { string path = DataPath; string dateString = DateRelease; string rootApplicationDirectory = AppDomain.CurrentDomain.BaseDirectory; string resultDirectory = path + "result\\" + dateString; string resultLogs = rootApplicationDirectory + "resultlogs.txt"; //delete log file if (File.Exists(resultLogs)) { File.Delete(resultLogs); } if (Directory.Exists(resultDirectory)) { String[] filelist = Directory.GetFiles(resultDirectory); foreach (var item in filelist) { string filepath = item; string[] filename = filepath.Split('\\'); if (File.Exists(filepath)) { string[] resultList = ReadText.ReadTextFile(filepath); string[] memberid = filename[filename.Length - 1].Split('.'); //result is value is RFID foreach (var result in resultList) { string resultFileName = resultDirectory + "\\" + memberid[0] + "\\" + result + ".txt"; if (File.Exists(resultFileName)) { string[] resultdetails = ReadText.ReadTextFile(resultFileName); BusinessLayer.ResultBLL entryBll = new ResultBLL(); //sample ECLOCK 0001 15204188 19/07/05 07:48:18 String ResultStringFormat = "ECLOCK " + resultdetails[0] + " " + resultdetails[1] + " " + resultdetails[3] + " " + resultdetails[4]; DomainObjects.Result dObject = new DomainObjects.Result { ClubName = ClubName, SMSContent = ResultStringFormat, ActionFrom = "E-Clock Apps" }; DataSet dtResult = new DataSet(); dtResult = entryBll.EclockResultSave(dObject); if (dtResult.Tables.Count > 0) { if (dtResult.Tables[0].Rows.Count > 0) { String Remarks = dtResult.Tables[0].Rows[0]["Remarks"].ToString(); if (!Remarks.ToUpper().Contains("SUCCESS")) { //string[] rdetails = Remarks.Split('|'); String LogContents = memberid[0] + "|" + result + "|" + resultdetails[3] + "|" + Remarks + "|"; Console.WriteLine("----------------"); Console.WriteLine(memberid[0]); Console.WriteLine(result); Console.WriteLine(resultdetails[0]); Console.WriteLine(Remarks); Console.WriteLine("----------------"); if (File.Exists(resultLogs)) { using (StreamWriter sw = File.AppendText(resultLogs)) { sw.WriteLine(LogContents); } } else { using (StreamWriter sw = File.CreateText(resultLogs)) { sw.WriteLine(LogContents); } } } else { string[] rdetails = Remarks.Split('|'); //String LogContents = memberid[0] + "|" + result + "|" + resultdetails[3] + "|" + Remarks + "|"; Console.WriteLine("----------------"); Console.WriteLine(memberid[0]); Console.WriteLine(result); Console.WriteLine(resultdetails[0]); Console.WriteLine(rdetails[1]); //distance Console.WriteLine(rdetails[2]); //flight Console.WriteLine(rdetails[3]); //speed Console.WriteLine(rdetails[0]); //remarks Console.WriteLine("----------------"); if (File.Exists(resultFileName)) { string[] resultdetail = new string[] { rdetails[2], rdetails[3] }; resultdetails = resultdetails.Concat(resultdetail).Distinct().ToArray(); //string[] datacol = { MemberID, item, value[1], value[2], value[3] }; System.IO.File.WriteAllLines(resultFileName, resultdetails); //memberpigeonlist //using (StreamWriter sw = File.AppendText(resultFileName)) //{ // sw.WriteLine(rdetails[2]); //} //using (StreamWriter sw = File.AppendText(resultFileName)) //{ // sw.WriteLine(rdetails[3]); //} } } } } } } } } } } catch (Exception ex) { throw ex; } }
private void RetryEntry(string RFID, string MemberID, string OldRemarks) { try { string path = ReadText.ReadFilePath("datapath"); string dateString = this.DateRelease.Year.ToString() + this.DateRelease.Month.ToString().PadLeft(2, '0') + this.DateRelease.Day.ToString().PadLeft(2, '0'); string entryDirectory = path + "\\entry\\" + dateString; string pathSyncApplication = AppDomain.CurrentDomain.BaseDirectory + "SyncApplication"; string EntryLogs = pathSyncApplication + "\\entrylogs.txt"; string bandedFileName = path + "\\PigeonDetails\\" + MemberID + "\\" + RFID + ".txt"; string MobileFileName = path + "\\PigeonMobileList\\" + RFID + ".txt"; if (File.Exists(bandedFileName)) { string[] pigeondetails = ReadText.ReadTextFile(bandedFileName); BusinessLayer.EclockEntryBLL entryBll = new EclockEntryBLL(); DomainObjects.Entry entryObject = new DomainObjects.Entry(); entryObject.Clubname = ClubName; entryObject.MemberIDNo = MemberID; entryObject.ReleaseDate = this.DateRelease; entryObject.RingNumber = pigeondetails[0]; entryObject.RaceCategoryName = pigeondetails[2]; entryObject.MobileNumber = ""; entryObject.RaceCategoryGroupName = "EClock"; entryObject.RFID = RFID; if (File.Exists(MobileFileName)) { string[] pigeonMobileCollection = ReadText.ReadTextFile(MobileFileName); string[] values = pigeonMobileCollection[0].ToString().Split('|'); entryObject.MobileNumber = values[1].ToString().Trim(); } DataSet dtResult = new DataSet(); dtResult = entryBll.EclockEntrySave(entryObject); if (dtResult.Tables.Count > 0) { if (dtResult.Tables[0].Rows.Count > 0) { String Remarks = dtResult.Tables[0].Rows[0]["Remarks"].ToString(); if (Remarks.ToUpper() != "SUCCESS") { String LogContents = MemberID + "|" + RFID + "|" + pigeondetails[0] + "|" + Remarks + "|"; string removeFromLogsPath = pathSyncApplication + "\\entrylogs.txt"; if (!CheckRemarks(LogContents, removeFromLogsPath)) { if (File.Exists(EntryLogs)) { using (StreamWriter sw = File.AppendText(EntryLogs)) { sw.WriteLine(LogContents); } } else { using (StreamWriter sw = File.CreateText(EntryLogs)) { sw.WriteLine(LogContents); } } } MessageBox.Show("Error detected.", "Error"); } else { string removeFromLogsPath = pathSyncApplication + "\\entrylogs.txt"; String removeFromLogs = MemberID + "|" + RFID + "|" + pigeondetails[0] + "|" + OldRemarks + "|"; UpdateLogs(removeFromLogs, removeFromLogsPath); MessageBox.Show("Eclock entry sync to database.", "Eclock Sync"); } } } } ReadEntryLogs(); } catch (Exception ex) { throw ex; } }
private void RetryResult(string RFID, string MemberID, string OldRemarks) { try { string path = ReadText.ReadFilePath("datapath"); string pathSyncApplication = AppDomain.CurrentDomain.BaseDirectory + "SyncApplication"; string dateString = this.DateRelease.Year.ToString() + this.DateRelease.Month.ToString().PadLeft(2, '0') + this.DateRelease.Day.ToString().PadLeft(2, '0'); string resultDirectory = path + "\\result\\" + dateString; string resultLogs = pathSyncApplication + "\\resultlogs.txt"; string resultFileName = resultDirectory + "\\" + MemberID + "\\" + RFID + ".txt"; if (File.Exists(resultFileName)) { string[] resultdetails = ReadText.ReadTextFile(resultFileName); BusinessLayer.ResultBLL entryBll = new ResultBLL(); //sample ECLOCK 0001 15204188 19/07/05 07:48:18 String ResultStringFormat = "ECLOCK " + resultdetails[0] + " " + resultdetails[1] + " " + resultdetails[3] + " " + resultdetails[4]; DomainObjects.Result dObject = new DomainObjects.Result { ClubName = ClubName, SMSContent = ResultStringFormat, ActionFrom = "E-Clock Apps" }; DataSet dtResult = new DataSet(); dtResult = entryBll.EclockResultSave(dObject); if (dtResult.Tables.Count > 0) { if (dtResult.Tables[0].Rows.Count > 0) { String Remarks = dtResult.Tables[0].Rows[0]["Remarks"].ToString(); if (Remarks.ToUpper() != "SUCCESS") { String LogContents = MemberID + "|" + RFID + "|" + resultdetails[3] + "|" + Remarks + "|"; string removeFromLogsPath = pathSyncApplication + "\\resultlogs.txt"; if (!CheckRemarks(LogContents, removeFromLogsPath)) { if (File.Exists(resultLogs)) { using (StreamWriter sw = File.AppendText(resultLogs)) { sw.WriteLine(LogContents); } } else { using (StreamWriter sw = File.CreateText(resultLogs)) { sw.WriteLine(LogContents); } } } } else { //string pathSyncApplication = AppDomain.CurrentDomain.BaseDirectory + "SyncApplication"; string removeFromLogsPath = pathSyncApplication + "\\resultlogs.txt"; String removeFromLogs = MemberID + "|" + RFID + "|" + resultdetails[3] + "|" + OldRemarks + "|"; UpdateLogs(removeFromLogs, removeFromLogsPath); MessageBox.Show("Eclock entry sync to database.", "Eclock Sync"); } } } } ReadResultLogs(); } catch (Exception ex) { throw ex; } }
private void SyncBanded() { Eclock eclock = new Eclock(); string serialPort = eclock.GetPort(); string[] ports = SerialPort.GetPortNames(); string commPort = ""; foreach (var item in ports) { if (serialPort.Contains(item)) { commPort = item; } } if (!String.IsNullOrEmpty(commPort)) { //eclock.SyncTime(commPort); DataTable dt = new DataTable(); dt = DataList; eclock.SendData("$Stat$", commPort); progressBar1.Maximum = dt.Rows.Count; System.Threading.Thread.Sleep(2500); int counter = 1; foreach (DataRow item in dt.Rows) { if (counter >= DataStartIndex && counter <= DataEndtIndex) { string path = ReadText.ReadFilePath("datapath"); string pigeonMobileListPath = path + "\\PigeonMobileList\\" + item["TagID"].ToString() + ".txt"; string mobileNumber = ""; if (File.Exists(pigeonMobileListPath)) { string[] pigeonMobileCollection = ReadText.ReadTextFile(pigeonMobileListPath); string[] values = pigeonMobileCollection[0].ToString().Split('|'); mobileNumber = values[1].ToString().Trim(); } String bandedData = "$BaNd$" + ClubName + "|" + item["BandNumber"].ToString() + "|" + item["TagID"].ToString() + "|" + item["Category"].ToString() + "|" + item["Color"].ToString() + "|" + item["Sex"].ToString().Substring(0, 1) + (mobileNumber != "" ? "|" + mobileNumber + "|#" : "|#"); eclock.SendData(bandedData, commPort); this.txtCount.Text = counter.ToString(); System.Threading.Thread.Sleep(2500); } progressBar1.Value = counter; counter++; } eclock.SendData("$Done$|#", commPort); MessageBox.Show("Data sync", "Eclock Sync"); this.Close(); } }