public string DBConnect(String CompanyId, string DataBaseType)
{
String UId;
String provider;
String pass;
String dsource;
String incat;
String mystring;
string mycon = string.Empty;
XmlDocument xmDataAccess;
xmDataAccess = new XmlDocument();
DataAccess_Net.DataAccess objda = new DataAccess_Net.DataAccess();
if (!string.IsNullOrEmpty(DataBaseType))
{
mystring = "/ConfigParams/Company/" + CompanyId + "/" + DataBaseType;
}
else
{
mystring = "/ConfigParams/AdminDB,/ConfigParams/subagent,/ConfigParams/Log";
}
mystring = objda.fnDataAccess(mystring, ",");
mystring = mystring.Replace("'", "\"");
xmDataAccess.LoadXml(mystring);
try
{
if (xmDataAccess.DocumentElement.Name != "Error")
{
if (xmDataAccess.DocumentElement.HasChildNodes)
{
if (!string.IsNullOrEmpty(DataBaseType))
{
provider = xmDataAccess.DocumentElement.SelectSingleNode(DataBaseType).Attributes.GetNamedItem("Provider").InnerText;
UId = xmDataAccess.DocumentElement.SelectSingleNode(DataBaseType).Attributes.GetNamedItem("UserID").InnerText;
pass = xmDataAccess.DocumentElement.SelectSingleNode(DataBaseType).Attributes.GetNamedItem("Password").InnerText;
dsource = xmDataAccess.DocumentElement.SelectSingleNode(DataBaseType).Attributes.GetNamedItem("DataSource").InnerText;
incat = xmDataAccess.DocumentElement.SelectSingleNode(DataBaseType).Attributes.GetNamedItem("DBName").InnerText;
}
else
{
provider = xmDataAccess.DocumentElement.SelectSingleNode("AdminDB").Attributes.GetNamedItem("Provider").InnerText;
UId = xmDataAccess.DocumentElement.SelectSingleNode("AdminDB").Attributes.GetNamedItem("UserID").InnerText;
pass = xmDataAccess.DocumentElement.SelectSingleNode("AdminDB").Attributes.GetNamedItem("Password").InnerText;
dsource = xmDataAccess.DocumentElement.SelectSingleNode("AdminDB").Attributes.GetNamedItem("DataSource").InnerText;
incat = xmDataAccess.DocumentElement.SelectSingleNode("AdminDB").Attributes.GetNamedItem("DBName").InnerText;
}
mycon = "user id='" + UId + "';password='******';data source='" + dsource + "'; initial catalog='" + incat + "'";
}
}
}
catch (Exception ex)
{
// log.Log("Initializeskyvantage()", Environment.NewLine + "Exception occured in DBConnect function :" + ex.StackTrace + Environment.NewLine + ex.InnerException + Environment.NewLine + ex.Message + Environment.NewLine, "Caching");
}
return(mycon);
}
internal string Log(string MethodName_, string errorMsg_, string Searchtype)
{
string logpath = string.Empty;
try
{
if (_WriteLogs)
{
object lockIndex = new object();
string filepath = string.Empty;
XmlDocument xmlConfigDetails = new XmlDocument();
DataAccess_Net.DataAccess objfbDataAcess = new DataAccess_Net.DataAccess();
logpath = objfbDataAcess.fnDataAccess("ConfigParams/Log", ",");
xmlConfigDetails.LoadXml(logpath);
logpath = xmlConfigDetails.DocumentElement.SelectSingleNode("Log").Attributes["Path"].Value;
if (Searchtype.ToUpper() == "FATOSERVICE")
{
logpath += "BookingEngine\\" + scompid + "\\" + Searchtype + "\\";
}
FileInfo objFileInfo;
lock (lockIndex)
{
if (!Directory.Exists(logpath))
{
Directory.CreateDirectory(logpath);
}
filepath = logpath + "Fato_Service" + DateTime.Today.ToString("dd-MMM-yyyy") + ".log";
objFileInfo = new FileInfo(filepath);
FileStream fs;
if (objFileInfo.Exists)
{
if (objFileInfo.Length > 5048576)
{
filepath = logpath + strSessionID + DateTime.Today.ToString("dd-MMM-yyyy") + DateTime.Now.ToString("H-m-s") + ".log";
fs = new FileStream(filepath, FileMode.Create, FileAccess.ReadWrite);
}
else
{
fs = new FileStream(filepath, FileMode.Append, FileAccess.Write);
}
}
else
{
fs = new FileStream(filepath, FileMode.Create, FileAccess.ReadWrite);
}
TextWriter m_streamWriter = new StreamWriter(fs);
if (!string.IsNullOrEmpty(errorMsg_))
{
m_streamWriter.WriteLine(" ============================================================================================================================================");
//m_streamWriter.WriteLine("Time :: " + System.DateTime.Now );
m_streamWriter.WriteLine(" Method Name :: " + MethodName_);
m_streamWriter.WriteLine(Environment.NewLine + " " + errorMsg_);
//m_streamWriter.WriteLine("============================================================================================================================================");
}
else
{
m_streamWriter.WriteLine("*************************************************************************************************************************************************************************************");
}
m_streamWriter.Close();
m_streamWriter.Dispose();
}
}
}
catch (Exception _ex) //if error comes in log writing
{
return("Error: Failed to Write Log" + _ex.Message);
//throw new System.ApplicationException(_ex.ToString());
}
return(logpath);
}