public void InsterWorkOrder(Classes.DatabaseTables.WorkOrders newWorkOrder) { using (System.Data.IDbConnection connection = new System.Data.SqlClient.SqlConnection(Classes.Helper.CnnVal("TracerDB"))) { List <DatabaseTables.WorkOrders> WorkOrders = new List <DatabaseTables.WorkOrders>(); WorkOrders.Add(newWorkOrder); //Set POReceived Field to True connection.Execute($"UPDATE ActiveQuotes SET POReceived='True' WHERE QuoteWOR=@JobWOR", WorkOrders); //Insert New Work Order connection.Execute($"insert into WorkOrders(JobWOR, Date, Time, PurchaseOrderNumber, WorkOrderComplete) values(@JobWOR, @Date, @Time, @PurchaseOrderNumber, @WorkOrderComplete)", WorkOrders); } }
private void createWOR() { //Set Up holder to update the Active Quote PO Status Classes.DatabaseTables.ActiveQuotes activeQuote = new Classes.DatabaseTables.ActiveQuotes(); //Set Up Holder for the new WOR Classes.DatabaseTables.WorkOrders newWOR = new Classes.DatabaseTables.WorkOrders(); DateTime rightNow = new DateTime(); rightNow = DateTime.Now; newWOR.JobWOR = Int32.Parse(SelectedWorkOrder); newWOR.Date = rightNow.ToString("MM-dd-yyyy"); newWOR.Time = rightNow.ToString("hh:mm:ss tt"); newWOR.PurchaseOrderNumber = txtPONumber.Text; newWOR.WorkOrderComplete = 0; //Create Data Access Class Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess(); db.InsterWorkOrder(newWOR); }