public bool CloseInstallation(int InstallationNo, int MachineStatusFlag, string MachineTransitSiteCode) { bool result = true; using (SqlConnection conn = new SqlConnection(CommonDataAccess.ExchangeConnectionString)) { try { conn.Open(); if (System.Transactions.Transaction.Current != null) { conn.EnlistTransaction(System.Transactions.Transaction.Current); } CloseInstallationArg argument = new CloseInstallationArg() { InstallationNo = InstallationNo, MachineStatusFlag = MachineStatusFlag, MachineTransitSiteCode = MachineTransitSiteCode }; CloseInstallationHandler[] handlers = new CloseInstallationHandler[] { CloseInstallation_Machine, CloseInstallation_Read, CloseInstallation_VTP, CloseInstallation_MeterHistory, CloseInstallation_MGMD, CloseInstallation_FloorFinancials, CloseInstallation_BAD_IGI }; foreach (CloseInstallationHandler handler in handlers) { try { result &= handler(conn, argument); } catch (Exception ex2) { ExceptionManager.Publish(ex2); result &= false; } if (!result) { break; } } } catch (Exception ex) { ExceptionManager.Publish(ex); result = false; } } return(result); }
private bool CloseInstallation_FloorFinancials(SqlConnection conn, CloseInstallationArg argument) { SqlParameter[] objSQlParams = new SqlParameter[1]; SqlParameter objSQL1 = new SqlParameter(); objSQL1.ParameterName = "InstallationNo"; objSQL1.Direction = ParameterDirection.Input; objSQL1.Value = argument.InstallationNo; objSQlParams[0] = objSQL1; return(this.ExecuteQueryWithCommandTimeout(conn, "dbo.usp_CloseInstallation_FloorFinancials", objSQlParams)); }
//Call the installation and machine private bool CloseInstallation_Machine(SqlConnection conn, CloseInstallationArg argument) { SqlParameter[] objSQlParams = new SqlParameter[5]; SqlParameter objSQL1 = new SqlParameter(); objSQL1.ParameterName = "InstallationNo"; objSQL1.Direction = ParameterDirection.Input; objSQL1.Value = argument.InstallationNo; objSQlParams[0] = objSQL1; SqlParameter objSQL2 = new SqlParameter(); objSQL2.ParameterName = "UserID"; objSQL2.Direction = ParameterDirection.Input; objSQL2.Value = Security.SecurityHelper.CurrentUser.SecurityUserID; objSQlParams[1] = objSQL2; SqlParameter objSQL3 = new SqlParameter(); objSQL3.ParameterName = "MachineStatusFlag"; objSQL3.Direction = ParameterDirection.Input; objSQL3.Value = argument.MachineStatusFlag; objSQlParams[2] = objSQL3; SqlParameter objSQL4 = new SqlParameter(); objSQL4.ParameterName = "MachineTransitSiteCode"; objSQL4.Direction = ParameterDirection.Input; objSQL4.Value = argument.MachineTransitSiteCode; objSQlParams[3] = objSQL4; SqlParameter objSQL5 = new SqlParameter(); objSQL5.ParameterName = "SerialNo"; objSQL5.Direction = ParameterDirection.Output; objSQL5.Size = 50; objSQlParams[4] = objSQL5; return(this.ExecuteQueryWithCommandTimeout(conn, "dbo.usp_CloseInstallation_Machine", objSQlParams, () => { if (objSQL5.Value != DBNull.Value) { argument.SerialNo = objSQL5.Value.ToString(); } })); }
private bool CloseInstallation_BAD_IGI(SqlConnection conn, CloseInstallationArg argument) { SqlParameter[] objSQlParams = new SqlParameter[2]; SqlParameter objSQL1 = new SqlParameter(); objSQL1.ParameterName = "InstallationNo"; objSQL1.Direction = ParameterDirection.Input; objSQL1.Value = argument.InstallationNo; objSQlParams[0] = objSQL1; SqlParameter objSQL2 = new SqlParameter(); objSQL2.ParameterName = "SerialNo"; objSQL2.Direction = ParameterDirection.Input; objSQL2.Value = argument.SerialNo; objSQlParams[1] = objSQL2; return(this.ExecuteQueryWithCommandTimeout(conn, "dbo.usp_CloseInstallation_BAD_IGI", objSQlParams)); }