public List <CLayer.GDSTransactionsLog> GetGDSTransactionLog() { try { List <CLayer.GDSTransactionsLog> result = new List <CLayer.GDSTransactionsLog>(); DataTable dt = Connection.GetTable("GetGDSTransactionLog"); foreach (DataRow dr in dt.Rows) { CLayer.GDSTransactionsLog objResult = new CLayer.GDSTransactionsLog(); objResult.GDSID = Connection.ToLong(dr["GDSID"]); objResult.BookingID = Connection.ToLong(dr["BookingID"]); objResult.CreatedAt = Connection.ToDate(dr["CreatedAt"]); objResult.GDSTypeValue = Connection.ToString(dr["GDSTypeValue"]); objResult.GDSRequest = Connection.ToString(dr["GDSRequest"]); objResult.GDSResult = Connection.ToString(dr["GDSResult"]); objResult.GDSError = Connection.ToString(dr["GDSError"]); objResult.GDSErrorMessage = Connection.ToString(dr["GDSErrorMessage"]); objResult.UserID = Connection.ToInteger(dr["UserID"]); objResult.GDSTransID = Connection.ToString(dr["GDSTransID"]); result.Add(objResult); } return(result); } catch (Exception ex) { throw ex; } }
public void GenerateGDSLog(CLayer.GDSTransactionsLog data) { try { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pGDSTransID", DataPlug.DataType._Text, data.GDSTransID)); param.Add(Connection.GetParameter("pGDSSearchCriteria", DataPlug.DataType._Text, data.GDSSearchCriteria)); param.Add(Connection.GetParameter("pGDSRequest", DataPlug.DataType._Text, data.GDSRequest)); param.Add(Connection.GetParameter("pGDSResult", DataPlug.DataType._Text, data.GDSResult)); param.Add(Connection.GetParameter("pGDSError", DataPlug.DataType._Text, data.GDSError)); param.Add(Connection.GetParameter("pGDSErrorMessage", DataPlug.DataType._Varchar, data.GDSErrorMessage)); param.Add(Connection.GetParameter("pUserID", DataPlug.DataType._Int, data.UserID)); param.Add(Connection.GetParameter("pGDSType", DataPlug.DataType._Int, data.GDSType)); param.Add(Connection.GetParameter("pGDSBookingType", DataPlug.DataType._Int, data.GDSBookingType)); param.Add(Connection.GetParameter("pBookingID", DataPlug.DataType._BigInt, data.BookingID)); object result = Connection.ExecuteQueryScalar("GenerateGDSLog", param); } catch (Exception ex) { throw ex; } }
public static void GenerateGDSLog(CLayer.GDSTransactionsLog data) { DataLayer.GDSTransactionsLog b2b = new DataLayer.GDSTransactionsLog(); b2b.GenerateGDSLog(data); }