public int UpdateWorkorder(Stream stream)
        {
            DALDB dal = new DALDB(connStr);
            WorkOrder.Workorder wo = new Workorder();
            DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(WorkOrder.Workorder));
            wo = (WorkOrder.Workorder)ser.ReadObject(stream);

            if (wo != null)
            {
                if (dal.GetWorkorder(wo.wo_ID) != null)
                {
                    dal.UpdateWorkorder(wo);
                }
                return 1;
            }
            dal.AddWorkorder(wo);
            //string fileName = Server.MapPath("Output.txt");
            // write a text file
            FileStream fs = new FileStream(@"c:\xworkorders.txt", FileMode.Append);
            TextWriter tws = new StreamWriter(fs);

            // write the current datetime to the stream
            tws.WriteLine(DateTime.Now);

            // write test strings to the stream
            tws.WriteLine(wo.wo_ID);
            tws.WriteLine(wo.wo_Number);
            tws.WriteLine(wo.wo_Date);
            tws.WriteLine(wo.wo_Debtor);
            tws.WriteLine(wo.wo_Address);
            tws.WriteLine(wo.wo_StartTime);

            tws.Close();   // close the stream

            return 1;
        }