private List <TimeInOutLog> GetUpdatedDataFromServer(DateTime UpdatedDate) { dcTimeInOutLog_SQL dc = new dcTimeInOutLog_SQL(); dc.SelectParameters.Add("p_ClientId", ClientSettings.ClientWorkStationInfo.ClientId); dc.SelectParameters.Add("p_UpdatedDate", UpdatedDate); return(dc.GetDataSource()); }
private List <TimeInOutLog> GetNewDataFromServer(DateTime CreatedDate) { dcTimeInOutLog_SQL dc = new dcTimeInOutLog_SQL(); // SQLServer.Procedure p = new SQLServer.Procedure("dbo.SelectTimeInOutLogs"); dc.SelectParameters.Add("p_ClientId", ClientSettings.ClientWorkStationInfo.ClientId); dc.SelectParameters.Add("p_UploadedDate", CreatedDate); return(dc.GetDataSource()); }
private void UploadDataToServer() { try { List <TimeInOutLog> list = new List <TimeInOutLog>(); dcTimeInOutLog_OleDb _dcOLEDb = new dcTimeInOutLog_OleDb(); list = _dcOLEDb.GetDataSource("Select * from TimeInOutLog where UploadedDate is null"); foreach (TimeInOutLog info in list) { string LogInfo = string.Empty; try { LogInfo = "ProfileId:" + info.ProfileId + ";ClientEmployeeId:" + info.ClientEmployeeId; dcTimeInOutLog_SQL _dcSQL = new dcTimeInOutLog_SQL(); _dcSQL.UpdateParameters.Add("p_ServerLogInOutId", info.ServerLogInOutId, SqlDbType.Int, ParameterDirection.InputOutput); _dcSQL.UpdateParameters.Add("p_ClientId", info.ClientId); _dcSQL.UpdateParameters.Add("p_ClientEmployeeId", info.ClientEmployeeId); _dcSQL.UpdateParameters.Add("p_DTRDate", info.DTRDate, SqlDbType.Date); _dcSQL.UpdateParameters.Add("p_ShiftId", info.ShiftId); _dcSQL.UpdateParameters.Add("p_TimeIn", info.TimeIn, SqlDbType.DateTime); if (info.TimeOut != new DateTime(1, 1, 1)) { _dcSQL.UpdateParameters.Add("p_TimeOut", info.TimeOut, SqlDbType.DateTime); } _dcSQL.UpdateParameters.Add("p_WorkStationId", info.WorkStationId); _dcSQL.UpdateParameters.Add("p_TimeInWSId", info.TimeInWSId); _dcSQL.UpdateParameters.Add("p_TimeOutWSId", info.TimeOutWSId); _dcSQL.UpdateParameters.Add("p_LogInOutId", info.LogInOutId); _dcSQL.Update(); //update local db this.DBConn.Open(); string sql = "Update TimeInOutLog set UploadedDate=#" + DateTime.Now + "#,ServerLogInOutId=" + _dcSQL.UpdateParameters.GetItem("p_ServerLogInOutId").Value.ToString() + " where UploadedDate is null" + " and LogInOutId=" + info.LogInOutId + " and ClientEmployeeId=" + info.ClientEmployeeId + " and WorkStationId=" + info.WorkStationId; OleDbCommand _cmd = new OleDbCommand(sql, this.DBConn); _cmd.ExecuteNonQuery(); this.DBConn.Close(); _dcSQL = null; } catch (Exception ex) { string ErrorMsg = "(loginfo:" + LogInfo + ")" + ex.ToString(); ConsoleApp.WriteLine(Application.ProductName, "[Error]," + ErrorMsg); zsi.PhotoFingCapture.Util.LogError(ErrorMsg); } } } catch (Exception ex) { throw ex; } }