private List <Diaries> fetchDiary(SqlCommand cmd)
        {
            SqlConnection  con   = cmd.Connection;
            List <Diaries> diary = null;

            con.Open();
            using (con)
            {
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    diary = new List <Diaries>();
                    while (dr.Read())
                    {
                        Diaries d = new Diaries();
                        d.db_Id      = Convert.ToString(dr["id"]);
                        d.Diary_date = Convert.ToString(dr["diary_date"]);
                        d.Settings   = Convert.ToString(dr["settings"]);
                        diary.Add(d);
                    }
                    diary.TrimExcess();
                }
            }
            return(diary);
        }
        public ActionResult PublishDiary(Diary pd, int id)
        {
            if (Session["Username"] == null && Session["Password"] == null)
            {
                return(RedirectToAction("Index", "Admin", new { area = "" }));
            }
            else
            {
                if (ModelState.IsValid)
                {
                    Diaries diary = new Diaries();
                    diary.Settings = pd.Settings;
                    //new Cateloge().PublishSubResults(diary, id);
                    if (pd.Settings == "2")
                    {
                        TempData["Msg"] = "Diary Have Published Successfully";
                    }
                    else
                    {
                        TempData["Msg"] = "Diary Have Blocked Successfully";
                    }
                    return(RedirectToAction("View", new { id = id }));
                }

                return(RedirectToAction("Index"));
            }
        }
예제 #3
0
        public void SettingsDiary(Diaries pd, int id)
        {
            SqlCommand cmd = new SqlCommand("Update diary Set settings=@Settings Where id = @Id", DALUtil.getConnection());

            cmd.Parameters.AddWithValue("@Id", id);
            cmd.Parameters.AddWithValue("@Settings", (pd.Settings == null) ? Convert.DBNull : pd.Settings);
            _diary(cmd);
        }
예제 #4
0
        public void UpdateDiary(Diaries ud, int id)
        {
            SqlCommand cmd = new SqlCommand("Update diary Set diary_date=@Diary_date Where id=@Id", DALUtil.getConnection());

            cmd.Parameters.AddWithValue("@Id", id);
            cmd.Parameters.AddWithValue("@Diary_date", (ud.Diary_date == null) ? Convert.DBNull : ud.Diary_date);
            _diary(cmd);
        }
예제 #5
0
 public void Signout(bool needsave)
 {
     Status = $"感谢使用!";
     if (needsave)
     {
         Save();
     }
     Currentuser = null;
     Diaries.Clear();
     AllDiaries.Clear();
 }
예제 #6
0
        public void AddDiary(Diaries d)
        {
            SqlCommand cmd = new SqlCommand("INSERT into diary (diary_date,settings,date,month,year,time) VALUES (@Diary_date,'2',@Date,@Month,@Year,@Time)", DALUtil.getConnection());

            cmd.Parameters.AddWithValue("@Diary_date", (d.Diary_date == null) ? Convert.DBNull : d.Diary_date);
            cmd.Parameters.AddWithValue("@Date", (d.Date == null) ? Convert.DBNull : d.Date);
            cmd.Parameters.AddWithValue("@Month", (d.Month == null) ? Convert.DBNull : d.Month);
            cmd.Parameters.AddWithValue("@Year", (d.Year == null) ? Convert.DBNull : d.Year);
            cmd.Parameters.AddWithValue("@Time", (d.Time == null) ? Convert.DBNull : d.Time);
            _diary(cmd);
        }
예제 #7
0
        public void InitializeDiary()
        {
            AllDiaries.Clear();
            Diaries.Clear();
            var QDiaries = from r in DataContext.Diary where r.UserID == Currentuser.ID select r;

            foreach (var QD in QDiaries)
            {
                AllDiaries.Add(QD);
                Diaries.Add(QD);
            }
        }
예제 #8
0
        public DiaryViewModel() : base()
        {
            logger.Trace("DiaryViewmodel()...");
            _selectedDate = DateTime.Now.Date;
            _diaries      = new AsyncObservableCollection <Diary>();
            var rooms = DesktopApplication.Librarian.GetItems(typeof(Room), new List <RetrievalCriteria>());

            foreach (IDataStoreItem i in rooms)
            {
                if ((i as Room).CameraRoom)
                {
                    Diary d = new Diary(this, (i as Room));
                    Diaries.Add(d);
                }
            }
            logger.Trace(Diaries.Count + " Diaries created ");
        }
예제 #9
0
        public void CreateDiary(string ntitle, string ncontent)
        {
            if (string.IsNullOrWhiteSpace(ntitle))
            {
                ntitle = "Untitled";
            }
            Diary diary = new Diary {
                UserID   = Currentuser.ID,
                Title    = ntitle,
                Content  = ncontent,
                WritenDT = DateTime.Now
            };

            Diaries.Add(diary);
            AllDiaries.Add(diary);
            Status = "创建日记成功!";
        }
 public ActionResult Edit(Diary Update, int id)
 {
     if (Session["Username"] == null && Session["Password"] == null)
     {
         return(RedirectToAction("Index", "Admin", new { area = "" }));
     }
     else
     {
         if (ModelState.IsValid)
         {
             Diaries UpdateDiary = new Diaries();
             UpdateDiary.Diary_date = Update.Diary_date;
             new Cateloge().UpdateDiary(UpdateDiary, id);
             TempData["Msg"] = "Diary Have Updated Successfully";
             return(RedirectToAction("Index"));
         }
         return(View(Update));
     }
 }
예제 #11
0
        public void Search()
        {
            Diaries.Clear();
            var NQDiaries = from r in DataContext.Diary where r.UserID == Currentuser.ID select r;

            foreach (var QD in NQDiaries)
            {
                if (!string.IsNullOrWhiteSpace(SearchTitle))
                {
                    if (!QD.Title.Contains(SearchTitle))
                    {
                        continue;
                    }
                }
                if (SearchYear != 0)
                {
                    if (QD.WritenDT.Year != SearchYear)
                    {
                        continue;
                    }
                    if (SearchMonth != 0)
                    {
                        if (QD.WritenDT.Month != SearchMonth)
                        {
                            continue;
                        }
                        if (SearchDay != 0)
                        {
                            if (QD.WritenDT.Day != SearchDay)
                            {
                                continue;
                            }
                        }
                    }
                }
                Diaries.Add(QD);
            }
            Status = $"查询中!";
        }
예제 #12
0
        private void CheckNewDiary()
        {
            DateTime recordedOn = new DateTime(_year, _month, _day);

            Current = Diaries.FirstOrDefault(a => a.RecordDate >= recordedOn.Date && a.RecordDate < recordedOn.Date.AddDays(1));
            if (Current == null)
            {
                _lvwDiarys.SelectedIndex = -1;
                Current = new Diary()
                {
                    ID               = -1,
                    Title            = "[新日记]",
                    Keywords         = string.Empty,
                    Content          = string.Empty,
                    IsRemindRequired = false,
                    JobGroup         = "TaskGroup",
                    JobName          = Guid.NewGuid().ToString(),
                    JobTypeFullName  = $"{typeof(RemindJob).FullName},{System.IO.Path.GetFileName(Common.CurrentAssembly.Location)}",
                    CronExpress      = string.Empty,
                    RunningStart     = null,
                    RunningEnd       = null,
                    RecordDate       = new DateTime(_year, _month, _day),
                    RowVersion       = DateTime.Now
                };
            }

            for (int i = 0; i < _lvwDiarys.Items.Count; i++)
            {
                Diary diary = (Diary)_lvwDiarys.Items[i];
                if (diary.Equals(Current))
                {
                    _lvwDiarys.SelectedIndex = i;
                    break;
                }
            }
            _txtTitle.SelectAll();
            _txtTitle.Focus();
        }
 public ActionResult Create(Diary Add)
 {
     if (Session["Username"] == null && Session["Password"] == null)
     {
         return(RedirectToAction("Index", "Admin", new { area = "" }));
     }
     else
     {
         if (ModelState.IsValid)
         {
             Diaries AddDiary = new Diaries();
             AddDiary.Diary_date = Add.Diary_date;
             AddDiary.Date       = DateTime.Today.ToString("dd-MM-yyyy");
             AddDiary.Month      = DateTime.Today.ToString("MMM");
             AddDiary.Year       = DateTime.Today.ToString("yyyy");
             AddDiary.Time       = DateTime.Now.ToString("HH:mm:ss");
             new Cateloge().AddDiary(AddDiary);
             TempData["Msg"] = "New Diary Have Added Successfully";
             return(RedirectToAction("Index"));
         }
         return(View(Add));
     }
 }
 public void UpdateDiary(Diaries ud, int id)
 {
     new AddAndUpdtDiaryDAL().UpdateDiary(ud, id);
 }
 public void AddDiary(Diaries d)
 {
     new AddAndUpdtDiaryDAL().AddDiary(d);
 }