public static bool ExportInstallationDenomChange(int InstallationID)
{
string XMLString = string.Empty;
int HQInstallationID = 0;
try
{
if (_proxy == null)
_proxy = GetWebService();
XMLString = DataBaseServiceHandler.ExecuteScalar<string>(GetConnectionString(), CommandType.StoredProcedure, "rsp_GetDenomChangeinXML",
DataBaseServiceHandler.AddParameter<int>("@InstallationNo", DbType.Int32, InstallationID));
XMLString = XMLString.Replace(Environment.NewLine, "");
XMLString = XMLString.Replace("\r", "");
XMLString = XMLString.Replace("\n", "");
XMLString = XMLString.Replace("\r\n", "");
XmlDocument oXmlDetails = new XmlDocument();
oXmlDetails.LoadXml(XMLString.Trim());
string oXmlNodes2 = oXmlDetails.DocumentElement.GetElementsByTagName("Bar_Pos_No").Item(0).InnerText;
string oXmlNodes1 = oXmlDetails.DocumentElement.GetElementsByTagName("HQ_Installation_No").Item(0).InnerText;
MachineManagerInterface machineManagerInterface = new MachineManagerInterface();
machineManagerInterface.AddUDPToList(InstallationID, Convert.ToInt32(oXmlNodes2));
if (Convert.ToInt32(oXmlNodes1) == 0)
{
HQInstallationID = _proxy.UpdateDenomChange(XMLString.Trim());
if (HQInstallationID > 0)
{
DataBaseServiceHandler.ExecuteNonQuery(GetConnectionString(), CommandType.StoredProcedure, "usp_updateHQInstallationID",
DataBaseServiceHandler.AddParameter<int>("@InstallationNo", DbType.Int32, InstallationID),
DataBaseServiceHandler.AddParameter<int>("@HQInstallationNo", DbType.Int32, HQInstallationID));
}
else
return false;
}
//else
//{
// HQInstallationID = Convert.ToInt32(oXmlNodes1);
//}
//if (HQInstallationID>0 )
//{
// ObjMachineMgr.RefreshUDPList();
// return ObjMachineMgr.AddUDPToList(InstallationID, Convert.ToInt32(oXmlNodes2), 7, 0, "");
//}
return true;
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return false;
}
}
public static bool CloseInstallation(int InstallationID)
{
string XMLString = string.Empty;
try
{
if (_proxy == null)
_proxy = GetWebService();
XMLString = DataBaseServiceHandler.ExecuteScalar<string>(GetConnectionString(), CommandType.StoredProcedure, "rsp_GetCloseInstallationXML",
DataBaseServiceHandler.AddParameter<int>("@InstallationNo", DbType.Int32, InstallationID));
XMLString = XMLString.Replace(Environment.NewLine, "");
XMLString = XMLString.Replace("\r", "");
XMLString = XMLString.Replace("\n", "");
XMLString = XMLString.Replace("\r\n", "");
MachineManagerInterface machineManagerInterface = new MachineManagerInterface();
if (!machineManagerInterface.RemoveUDPFromList(InstallationID))
return false;
DataBaseServiceHandler.ExecuteNonQuery(GetConnectionString(), CommandType.Text, "DELETE FROM dbo.GMU_Login WHERE GL_Code = " + InstallationID.ToString());
LogManager.WriteLog("CloseInstallation REMOVE FROM LIST for Installation No" + InstallationID.ToString() + " Succeeded", LogManager.enumLogLevel.Info);
if (_proxy.UpdateDetailsFromXML("CLOSEINSTALLATION", XMLString))
return true;
//bool bSuccess = ObjMachineMgr.RemoveUDPFromList(InstallationID);
return false;
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return false;
}
}
