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