public void Insert(string QryDesc,string QryText,int? ByEmployeeID,int? ByContactID,string LogIp,DateTime? LogQryDate,string QrySourceDeprecated,string QrySource,byte[] LogQryTs)
{
DbQueryLog item = new DbQueryLog();
item.QryDesc = QryDesc;
item.QryText = QryText;
item.ByEmployeeID = ByEmployeeID;
item.ByContactID = ByContactID;
item.LogIp = LogIp;
item.LogQryDate = LogQryDate;
item.QrySourceDeprecated = QrySourceDeprecated;
item.QrySource = QrySource;
item.LogQryTs = LogQryTs;
item.Save(UserName);
}
internal int ExecuteNonQuery(string SqlQuery, TimeBoundAccessRequest tbar)
{
try
{
PegasusSystem system = PegasusSystem.QueryWithStoredProc("GetSystemById", tbar.SystemCode).FirstOrDefault();
if (system == null)
{
throw new Exception($"UNABLE TO EXECUTE QUERY ON {tbar.SystemCode} AT THIS TIME");
}
ThirdPartyDB thirdPartyDB = new ThirdPartyDB(system.ConnectionString);
int rowsAffected = thirdPartyDB.ExecuteNonQuery(SqlQuery);
DbQueryLog dbQueryLog = new DbQueryLog();
dbQueryLog.CreatedOn = DateTime.Now;
dbQueryLog.CreatedBy = tbar.UserId;
dbQueryLog.ModifiedBy = tbar.UserId;
dbQueryLog.ModifiedOn = DateTime.Now;
dbQueryLog.NumberOfRowsAffected = "Rows Affected = " + rowsAffected;
dbQueryLog.QuerySql = SqlQuery;
dbQueryLog.RecordDate = DateTime.Now;
dbQueryLog.UserId = tbar.UserId;
//save db query async
Task.Factory.StartNew(() =>
{
dbQueryLog.SaveLog();
});
return(rowsAffected);
}
catch (Exception ex)
{
Task.Factory.StartNew(() =>
{
DatabaseHandler dh = new DatabaseHandler();
dh.LogError(nameof(SendOneTimePIN), $"{SqlQuery}, Error:{ex.Message}");
});
throw ex;
}
}
//end set visible data
//saves query, IP address, etc to database
protected void append_to_query_log(string _query, string _name)
{
try
{
if (!string.IsNullOrEmpty(_query))
{
DbQueryLog _newlog = new DbQueryLog();
_newlog.QryText = _query;
_newlog.QryDesc = _name.Replace("___report", ""); ;
_newlog.LogIp = userRequestingIP();
_newlog.LogQryDate = DateTime.Now;
_newlog.ByContactID = 0;
_newlog.ByEmployeeID = 0;
_newlog.QrySource = "container"; //"CNTR";//_name.Contains("___report") ? "OTR" : "OTV"; ///order tracking REPORT (goes to combobox) or order tracking view
if (Session["user"] != null)
{
UserClass _thisuser = (UserClass)Session["user"];
if (_thisuser.CompanyId == -1)
{ //employee
_newlog.ByContactID = 0;
_newlog.ByEmployeeID = _thisuser.UserId;
}
else
{
_newlog.ByContactID = _thisuser.UserId;
_newlog.ByEmployeeID = 0;
}
}
_newlog.Save();
this.dxhfMethod.Set("status", 1);
}
}
catch (Exception ex)
{
//Response.Write(ex.Message.ToString());
this.lblmsgboxdiv.Text += "<div class='alert'>Error description" + ": " + ex.Message.ToString() + "</div>";
}
}
//saves query, IP address, etc to database
protected void append_to_query_log(string _query, string _name)
{
try
{
if (!string.IsNullOrEmpty(_query))
{
DbQueryLog _newlog = new DbQueryLog();
_newlog.QryText = _query;
_newlog.QryDesc = _name;
_newlog.LogIp = userRequestingIP();
_newlog.LogQryDate = DateTime.Now;
_newlog.ByContactID = 0;
_newlog.ByEmployeeID = 0;
_newlog.QrySource = "OCE"; //order cargo edit
if (Session["user"] != null)
{
UserClass _thisuser = (UserClass)Session["user"];
if (_thisuser.CompanyId == -1)
{ //employee
_newlog.ByContactID = 0;
_newlog.ByEmployeeID = _thisuser.UserId;
}
else
{
_newlog.ByContactID = _thisuser.UserId;
_newlog.ByEmployeeID = 0;
}
}
_newlog.Save();
this.dxhfMethod.Set("status", 1);
}
}
catch (Exception ex)
{
//Response.Write(ex.Message.ToString());
this.lblmsgboxdiv.Text += "<div class='alert'>Error description" + ": " + ex.Message.ToString() + "</div>";
}
}
