//*******COPY IT TO USE BELOW FUNCTION - SELECT BY ID************
//try
//{
// LIBErLogListing objLIBErLogListing = new LIBErLogListing();
// DALErLog objDALErLog = new DALErLog();
// TransportationPacket tp = new TransportationPacket();
// Dateset ds = new Dataset();
// tp.MessagePacket = 1; //ID to be Passed
//// txt.Text = objLIBErLogListing[0].Id = "";
//// txt.Text = objLIBErLogListing[0].Dt = "";
//// txt.Text = objLIBErLogListing[0].StackTrace = "";
//// txt.Text = objLIBErLogListing[0].MethodName = "";
//// txt.Text = objLIBErLogListing[0].Username = "";
//// txt.Text = objLIBErLogListing[0].Msg = "";
//// txt.Text = objLIBErLogListing[0].Source = "";
//// txt.Text = objLIBErLogListing[0].TargetSite = "";
//// txt.Text = objLIBErLogListing[0].Data = "";
//// txt.Text = objLIBErLogListing[0].FullMsg = "";
// tp = objDALErLog.GetErLogDetails(tp);
// if(tp.MessageId == 1)
//{
// objLIBErLogListing = (LIBErLogListing)tp.MessageResultset;
// ds = (Dateset)tp.MessageResultsetDS;
// MessageBox.Show(objLIBErLogListing[0].ToString());
// }
// }
//catch(Exception ex)
// {
// MessageBox.Show(ex.Message);
// }
/// <summary>
/// Accepts=TransportationPacket, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset
/// </summary>
/// <returns></returns>
/// <remarks></remarks>
public TransportationPacket GetErLogDetails(TransportationPacket Packet)
{
DataSet ds = new DataSet();
List <SqlParameter> objParamList = new List <SqlParameter>();
LIBErLogListing objLIBErLogListing = new LIBErLogListing();
clsExecuteStoredProcSql clsESPSql = new clsExecuteStoredProcSql();
try
{
objParamList.Add(new SqlParameter("@Id", Packet.MessagePacket));
ds = clsESPSql.ExecuteSPDataSet("SP_GetDetailsFromErLogById", objParamList);
if (ds != null)
{
if (ds.Tables != null)
{
if (ds.Tables[0].Rows != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
LIBErLog oLIBErLog = new LIBErLog();
objLIBErLogListing.Add(oLIBErLog);
objLIBErLogListing[i].Id = (int)ds.Tables[0].Rows[i]["Id"];
objLIBErLogListing[i].Dt = (DateTime)ds.Tables[0].Rows[i]["Dt"];
objLIBErLogListing[i].StackTrace = ds.Tables[0].Rows[i]["StackTrace"].ToString();
objLIBErLogListing[i].MethodName = ds.Tables[0].Rows[i]["MethodName"].ToString();
objLIBErLogListing[i].Username = ds.Tables[0].Rows[i]["Username"].ToString();
objLIBErLogListing[i].Msg = ds.Tables[0].Rows[i]["Msg"].ToString();
objLIBErLogListing[i].Source = ds.Tables[0].Rows[i]["Source"].ToString();
objLIBErLogListing[i].TargetSite = ds.Tables[0].Rows[i]["TargetSite"].ToString();
objLIBErLogListing[i].Data = ds.Tables[0].Rows[i]["Data"].ToString();
objLIBErLogListing[i].InnerEx = ds.Tables[0].Rows[i]["InnerEx"].ToString();
objLIBErLogListing[i].FullMsg = ds.Tables[0].Rows[i]["FullMsg"].ToString();
}
Packet.MessageId = 1;
}
else
{
Packet.MessageId = -1;
}
}
}
}
Packet.MessageResultsetDS = ds;
Packet.MessageResultset = objLIBErLogListing;
}
catch (Exception ex)
{
Packet.MessageId = -1;
clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), false);
}
return(Packet);
}
public static void HandleEx2DB(Exception ex, string MethodName, string fullMSG, String IP = "")
{
try
{
LIBErLog objLIBErLog = new LIBErLog();
DALErLog objDALErLog = new DALErLog();
TransportationPacket tp = new TransportationPacket();
objLIBErLog.Id = -1;
//objLIBErLog.Dt = txt.Text;
objLIBErLog.StackTrace = ex.StackTrace == null ? "NULL" : ex.StackTrace.ToString();
objLIBErLog.MethodName = MethodName;
objLIBErLog.Username = strLogin;
objLIBErLog.Msg = ex.Message == null ? "NULL" : ex.Message.ToString();
objLIBErLog.Source = ex.Source == null ? "NULL" : ex.Source.ToString();
objLIBErLog.TargetSite = ex.TargetSite == null ? "NULL" : ex.TargetSite.ToString();
if (IP == "") //***CAPTURE IP IF SENT WHILE FUNCTION CALLED***
{
objLIBErLog.Data = ex.Data == null ? "NULL" : ex.Data.ToString();
}
else
{
objLIBErLog.Data = IP;
}
if (ex.InnerException != null)
{
objLIBErLog.InnerEx = ex.InnerException.ToString();
}
else
{
objLIBErLog.InnerEx = "NULL";
}
objLIBErLog.FullMsg = fullMSG;
//objLIBErLog.FullMsg = fullMsg(ex, MethodName, strLogin); //fullMsg Method not in USE
tp.MessagePacket = objLIBErLog;
tp = objDALErLog.InsertErLog(tp);
if (tp.MessageId > -1)
{
string[] strOutParamValues = (string[])tp.MessageResultset;
}
}
catch (Exception ex1)
{
//???
}
}
//*******COPY IT TO USE BELOW FUNCTION - INSERT************
//try
//{
// LIBErLog objLIBErLog = new LIBErLog();
// DALErLog objDALErLog = new DALErLog();
// TransportationPacket tp = new TransportationPacket();
// objLIBErLog.Id = txt.Text;
// objLIBErLog.Dt = txt.Text;
// objLIBErLog.StackTrace = txt.Text;
// objLIBErLog.MethodName = txt.Text;
// objLIBErLog.Username = txt.Text;
// objLIBErLog.Msg = txt.Text;
// objLIBErLog.Source = txt.Text;
// objLIBErLog.TargetSite = txt.Text;
// objLIBErLog.Data = txt.Text;
// objLIBErLog.FullMsg = txt.Text;
// tp.MessagePacket = objLIBErLog;
// tp = objDALErLog.InsertErLog(tp);
// if(tp.MessageId > -1)
//{
// string[] strOutParamValues = (string[])tp.MessageResultset;
// MessageBox.Show(strOutParamValues[0].ToString());
// }
// }
//catch(Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
/// <summary>
/// Accepts=Packet, Return=Packet, Result=Packet.MessageId, Return Values=Packet.MessageResultset
/// </summary>
/// <param name="Packet"></param>
/// <returns></returns>
/// <remarks></remarks>
public TransportationPacket InsertErLog(TransportationPacket Packet)
{
String[] strOutParamValues = new String[10];
List <SqlParameter> objParamList = new List <SqlParameter>();
List <SqlParameter> objParamListOut = new List <SqlParameter>();
clsExecuteStoredProcSql clsESPSql = new clsExecuteStoredProcSql();
int Result = 0;
try
{
LIBErLog objLIBErLog = new LIBErLog();
objLIBErLog = (LIBErLog)Packet.MessagePacket;
objParamList.Add(new SqlParameter("@Id", objLIBErLog.Id));
//objParamList.Add(new SqlParameter("@Dt", objLIBErLog.Dt));
objParamList.Add(new SqlParameter("@StackTrace", objLIBErLog.StackTrace));
objParamList.Add(new SqlParameter("@MethodName", objLIBErLog.MethodName));
objParamList.Add(new SqlParameter("@Username", objLIBErLog.Username));
objParamList.Add(new SqlParameter("@Msg", objLIBErLog.Msg));
objParamList.Add(new SqlParameter("@Source", objLIBErLog.Source));
objParamList.Add(new SqlParameter("@TargetSite", objLIBErLog.TargetSite));
objParamList.Add(new SqlParameter("@Data", objLIBErLog.Data));
objParamList.Add(new SqlParameter("@InnerEx", objLIBErLog.InnerEx));
objParamList.Add(new SqlParameter("@FullMsg", objLIBErLog.FullMsg));
objParamListOut.Add(new SqlParameter("@@Id", SqlDbType.Int));
//strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InsertErLog", objParamList, objParamListOut);
strOutParamValues = clsESPSql.ExecuteSPNonQueryOutPut("SP_InsertErLog", objParamList, objParamListOut, ref Result);
//Result = clsESPSql.ExecuteSPNonQuery("SP_InsertErLog", objParamList);
Packet.MessageId = Result;
Packet.MessageResultset = strOutParamValues;
}
catch (Exception ex)
{
Packet.MessageId = -1;
clsHandleException.HandleEx(ex, System.Reflection.MethodBase.GetCurrentMethod().ToString(), false);
}
return(Packet);
}
