/// <summary>
/// Get Settings from Setting table
/// </summary>
/// <returns>list with available installations</returns>
/// /// Method Revision History
///
/// Author Date Description
/// ---------------------------------------------------
/// Anuradha 05-Feb-2009 Intial Version
///
public static InstallationEntity[] GetInstallations()
{
InstallationEntity[] clsInstallation = null;
DataTable dtInstallations = null;
int iCount=0;
try
{
// lInstallations = new List<int>();
//Get available installations.
dtInstallations = SqlHelper.ExecuteDataset(GetConnectionString(), CommandType.StoredProcedure,
DBConstants.RSP_GETINSTALLATIONDETAILS).Tables[0];
if (dtInstallations != null)
{
clsInstallation = new InstallationEntity[dtInstallations.Rows.Count];
//Add the installation no to the list.
foreach (DataRow row in dtInstallations.Rows)
{
clsInstallation[iCount] = new InstallationEntity();
clsInstallation[iCount].InstallationNumber = Convert.ToInt32(row["Installation_No"].ToString());
clsInstallation[iCount].BarPositionName = row["Bar_Pos_Name"].ToString();
clsInstallation[iCount].BarPositionMachineEnabled = row["BarPositionMachineEnabled"].ToString();
clsInstallation[iCount].DataPakNumber = int.Parse(row["Datapak_Serial"].ToString());
clsInstallation[iCount].BarPositionNo = int.Parse(row["Bar_Pos_No"].ToString());
iCount++;
}
}
//Get the site code.
string SiteCode = SqlHelper.ExecuteScalar(GetConnectionString(), CommandType.Text,
"Select code from site").ToString();
if (!String.IsNullOrEmpty(SiteCode))
{
for (int k = 0; k < clsInstallation.Length; k++)
{
clsInstallation[k].SiteCode = SiteCode;
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
finally
{
if (dtInstallations!=null)
{
dtInstallations.Dispose();
}
}
return clsInstallation;
}
//
//private static string GetEnterpriseConnectionString()
//{
// string strConnectionString = string.Empty;
// //BGSGeneral.cConstants objBGSConstants = null;
// //BGSEncryptDecrypt.clsBlowFish objDecrypt = null;
// //bool bUseHex = true;
// try
// {
// //Check if Connection string already exists.
// if (!string.IsNullOrEmpty(strExchangeConnectionString))
// {
// return strExchangeConnectionString;
// }
// //Get the connection string from registry
// RegistryKey regKeyConnectionString = BMCRegistryHelper.GetRegLocalMachine().OpenSubKey("Software\\Honeyframe\\Cashmaster");
// strConnectionString = regKeyConnectionString.GetValue("SQLConnect").ToString();
// regKeyConnectionString.Close();
// //Decrypt the connection string.
// if (!strConnectionString.ToUpper().Contains("SERVER"))
// {
// //objBGSConstants = new BGSGeneral.cConstants();
// //objDecrypt = new BGSEncryptDecrypt.clsBlowFish();
// //string strKey = objBGSConstants.ENCRYPTIONKEY;
// //strConnectionString = objDecrypt.DecryptString(ref strConnectionString, ref strKey, ref bUseHex);
// strConnectionString = BMC.Common.Security.CryptEncode.Decrypt(strConnectionString);
// }
// //Check if the connection string is properly decrypted.
// if (string.IsNullOrEmpty(strExchangeConnectionString))
// {
// if (strConnectionString.ToUpper().Contains("SERVER"))
// strExchangeConnectionString = strConnectionString;
// else
// throw new Exception("Error Decrypting Registry");
// }
// }
// catch (Exception ex)
// {
// if (ex.Message == "Connectionstring Not Found.")
// {
// throw ex;
// }
// else
// {
// ExceptionManager.Publish(ex);
// }
// strExchangeConnectionString = "";
// }
// finally
// {
// //objBGSConstants = null;
// //objDecrypt = null;
// }
// return strExchangeConnectionString;
//}
#endregion
#region Check If Time falls within Opening Hours
/// <summary>
/// Execute Query
/// </summary>
/// <returns>success or failure</returns>
/// /// Method Revision History
///
/// Author Date Description
/// ---------------------------------------------------
/// Anuradha 04-Feb-2009 Intial Version
///
public static Dictionary<int,bool> ShouldMachineBeEnabled(InstallationEntity[] Installations)
{
Dictionary<int, bool> dMachineShouldbeEnabled = null;
SqlParameter[] sInstallparams=null;
object objShouldMachineBeEnabled = null;
try
{
dMachineShouldbeEnabled = new Dictionary<int, bool>();
foreach (InstallationEntity Installation in Installations)
{
//Get the parameters.
objParameters = new Dictionary<string, string>();
objParameters.Add("@InstallationNo", Installation.InstallationNumber.ToString());
sInstallparams = AddParameter(objParameters);
//Check if the machine should be enabled or disabled.
objShouldMachineBeEnabled = SqlHelper.ExecuteScalar(GetConnectionString(), CommandType.StoredProcedure,
DBConstants.RSP_CHECKSHOULDMACHINEBEENABLED, sInstallparams);
//Add the machines and their status.
dMachineShouldbeEnabled.Add(Installation.InstallationNumber, Convert.ToBoolean(sInstallparams[1].Value));
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
finally
{
objParameters = null;
}
return dMachineShouldbeEnabled;
}
