public static int UpdateBowCaseWorkOrderSetup(int iD, bool customBow, string customDescription, int currentCaseNumber, bool complete) { string databaseConnection = ""; if (Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") == "Development") { databaseConnection = @"BTIntranetMySQLConnectionDevelopment"; } else if (Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") == "Production") { databaseConnection = @"BTIntranetMySQLConnectionProduction"; } else { databaseConnection = @"BTIntranetMySQLConnectionProduction"; } BowCaseLabelWorkOrderModel data = new BowCaseLabelWorkOrderModel { ID = iD, CustomBow = customBow, CustomDescription = customDescription, CurrentCaseNumber = currentCaseNumber, Complete = complete }; string sql = @"UPDATE labelbowcaseworkorder SET CustomBow = @CustomBow, CustomDescription = @CustomDescription, CurrentCaseNumber = @CurrentCaseNumber, Complete = @Complete WHERE ID = @ID ;"; return(SQLDataAccess.UpdateDataBTIntranet(sql, data, databaseConnection)); }
public static int UpdateLabelBowCaseWorkOrder(string workOrderNumber, int nextCaseNumber, bool complete) { string databaseConnection = ""; if (Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") == "Development") { databaseConnection = @"BTIntranetMySQLConnectionDevelopment"; } else if (Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") == "Production") { databaseConnection = @"BTIntranetMySQLConnectionProduction"; } else { databaseConnection = @"BTIntranetMySQLConnectionProduction"; } BowCaseLabelWorkOrderModel data = new BowCaseLabelWorkOrderModel { WorkOrderNumber = workOrderNumber, CurrentCaseNumber = nextCaseNumber, Complete = complete }; string sql = @"UPDATE labelbowcaseworkorder SET CurrentCaseNumber = @CurrentCaseNumber, Complete = @Complete WHERE WorkOrderNumber = @WorkOrderNumber ;"; return(SQLDataAccess.UpdateDataBTIntranet(sql, data, databaseConnection)); }
public static int InsertBowCaseWorkOrderData(string workOrderNumber, bool customBow, string customDescription) { string databaseConnection = ""; if (Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") == "Development") { databaseConnection = @"BTIntranetMySQLConnectionDevelopment"; } else if (Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") == "Production") { databaseConnection = @"BTIntranetMySQLConnectionProduction"; } else { databaseConnection = @"BTIntranetMySQLConnectionProduction"; } BowCaseLabelWorkOrderModel data = new BowCaseLabelWorkOrderModel { WorkOrderNumber = workOrderNumber, CustomBow = customBow, CustomDescription = customDescription, CurrentCaseNumber = 1, Complete = false }; string sql = @"INSERT INTO labelbowcaseworkorder (WorkOrderNumber, CustomBow, CustomDescription, CurrentCaseNumber, Complete) VALUES (@WorkOrderNumber, @CustomBow, @CustomDescription, @CurrentCaseNumber, @Complete);"; return(SQLDataAccess.InsertDataBTIntranet(sql, data, databaseConnection)); }