Example #1
0
        private void dependency_OnChange(object sender, SqlNotificationEventArgs e)
        {
            CustomerHub.Show();

            //if(e.Type == SqlNotificationType.Change)
            //{
            //    CustomerHub.Show();
            //}
        }
        public ActionResult Insert(t_empresa model)
        {
            madrigaldev_testEntities context = new madrigaldev_testEntities();
            var added = context.t_empresa.Add(model);

            context.SaveChanges();
            CustomerHub.BroadcastData();
            return(View("Insert"));
        }
        public static string GetCustomerHub(RestCommand command, int customerHubID)
        {
            CustomerHub customerHub = CustomerHubs.GetCustomerHub(command.LoginUser, customerHubID);

            if (customerHub.OrganizationID != command.Organization.OrganizationID)
            {
                throw new RestException(HttpStatusCode.Unauthorized);
            }
            return(customerHub.GetXml("CustomerHub", true));
        }
        public ActionResult Delete(Customer customer)
        {
            using (var context = new CustomerContext())
            {
                var custRecord = context.Customers.Find(customer.CustomerID);
                context.Customers.Remove(custRecord);
                context.SaveChanges();
            }

            //Once the record is inserted , then notify all the subscribers (Clients)
            CustomerHub.NotifyCurrentCustomerInformationToAllClients();
            return(RedirectToAction("Index"));
        }
        void sqlDep_OnChange(object sender, SqlNotificationEventArgs e)
        {
            //or you can also check => if (e.Info == SqlNotificationInfo.Insert) , if you want notification only for inserted record
            if (e.Type == SqlNotificationType.Change)
            {
                SqlDependency sqlDep = sender as SqlDependency;
                sqlDep.OnChange -= sqlDep_OnChange;

                //from here we will send notification message to client
                var notificationHub = GlobalHost.ConnectionManager.GetHubContext <CustomerHub>();
                notificationHub.Clients.All.notify("added");
                CustomerHub.BroadcastData();
                //re-register notification
                RegisterNotification(DateTime.Now);
            }
        }
Example #6
0
        public ActionResult Delete(int id)
        {
            int result = 0;

            try
            {
                object[] parameters = { id };
                result = objCust.Delete(parameters);
                if (result == 1)
                {
                    //Notify to all
                    CustomerHub.BroadcastData();
                }
            }
            catch { }
            return(View("Index"));
        }
Example #7
0
        public ActionResult Update(Customer model)
        {
            int result = 0;

            try
            {
                object[] parameters = { model.Id, model.CustName, model.CustEmail };
                result = objCust.Update(parameters);

                if (result == 1)
                {
                    //Notify to all
                    CustomerHub.BroadcastData();
                }
            }
            catch { }
            return(View("Index"));
        }
Example #8
0
        public ActionResult Insert(CustomerDTO model)
        {
            //int result = 0;
            //try
            //{
            //    if (ModelState.IsValid)
            //    {
            //        object[] parameters = { model.CustName, model.CustEmail };
            //        result = objCust.Insert(parameters);
            //        if (result == 1)
            //        {
            //            //Notify to all
            //            CustomerHub.BroadcastData();
            //        }
            //    }
            //}
            //catch { }
            //return View("Index");

            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri("http://localhost:56775/api/customer");
                var postTask = client.PostAsJsonAsync <CustomerDTO>("customer", model);
                postTask.Wait();

                var postResult = postTask.Result;
                if (postResult.IsSuccessStatusCode)
                {
                    CustomerHub.BroadcastData();
                }
            }

            ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator.");

            Customer cus = new Customer()
            {
                Id        = model.Id,
                CustName  = model.CustName,
                CustEmail = model.CustEmail
            };

            return(View(cus));
        }
        public ActionResult Update(Customer customer)
        {
            using (var context = new CustomerContext())
            {
                var custRecord = context.Customers.Find(customer.CustomerID);

                custRecord.CustomerName = customer.CustomerName;
                custRecord.EmailAdress  = customer.EmailAdress;
                custRecord.MobileNumber = customer.MobileNumber;

                context.Customers.Add(custRecord);

                context.Entry(custRecord).State = EntityState.Modified;
                context.SaveChanges();
            }

            //Once the record is inserted , then notify all the subscribers (Clients)
            CustomerHub.NotifyCurrentCustomerInformationToAllClients();
            return(RedirectToAction("Index"));
        }
Example #10
0
        public ActionResult Insert(Customer model)
        {
            int result = 0;

            try
            {
                if (ModelState.IsValid)
                {
                    object[] parameters = { model.CustName, model.CustEmail };
                    result = objCust.Insert(parameters);
                    if (result == 1)
                    {
                        //Notify to all
                        CustomerHub.BroadcastData();
                    }
                }
            }
            catch { }
            return(View("Index"));
        }
        public ActionResult Insert(Customer customer)
        {
            if (ModelState.IsValid)
            {
                //Insert into Customer table
                using (var context = new CustomerContext())
                {
                    try
                    {
                        context.Customers.Add(customer);
                        context.SaveChanges();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }
                }
            }

            //Once the record is inserted , then notify all the subscribers (Clients)
            CustomerHub.NotifyCurrentCustomerInformationToAllClients();
            return(RedirectToAction("Index"));
        }