Example #1
0
        static void Main(string[] args)
        {
            int i = -1;

            using (NeptuneEntities context = new NeptuneEntities())
            {
                var schedules = context.GetSchedules("1234", 1, 1);

                foreach (GetSchedules_Result s in schedules)
                {
                    Console.WriteLine(s.accountnumber);
                }

                try
                {
                    context.Database.Log = Logger;
                    WorkOrder w = context.WorkOrders.Where(a => a.ScheduleID == 2).FirstOrDefault();

                    Console.WriteLine(context.ChangeTracker.HasChanges().ToString());
                    //w.ScheduleID = 1234;
                    w.InstallDate = DateTime.Now;
                    w.InstallerID = 1;
                    w.DeviceID    = "1234";
                    w.OldPhoto    = File.ReadAllBytes(@"d:\junk\A16.jpg");
                    Console.WriteLine(context.ChangeTracker.HasChanges().ToString());
                    var a1 = context.SaveWorkOrder(w.DeviceID, w.ProjectInventoryID, w.ScheduleID, w.InstallerID, w.InstallDate, w.NewSerial, w.CorrectSerial, w.PrevRead, w.OldRead, w.NewRead, w.AltRead, w.PlumbingTime, w.WiringTime, w.NewRemoteID, w.OldSize, w.NewSize, w.OldPhoto, w.NewPhoto, w.Photo3, w.Photo4, w.Photo5, w.Sig1, w.Notes, w.SkipReason, w.JobComplete, w.JobSkipped, w.CompoundMeter, w.Photo6, w.Photo7, w.OldPhotoLatitude, w.OldPhotoLongitude, w.NewPhotoLatitude, w.NewPhotoLongitude, w.Photo3Latitude, w.Photo3Longitude, w.Photo4Latitude, w.Photo4Longitude, w.Photo5Latitude, w.Photo5Longitude, w.Photo6Latitude, w.Photo6Longitude, w.Photo7Latitude, w.Photo7Longitude, w.JobSubmissionLatitude, w.JobSubmissionLongitude);
                    //i = context.SaveChanges();
                    SaveWorkOrder_Result i1 = a1.FirstOrDefault();
                    Console.WriteLine("number of records updated->" + i1.RESULT);
                    i = i1.RESULT;
                    foreach (var e in context.GetValidationErrors())
                    {
                        Console.WriteLine(e.ValidationErrors.ToString());
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.ToString());
                }


                //Console.WriteLine("value returned is " + i);
            }
            if (i == 1)
            {
                Console.WriteLine("succces");
            }
            else
            {
                Console.WriteLine("failure");
            }
            //using (NeptuneEntities context = new NeptuneEntities())
            //{
            //    WorkOrder w = context.WorkOrders.Where(a => a.ScheduleID == 2).FirstOrDefault();
            //    Console.WriteLine(w.InstallerID.ToString());
            //}

            Console.ReadLine();
        }
        // GET api/schedule
        public async Task <HttpResponseMessage> Post()
        {
            Log.InfoFormat("Received the POST request");

            try
            {
                // Check if the request contains multipart/form-data.
                if (!Request.Content.IsMimeMultipartContent())
                {
                    throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
                }

                string root = ConfigurationManager.AppSettings["ImageFileFolder"];

                string rootbyDate = root + "/" + DateTime.Now.ToString("Mddyyyy");

                DirectoryInfo d = new DirectoryInfo(rootbyDate);
                if (!d.Exists)
                {
                    Log.InfoFormat("Creating directory->{0}", d.FullName);
                    d.Create();
                }


                var provider = new MultipartFormDataStreamProvider(rootbyDate);

                // Read the form data.
                await Request.Content.ReadAsMultipartAsync(provider);

                Log.InfoFormat("Now connecting to database");
                using (NeptuneEntities context = new NeptuneEntities())
                {
                    int?   ScheduleID  = null;
                    int?   InstallerID = null;
                    int?   ProjectID   = null;
                    string DeviceID    = "";

                    getKeyValues(provider, ref ScheduleID, ref InstallerID, ref DeviceID, ref ProjectID);

                    if (String.IsNullOrEmpty(DeviceID))
                    {
                        Log.ErrorFormat("Missing DeviceID");
                        throw new ApplicationException("Missing DeviceID");
                    }
                    if (InstallerID == null)
                    {
                        Log.ErrorFormat("Missing InstallerID");
                        throw new ApplicationException("Missing InstallerID");
                    }
                    if (ScheduleID == null)
                    {
                        Log.ErrorFormat("Missing ScheduleID");
                        throw new ApplicationException("Missing ScheduleID");
                    }
                    if (ProjectID == null)
                    {
                        Log.ErrorFormat("Missing ProjectID");
                        throw new ApplicationException("Missing ProjectID");
                    }

                    Log.InfoFormat("Key data elements found");

                    Log.ErrorFormat("initializing Workorder");
                    //NeptuneDAL.WorkOrder w = context.WorkOrders.Where(a => a.ScheduleID == ScheduleID).FirstOrDefault();
                    NeptuneDAL.WorkOrder w = new NeptuneDAL.WorkOrder();
                    w.ScheduleID         = ScheduleID.Value;
                    w.DeviceID           = DeviceID;
                    w.InstallerID        = InstallerID;
                    w.ProjectInventoryID = ProjectID;
                    Log.ErrorFormat("default Workorder");
                    //if (w == null)
                    //{
                    //    Log.ErrorFormat("Missing Workorder for this ScheduleID->{0}", ScheduleID);
                    //    throw new ApplicationException("Missing WorkOrder ID");
                    //}

                    foreach (MultipartFileData file in provider.FileData)
                    {
                        Log.InfoFormat(file.Headers.ContentDisposition.Name);
                        string name = file.Headers.ContentDisposition.Name.Replace("\"", "");
                        //string filename = file.Headers.ContentDisposition.FileName;
                        Log.InfoFormat(file.Headers.ContentDisposition.FileName);
                        Log.InfoFormat("Server file path: " + file.LocalFileName);
                        string filename = file.LocalFileName;
                        switch (name.ToUpper())
                        {
                        case "OLDPHOTO":
                            w.OldPhoto = File.ReadAllBytes(filename);
                            break;

                        case "NEWPHOTO":
                            w.NewPhoto = File.ReadAllBytes(filename);
                            break;

                        case "PHOTO3":
                            w.Photo3 = File.ReadAllBytes(filename);
                            break;

                        case "PHOTO4":
                            w.Photo4 = File.ReadAllBytes(filename);
                            break;

                        case "PHOTO5":
                            w.Photo5 = File.ReadAllBytes(filename);
                            break;

                        case "PHOTO6":
                            w.Photo6 = File.ReadAllBytes(filename);
                            break;

                        case "PHOTO7":
                            w.Photo7 = File.ReadAllBytes(filename);
                            break;

                        case "SIG1":
                            w.Sig1 = File.ReadAllBytes(filename);
                            break;

                        default:
                            break;
                        }
                    }


                    foreach (var key in provider.FormData.AllKeys)
                    {
                        foreach (var val in provider.FormData.GetValues(key))
                        {
                            Log.InfoFormat(string.Format("Reading Form Data {0}: {1}", key, val));
                            try
                            {
                                switch (key.ToUpper())
                                {
                                case "DEVICEID": w.DeviceID = val;
                                    break;

                                case "INSTALLERID": w.InstallerID = Int32.Parse(val);
                                    break;

                                case "PROJECTID": w.ProjectInventoryID = Int32.Parse(val);
                                    break;

                                case "JOBCOMPLETE": w.JobComplete = GetCheckBox(val);
                                    break;

                                case "JOBSKIPPED": w.JobSkipped = GetCheckBox(val);
                                    break;

                                case "COMPOUNDMETER": w.CompoundMeter = GetCheckBox(val);
                                    break;

                                case "SKIPREASON": w.SkipReason = val;
                                    break;

                                case "OLDSIZE": w.OldSize = val;
                                    break;

                                case "NEWSIZE": w.NewSize = val;
                                    break;

                                case "PREVREAD": w.PrevRead = Int32.Parse(val);
                                    break;

                                case "NEWREAD": w.NewRead = Int32.Parse(val);
                                    break;

                                case "OLDREAD": w.OldRead = Int32.Parse(val);
                                    break;

                                case "ALTREAD": w.AltRead = Int32.Parse(val);
                                    break;

                                case "NEWSERIAL": w.NewSerial = Int32.Parse(val);
                                    break;

                                case "CORRECTSERIAL": w.CorrectSerial = Int32.Parse(val);
                                    break;

                                case "PLUMBINGTIME": w.PlumbingTime = Int32.Parse(val);
                                    break;

                                case "WIRINGTIME": w.WiringTime = Int32.Parse(val);
                                    break;

                                case "NOTES": w.Notes = val;
                                    break;

                                case "NEWREMOTEID": w.NewRemoteID = Int32.Parse(val);
                                    break;

                                case "OLD_GPS":
                                {
                                    Log.InfoFormat(val.Split(',')[0]);
                                    Log.InfoFormat(val.Split(',')[1]);

                                    w.OldPhotoLatitude  = Double.Parse(val.Split(',')[0]);
                                    w.OldPhotoLongitude = Double.Parse(val.Split(',')[1]);
                                }
                                break;

                                case "NEW_GPS":
                                {
                                    w.NewPhotoLatitude  = Double.Parse(val.Split(',')[0]);
                                    w.NewPhotoLongitude = Double.Parse(val.Split(',')[1]);
                                }
                                break;

                                case "P3_GPS":
                                {
                                    w.Photo3Latitude  = Double.Parse(val.Split(',')[0]);
                                    w.Photo3Longitude = Double.Parse(val.Split(',')[1]);
                                }
                                break;

                                case "P4_GPS":
                                {
                                    w.Photo4Latitude  = Double.Parse(val.Split(',')[0]);
                                    w.Photo4Longitude = Double.Parse(val.Split(',')[1]);
                                }

                                break;

                                case "P5_GPS":
                                {
                                    w.Photo5Latitude  = Double.Parse(val.Split(',')[0]);
                                    w.Photo5Longitude = Double.Parse(val.Split(',')[1]);
                                }
                                break;

                                case "P6_GPS":
                                {
                                    w.Photo6Latitude  = Double.Parse(val.Split(',')[0]);
                                    w.Photo6Longitude = Double.Parse(val.Split(',')[1]);
                                }
                                break;

                                case "P7_GPS":
                                {
                                    w.Photo7Latitude  = Double.Parse(val.Split(',')[0]);
                                    w.Photo7Longitude = Double.Parse(val.Split(',')[1]);
                                }
                                break;

                                case "SUBMIT_GPS":
                                {
                                    w.JobSubmissionLatitude  = Double.Parse(val.Split(',')[0]);
                                    w.JobSubmissionLongitude = Double.Parse(val.Split(',')[1]);
                                }
                                break;



                                default:
                                    break;
                                }
                            }
                            catch (Exception ex)
                            {
                                Log.ErrorFormat("Error occured while parsing form data\n {0}", ex.ToString());
                            }
                        }
                    }



                    w.InstallDate = DateTime.Now;
                    Log.InfoFormat("Now calling Save");
                    var saveResultSet = context.SaveWorkOrder(w.DeviceID, w.ProjectInventoryID, w.ScheduleID, w.InstallerID, DateTime.Now, w.NewSerial, w.CorrectSerial, w.PrevRead, w.OldRead, w.NewRead, w.AltRead, w.PlumbingTime, w.WiringTime, w.NewRemoteID, w.OldSize, w.NewSize, w.OldPhoto, w.NewPhoto, w.Photo3, w.Photo4, w.Photo5, w.Sig1, w.Notes, w.SkipReason, w.JobComplete, w.JobSkipped, w.CompoundMeter, w.Photo6, w.Photo7, w.OldPhotoLatitude, w.OldPhotoLongitude, w.NewPhotoLatitude, w.NewPhotoLongitude, w.Photo3Latitude, w.Photo3Longitude, w.Photo4Latitude, w.Photo4Longitude, w.Photo5Latitude, w.Photo5Longitude, w.Photo6Latitude, w.Photo6Longitude, w.Photo7Latitude, w.Photo7Longitude, w.JobSubmissionLatitude, w.JobSubmissionLongitude);
                    // int recordsAffected = context.SaveChanges();
                    Log.InfoFormat("Save called successfully");
                    SaveWorkOrder_Result i1 = saveResultSet.FirstOrDefault();
                    int recordsAffected     = i1.RESULT;
                    Log.InfoFormat("number of records updated->" + recordsAffected);
                    foreach (var e in context.GetValidationErrors())
                    {
                        Log.ErrorFormat(e.ValidationErrors.ToString());
                    }
                    if (recordsAffected == 1)
                    {
                        return(Request.CreateResponse(HttpStatusCode.Created));
                    }
                    else
                    {
                        return(Request.CreateResponse(HttpStatusCode.NotFound));
                    }
                }
            }
            catch (System.Exception e)
            {
                Log.ErrorFormat(e.ToString());
                return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e));
            }
        }