Пример #1
0
        public ActionResult UpdatePickup(Pickup pickup)
        {
            // get the current user 
            //
            string currentUserId = User.Identity.GetUserId();
            string fullName = null;
            try
            {
                
                // Get info for Current user
                //
                ApplicationUser currentUser = db.Users.FirstOrDefault(x => x.Id == currentUserId);
                
                // Get user's full name to notify others
                //
                fullName = currentUser.FirstName + " " + currentUser.LastName;


            }
            catch (Exception ex)
            {

                Debug.Write("Error autheticating user: "******"none";

                        // Update Comnpany Data
                        //
                        newItem.Company = "ZFM";

                        db2.Items.Add(newItem);
                    }
                }

                try
                {
                    db2.SaveChanges();
                }
                catch (Exception e)
                {
                    Console.WriteLine(e);
                    // Provide for exceptions.
                }

                #endregion

                pickup.LastEditBy = fullName;
                
                //Azure time conversion
                //
                DateTime timeUtc = DateTime.UtcNow;
                TimeZoneInfo pstZone = TimeZoneInfo.FindSystemTimeZoneById("Pacific Standard Time");
                DateTime pstTime = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, pstZone);

                pickup.LastModified = pstTime;


                //BMK Pickup Completed
                //
                if (pickup.Status.ToLower().Contains("completed") || pickup.Status.ToLower().Contains("closed"))
                {
                    pickup.Closed = pstNow();
                    pickup.ClosedBy = fullName;


                    // then delete all the pictures if any
                    foreach (var item in pickup.Items)
                    {
                        // Get file and erase
                        if (!String.IsNullOrEmpty(item.Picture1) && item.Picture1 != "none")
                        {
                            // Get file name
                            var file = Path.GetFileName(item.Picture1);
                            // Create Path

                            var path = Path.Combine(Server.MapPath("/Content/Photos/"), file);

                            // Erase File
                            FileInfo fi1 = new FileInfo(path);

                            if (fi1.Exists)     // check  if its there and delete
                                fi1.Delete();

                        }
                    }


                }

                //BMK Pickup Completed with SMS
                //
                if (pickup.Status.ToLower().Contains("completed sms") || pickup.Status.ToLower().Contains("closed sms"))
                {
                    
                    // Update the Status 
                    //
                    pickup.Closed = pstNow();
                    pickup.ClosedBy = fullName;

                    // Get the Sales Rep Number
                    //
                    ApplicationUser salesRep4PU = db.Users.FirstOrDefault(x => x.FirstName + " " + x.LastName == pickup.Rep);

                    // Get user's full name to notify others
                    //
                    string repSMS = salesRep4PU.CellNumber;


                    // Get the Courier Number
                    //
                    ApplicationUser courierSMS = db.Users.FirstOrDefault(x => x.FirstName + " " + x.LastName == pickup.TransporterName);

                    // Get user's full name to notify others
                    //
                    string trasportSMS = courierSMS.CellNumber;


                    // Cleanup
                    //
                    salesRep4PU = null;
                    courierSMS = null;

                    // Add the Prefix ( +1 ) if the numbers don't have them 
                    //
                    if(repSMS.Substring(0, 2) != "+1")
                        repSMS = "+1" + repSMS;

                    if (trasportSMS.Substring(0, 2) != "+1")
                        trasportSMS = "+1" + trasportSMS;
                    
                    // Send the SMS alert
                    //
                    
                    // Find your Account Sid and Auth Token at twilio.com/user/account
                    //
                    string AccountSid = "AC1ac0db79f475dc98b90b50a4f245217f";
                    string AuthToken = "b6c641704a0678be31dc089173aae90a";

                    var twilio = new TwilioRestClient(AccountSid, AuthToken);
                    //var message = twilio.SendMessage(repSMS, trasportSMS, "Pickup #: " + pickup.PickupNumber + " - Closed by: " + pickup.ClosedBy , " -> NOTES: " + pickup.Notes);
                    //var message = twilio.SendMessage( "+15107882884",  repSMS + "," + trasportSMS, "Hello World");

                    // Send Message to Sales Rep
                    //
                    var messageRep = twilio.SendMessage("+15107882884", repSMS, "Pickup #: " + pickup.PickupNumber + "\n\nClosed by: " + pickup.ClosedBy + "\n\n" + pickup.Notes);
                        

                     // Send Message to Courier
                     //
                    var messageCourier = twilio.SendMessage("+15107882884", trasportSMS, "Pickup #: " + pickup.PickupNumber + "\n\nClosed by: " + pickup.ClosedBy + "\n\n" + pickup.Notes);
                     

                     if (messageRep.RestException != null || messageCourier.RestException != null)
                    {

                        
                        // handle the error ...
                        //
                            Debug.Print(messageRep.RestException.Message);
                            Debug.Print(messageCourier.RestException.Message);
                    }



                    // then delete all the pictures if any
                    foreach (var item in pickup.Items)
                    {
                        // Get file and erase
                        if (!String.IsNullOrEmpty(item.Picture1) && item.Picture1 != "none")
                        {
                            // Get file name
                            var file = Path.GetFileName(item.Picture1);
                            // Create Path

                            var path = Path.Combine(Server.MapPath("/Content/Photos/"), file);

                            // Erase File
                            FileInfo fi1 = new FileInfo(path);

                            if (fi1.Exists)     // check  if its there and delete
                                fi1.Delete();

                        }
                    }


                }


                db2.Entry(pickup).State = EntityState.Modified;
                db2.SaveChanges();

                // Check if the Location Already Exists
                //
                var locationCheck = (from l in db2.Locations
                                     where l.Name.Contains(pickup.LocationName)
                                     select l);

                if (locationCheck.Count() == 0)
                {
                    // Add it to the Locations database
                    Location newLocatioEntry = new Location
                    {
                        Name = pickup.LocationName

                    };
                    db2.Locations.Add(newLocatioEntry);
                    db2.SaveChanges();
                }

                // Send Message To All Users To Update Pickup List
                //              
                string updatedPickup = pickup.PickupNumber.ToString();  // Get Pickup Number

                var hub = Microsoft.AspNet.SignalR.GlobalHost.ConnectionManager.GetHubContext<ZTRAK.Hubs.PickupHub>();
                hub.Clients.All.newDataUpdate(fullName, updatedPickup);

                return Json(pickup.ID);

                #endregion
            }
            else
            {
                #region Create a new Pickup

                // Determine if this is a new pickup
                //
                if (pickup.ID == 0)
                {

                    // Convert the pickup to a list so we can remove items if needed
                    //
                    foreach (var item in pickup.Items.ToList())
                    {
                        // Remove Items marked
                        if (item.Qty == 0)
                        {
                            pickup.Items.Remove(item);

                        }
                    }

                    // Update the Company Name for new pickup
                    //
                    pickup.Company = "ZFM";

                    // Save new pickup - fix ID and proceed to save
                    // Calculate the new PickupID and assign it to the new pickup in order to 
                    // avoid drastic number changes
                    var pUcount = (from r in db2.Pickups
                                 where r.ID != null
                                 select r).Count() + 1; // Increase by One for new Pickup

                    pickup.PickupNumber = pUcount;

                    // Get the Team name if the value was not given
                    //
                    if(String.IsNullOrEmpty(pickup.Team))
                    {
                        // Get the Team Name
                        string teamName = (from t in db2.AspNetUsers
                                        where (t.FirstName.ToLower().Trim() + " " + t.LastName.ToLower().Trim() == pickup.Rep.ToLower().Trim())
                                       select t.TeamName).FirstOrDefault(); // Try to Find the Team for the new Pickup

                        // Assign the Team if the Team is found
                        //
                        if(!String.IsNullOrEmpty(teamName))
                        pickup.Team = teamName.ToString();
                    }

                    //
                    db2.Entry(pickup).State = EntityState.Added;
                    db2.SaveChanges();

                    string NewPickup = pickup.PickupNumber.ToString();  // Get Pickup Number


                    // Let the others know
                    //
                    var hub = Microsoft.AspNet.SignalR.GlobalHost.ConnectionManager.GetHubContext<Hubs.PickupHub>();
                    hub.Clients.All.newDataUpdate(fullName, NewPickup);


                    return Json(NewPickup);

                }

                #endregion

            }
            return View();
        }
Пример #2
0
        public JsonResult SaveLocation(string locInfo)
        {

            // Break apart the address
            //
            string[] loc;
            string status="";

            // Extract The fields
            loc = locInfo.Split(',');

            // Check if a duplicate exists
            //
            // Limit return to the first five matches
            string locName = loc[0];
            string locOverwrite = loc[7].Trim();
            var result = db2.Locations
                           .Where(r => r.Name.ToLower() == locName.ToLower() && r.Company == "ZFM")
                           .Select(r => new { label = r.Name }).Distinct();

            // Deyect duplicates
            //
            if (result.Count() >= 1)
            {
                // Duplicate Detected
                status = "duplicate";
            }
            
            if (locOverwrite == "yes" && result.Count() >= 1)
            {
                try
                {
                    // delete existing
                    //
                    using (var ctx = new ZtrakEntities())
                    {

                        var listToRemove = (from i in ctx.Locations
                                        where i.Name.ToLower() == locName.ToLower()  && i.Company == "ZFM"
                                        select i);


                        if (listToRemove.Count() >= 1)
                        {
                            ctx.Locations.RemoveRange(listToRemove);
                            ctx.SaveChanges();
                        }
                    }

                    //Save the Location
                    //
                    Location newLocation = new Location
                    {
                        Name = loc[0].ToLower(),
                        Address = loc[1],
                        City = loc[2],
                        State = loc[3],
                        Zip = loc[4],
                        Latitude = Convert.ToDouble(loc[5]),
                        Longitude = Convert.ToDouble(loc[6]),
                        Company = "ZFM"

                    };

                    // Save it 
                    db2.Locations.Add(newLocation);
                    db2.SaveChanges();
                    status = "saved!";

                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                    // Provide for exceptions.
                }
            }
            
            if (locOverwrite == "no" && result.Count() == 0)
            {
                try
                {
                    //Save the Location
                    //
                    Location newLocation = new Location
                    {
                        Name = loc[0].ToLower(),
                        Address = loc[1],
                        City = loc[2],
                        State = loc[3],
                        Zip = loc[4],
                        Latitude = Convert.ToDouble(loc[5]),
                        Longitude = Convert.ToDouble(loc[6]),
                        Company = "ZFM"

                    };

                    // Save it 
                    db2.Locations.Add(newLocation);
                    db2.SaveChanges();
                    status = "saved!";

                }
                catch (Exception e)
                {
                    Console.WriteLine(e.Message);
                    // Provide for exceptions.
                }
            }
        
            //
            return Json(new { answer = status }, JsonRequestBehavior.AllowGet);

        }