public DataSet EclockResultSave(DomainObjects.Result result)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("EclockCommand");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@SMSContent", result.SMSContent);
dbconn.sqlComm.Parameters.AddWithValue("@ActionFrom", result.ActionFrom);
dbconn.sqlComm.Parameters.AddWithValue("@ClubName", result.ClubName);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet EclockResultSave(DomainObjects.Result result)
{
try
{
DataLayer.ResultDal resultDal = new DataLayer.ResultDal();
return(resultDal.EclockResultSave(result));
}
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 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;
}
}
