public int Delete(int id)
        {
            int affectedRows = 0;

            using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
            {
                using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
                {
                    try
                    {
                        OnlineDrive deleteModel = dbo.OnlineDrives.Find(id);
                        dbo.OnlineDrives.Remove(deleteModel);
                        affectedRows = dbo.SaveChanges();
                        transaction.Commit();
                    }
                    catch (Exception)
                    {
                        transaction.Rollback();
                    }
                    finally
                    {
                        transaction.Dispose();
                    }
                }
            }
            return(affectedRows);
        }
        public int Post(Menu model)
        {
            int affectedRows = 0;

            using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
            {
                using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
                {
                    try
                    {
                        dbo.Menus.Add(model);
                        affectedRows = dbo.SaveChanges();
                        transaction.Commit();
                    }
                    catch (Exception)
                    {
                        transaction.Rollback();
                    }
                    finally
                    {
                        transaction.Dispose();
                    }
                }
            }
            return(affectedRows);
        }
        public int Put(OnlineDrive model)
        {
            int affectedRows = 0;

            using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
            {
                using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
                {
                    try
                    {
                        OnlineDrive updateModel = dbo.OnlineDrives.Find(model.Id);
                        updateModel.Id            = model.Id;
                        updateModel.FileNameGUID  = model.FileName;
                        updateModel.FileName      = model.FileName;
                        updateModel.FilePath      = model.FilePath;
                        updateModel.UploadedOn    = model.UploadedOn;
                        updateModel.UploadedBy    = model.UploadedBy;
                        updateModel.LastUpdatedOn = model.LastUpdatedOn;
                        updateModel.LastUpdatedBy = model.LastUpdatedBy;

                        dbo.OnlineDrives.Add(updateModel);
                        dbo.Entry(updateModel).State = System.Data.Entity.EntityState.Modified;
                        affectedRows = dbo.SaveChanges();
                        transaction.Commit();
                    }
                    catch (Exception)
                    {
                        transaction.Rollback();
                    }
                    finally
                    {
                        transaction.Dispose();
                    }
                }
            }
            return(affectedRows);
        }
        public int Put(Menu model)
        {
            int affectedRows = 0;

            using (ArcanysOnlineEntities dbo = new ArcanysOnlineEntities())
            {
                using (DbContextTransaction transaction = dbo.Database.BeginTransaction(System.Data.IsolationLevel.ReadCommitted))
                {
                    try
                    {
                        Menu updateModel = dbo.Menus.Find(model.PageID);
                        updateModel.PageID          = model.PageID;
                        updateModel.PageName        = model.PageName;
                        updateModel.PageDescription = model.PageDescription;
                        updateModel.PageURL         = model.PageURL;
                        updateModel.PageIcon        = model.PageIcon;
                        updateModel.isEnabled       = model.isEnabled;
                        updateModel.CreatedOn       = model.CreatedOn;
                        updateModel.CreatedBy       = model.CreatedBy;

                        dbo.Menus.Add(updateModel);
                        dbo.Entry(updateModel).State = System.Data.Entity.EntityState.Modified;
                        affectedRows = dbo.SaveChanges();
                        transaction.Commit();
                    }
                    catch (Exception)
                    {
                        transaction.Rollback();
                    }
                    finally
                    {
                        transaction.Dispose();
                    }
                }
            }
            return(affectedRows);
        }