public Boolean LogAudit(Dictionary <string, string> LogData, Dictionary <string, string> userInfo, DateTime Date_Created, out string ErrorMessage) { Boolean bRet = false; ErrorMessage = ""; DataBase.Connections.DBConnection DB = null; try { DB = new DataBase.Connections.DBConnection(); DB.BeginTransaction(); DBRecord mRec = new DBRecord(); mRec.CreateRow("user_audit", "ADD", "AUDIT_ID", userInfo["AUDIT_ID"].ToString()); mRec.InsertString("AUDIT_USER_ID", GetString(userInfo["USR_PKID"].ToString(), 40)); mRec.InsertString("AUDIT_USER_CODE", GetString(userInfo["USR_CODE"].ToString(), 15)); mRec.InsertString("AUDIT_SCREEN", GetString(LogData["AUDIT_SCREEN"].ToString(), 60)); mRec.InsertString("AUDIT_ACTION", GetString(LogData["AUDIT_ACTION"].ToString(), 60)); mRec.InsertString("AUDIT_REMARKS", GetString(LogData["AUDIT_REMARKS"].ToString(), 250)); mRec.InsertString("AUDIT_KEY", GetString(LogData["AUDIT_KEY"].ToString(), 40)); mRec.InsertString("AUDIT_REFNO", GetString(LogData["AUDIT_REFNO"].ToString(), 60)); mRec.InsertString("AUDIT_COMPANY_CODE", GetString(userInfo["REC_COMPANY_CODE"].ToString(), 4)); mRec.InsertString("AUDIT_BRANCH_CODE", GetString(userInfo["REC_BRANCH_CODE"].ToString(), 4)); mRec.InsertString("AUDIT_FYCODE", GetString(userInfo["YEAR_CODE"].ToString(), 4)); mRec.InsertDateAndTime("AUDIT_CLIENT_DATE", Date_Created); string Sql = mRec.UpdateRow(); DB.ExecuteNonQuery(Sql); if (LogData["AUDIT_ACTION"].ToString() == "LOGOUT") { Sql = " update user_userm set usr_logged = 'N' where usr_pkid = '" + userInfo["USR_PKID"].ToString() + "'"; DB.ExecuteNonQuery(Sql); } DB.CommitTransaction(); bRet = true; } catch (Exception Ex) { bRet = false; DB.RollbackTransaction(); ErrorMessage = Ex.Message.ToString(); } return(bRet); }
public Boolean UserLogBook(string Log_id, string Log_Source, string Log_Type, Object Log_Doc_Date, string Log_HBL_Id, string Log_CUST_Id, string Log_User_Code, DateTime Date_Created, string Log_From_Amt, string Log_To_Amt, string Log_Description, out string ErrorMessage) { Boolean bRet = false; ErrorMessage = ""; DataBase.Connections.DBConnection DB = null; try { DB = new DataBase.Connections.DBConnection(); DB.BeginTransaction(); DBRecord mRec = new DBRecord(); mRec.CreateRow("user_logbook", "ADD", "LOG_ID", Log_id); mRec.InsertString("LOG_SOURCE", GetString(Log_Source, 30)); mRec.InsertString("LOG_TYPE", GetString(Log_Type, 10)); mRec.InsertString("LOG_HBL_ID", Log_HBL_Id); mRec.InsertString("LOG_CUST_ID", Log_CUST_Id); mRec.InsertNumeric("LOG_FROM_AMT", Lib.Conv2Decimal(Log_From_Amt).ToString()); mRec.InsertNumeric("LOG_TO_AMT", Lib.Conv2Decimal(Log_To_Amt).ToString()); mRec.InsertString("LOG_USER_CODE", GetString(Log_User_Code, 15)); mRec.InsertDate("LOG_DOC_DATE", Log_Doc_Date); mRec.InsertDateAndTime("LOG_DATE", Date_Created); string Sql = mRec.UpdateRow(); DB.ExecuteNonQuery(Sql); DB.CommitTransaction(); bRet = true; } catch (Exception Ex) { bRet = false; DB.RollbackTransaction(); ErrorMessage = Ex.Message.ToString(); } return(bRet); }