public static void UpdateSAPLog(int TranId, string REMRefID, string SAPRefID, string SAPRefNo, string SAPRefGLNo, int APIResponseCode,
string APIErrorMessage, string SAPStatusCode, string SAPErrorMessage, List <SAP_Interface_Log_Detail> LogDetail)
{
SAP_Interface_Log Log = new SAP_Interface_Log(ICON.Configuration.Database.REM_ConnectionString, TranId);
Log.REMRefID = !string.IsNullOrEmpty(REMRefID) ? REMRefID : Log.REMRefID;
Log.SAPRefID = !string.IsNullOrEmpty(SAPRefID) ? SAPRefID : Log.SAPRefID;
Log.SAPRefNo = !string.IsNullOrEmpty(SAPRefNo) ? SAPRefNo : Log.SAPRefNo;
Log.SAPRefGLNo = !string.IsNullOrEmpty(SAPRefGLNo) ? SAPRefGLNo : Log.SAPRefGLNo;
Log.APIResponseCode = APIResponseCode;
Log.APIErrorMessage = !string.IsNullOrEmpty(APIErrorMessage) ? APIErrorMessage : Log.APIErrorMessage;
Log.SAPStatusCode = !string.IsNullOrEmpty(SAPStatusCode) ? SAPStatusCode : Log.SAPStatusCode;
Log.SAPErrorMessage = !string.IsNullOrEmpty(SAPErrorMessage) ? SAPErrorMessage : Log.SAPErrorMessage;
Log.RetryCount = (Log.RetryCount == null ? 0 : Log.RetryCount + 1);
Log.ExecCommand.Update();
foreach (SAP_Interface_Log_Detail Item in LogDetail)
{
Item.InitCommand(ICON.Configuration.Database.REM_ConnectionString);
Item.Module = Log.Module;
Item.MethodName = Log.MethodName;
Item.REMRefID = Log.REMRefID;
Item.REMRefDescription = Log.REMRefDescription;
Item.SAPRefDescription = Log.SAPRefDescription;
Item.CreateBy = Log.UpdateBy;
Item.CreateDate = Log.UpdateDate;
Item.ModifyBy = Log.UpdateBy;
Item.ModifyDate = Log.UpdateDate;
Item.ExecCommand.Insert();
}
}
public static void UpdateSAPLog(int TranId, string APIResponseData, int APIResponseCode, string APIErrorMessage)
{
SAP_Interface_Log Log = new SAP_Interface_Log(ICON.Configuration.Database.REM_ConnectionString, TranId);
Log.APIResponseData = !string.IsNullOrEmpty(APIResponseData) ? APIResponseData : Log.APIResponseData;
Log.APIResponseCode = APIResponseCode;
Log.APIErrorMessage = !string.IsNullOrEmpty(APIErrorMessage) ? APIErrorMessage : Log.APIErrorMessage;
Log.ExecCommand.Update();
}
public static SAP_Interface_Log CreateSAPLog(
string Module,
string MethodName,
string REMRefID,
string REMRefDescription,
string SAPRefID,
string SAPRefDescription,
string APIRequestData,
string TranBy
)
{
SAP_Interface_Log Log = new SAP_Interface_Log(ICON.Configuration.Database.REM_ConnectionString);
DBHelper dbHelp = new DBHelper(ICON.Configuration.Database.REM_ConnectionString, null);
string Sql = $"select * from SAP_Interface_Log where Module = '{Module}' and MethodName = '{MethodName}' and REMRefID = '{REMRefID}'";
System.Data.DataTable DT = dbHelp.ExecuteDataTable(Sql);
if (DT.Rows.Count > 0)
{
Log.ExecCommand.Load(DT.Rows[0]);
Log.UpdateDate = DateTime.Now;
Log.UpdateBy = Log.CreateBy;
Log.ExecCommand.Update();
}
else
{
Log.Module = Module;
Log.MethodName = MethodName;
Log.REMRefID = REMRefID;
Log.REMRefDescription = REMRefDescription;
Log.SAPRefID = SAPRefID;
Log.SAPRefDescription = SAPRefDescription;
Log.APIRequestData = APIRequestData;
Log.APIResponseCode = 500;
Log.SAPStatusCode = null;
Log.CreateDate = DateTime.Now;
Log.CreateBy = TranBy;
Log.UpdateDate = DateTime.Now;
Log.UpdateBy = Log.CreateBy;
Log.RetryCount = null;
Log.ExecCommand.Insert();
}
return(Log);
}
public List <SAP_Interface_Log> SelectAll(int start, int length, List <WhereClause> Where, List <OrderByClause> OrderBy)
{
SelectQueryBuilder Sqb = new SelectQueryBuilder();
Sqb.SelectAllColumns();
if (start > 0 || length > 0)
{
if (start == 0)
{
Sqb.TopRecords = length;
}
else
{
Sqb.LimitRecords(start, length);
}
}
Sqb.SelectFromTable("SAP_Interface_Log");
if (Where != null)
{
foreach (WhereClause Item in Where)
{
Sqb.AddWhere(Item);
}
}
if (OrderBy != null)
{
foreach (OrderByClause Item in OrderBy)
{
Sqb.AddOrderBy(Item);
}
}
DataTable dt = LoadByQueryBuilder(Sqb);
List <SAP_Interface_Log> Res = new List <SAP_Interface_Log>();
foreach (DataRow Dr in dt.Rows)
{
SAP_Interface_Log Item = new SAP_Interface_Log();
Item.ExecCommand.Load(Dr);
Res.Add(Item);
}
return(Res);
}
internal SAP_Interface_Log_Command(string ConnectionStr, SAP_Interface_Log obj_SAP_Interface_Log)
{
this._SAP_Interface_Log = obj_SAP_Interface_Log;
this._DBHelper = new DBHelper(ConnectionStr, null);
}
internal SAP_Interface_Log_Command(SAP_Interface_Log obj_SAP_Interface_Log)
{
this._SAP_Interface_Log = obj_SAP_Interface_Log;
this._DBHelper = new DBHelper();
}