// GET api/schedule public List <GetSchedules_Result> Get(String DeviceID, String InstallerID, int ProjectID) { Log.InfoFormat("Received the get Request->deviceid->[{0}], installerid ->[{1}, projectid ->[{2}]", DeviceID, InstallerID, ProjectID); try { int installerid = 0; if (DeviceID == null || InstallerID == null || !Int32.TryParse(InstallerID, out installerid)) { throw new HttpResponseException(HttpStatusCode.BadRequest); } using (NeptuneEntities context = new NeptuneEntities()) { List <GetSchedules_Result> schedules = context.GetSchedules(DeviceID, installerid, ProjectID).ToList(); Log.InfoFormat("Schedules Retrieved->[{0}]", schedules.Count); return(schedules); } } catch (Exception ex) { Log.ErrorFormat(ex.ToString()); throw new HttpResponseException(HttpStatusCode.InternalServerError); } }
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(); }