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; } }