public RedirectToRouteResult EditCollectionPoint(CollectionPoint[] arr)
        {
            using (SSISdbEntities e = new SSISdbEntities())
            {
                DAL.CollectionPointRepositoryImpl dal = new DAL.CollectionPointRepositoryImpl(e);
                dal.UpdateCollectionPoint(arr[0]);
                e.SaveChanges();

                Session["MaintenanceCollectionPointsPage"] = "1";

                return(RedirectToAction("Maintenance", "Store"));
            }
        }
        public RedirectToRouteResult AddNewCollectionPoint(CollectionPoint cp)
        {
            using (SSISdbEntities e = new SSISdbEntities())
            {
                string collectionPtCount = (e.CollectionPoints.Count() + 1).ToString();
                cp.CollectionPointID = "CP" + collectionPtCount;
                cp.Active            = 1;

                DAL.CollectionPointRepositoryImpl dal = new DAL.CollectionPointRepositoryImpl(e);
                dal.InsertCollectionPoint(cp);
                e.SaveChanges();

                return(RedirectToAction("Maintenance", "Store"));
            }
        }