コード例 #1
0
        public ActionResult ScheduleSetting(EEmailScheduleSetting emailschedulesetting)
        {
            int OK = 1;

            if (ModelState.IsValid)
            {
                string strErr = "";

                if (OK > 0)
                {
                    OK = 0;

                    if (emailschedulesetting.Id < 1)
                    {

                        if (UpdateSQLJob(emailschedulesetting.Period, emailschedulesetting.Active, emailschedulesetting.Frequency, ref strErr))
                        {
                            db.EmailScheduleSetting.Add(emailschedulesetting);
                            OK = 1;
                        }
                    }
                    else
                    {
                        if (UpdateSQLJob(emailschedulesetting.Period, emailschedulesetting.Active, emailschedulesetting.Frequency, ref strErr))
                        {
                            db.Entry(emailschedulesetting).State = EntityState.Modified;
                            OK = 1;
                        }
                    }
                }

                if (OK == 1)
                {
                    db.SaveChanges();
                    ViewBag.ScheduleTaskResult = "(儲存成功)";
                }
                else if(OK == 0)
                {
                    ViewBag.ScheduleTaskResult = String.Format("(儲存失敗:{0})", strErr);
                }

                return View("Index",GetIndexModel());
            }
            else
            {
                ModelState.AddModelError("", "請輸入任一條件值!!");
            }
            return RedirectToAction("Index");
        }
コード例 #2
0
ファイル: CommonUtilities.cs プロジェクト: dannisjuntai/ttcs
 public static int GetPageSize(EmailSrvEntities db)
 {
     int nPageSize = 10;
     var pagesize = db.EmailScheduleSetting.Where(ess => ess.Name == "PageSize");
     if (pagesize == null || pagesize.Count() < 1)
     {
         EEmailScheduleSetting ess = new EEmailScheduleSetting();
         ess.Name = "PageSize";
         ess.Value = "10";
         ess.Period = 1;
         db.EmailScheduleSetting.Add(ess);
         db.SaveChanges();
     }
     else
     {
         bool bOK = false;
         foreach(var ess in pagesize)
         {
             if (bOK)
             {
                 db.EmailScheduleSetting.Remove(ess);
             }
             else
             {
                 try
                 {
                     nPageSize = Convert.ToInt32(ess.Value);
                     bOK = true;
                 }
                 catch
                 {
                     db.EmailScheduleSetting.Remove(ess);
                 }
             }
         }
         if (!bOK)
         {
             EEmailScheduleSetting ess = new EEmailScheduleSetting();
             ess.Name = "PageSize";
             ess.Value = "10";
             ess.Period = 1;
             db.EmailScheduleSetting.Add(ess);
         }
         db.SaveChanges();
     }
     return nPageSize;
 }
コード例 #3
0
        public ActionResult _PartialTemplateVariable(TemplateVariables templatevariables)
        {
            var agentVar = db.EmailScheduleSetting.Where(s => s.Name == "AgentID").FirstOrDefault();
            if (agentVar == null)
            {
                var emailsetting = new EEmailScheduleSetting();
                emailsetting.Name = "AgentID";
                emailsetting.Value = templatevariables.AgentID;
                emailsetting.Period = 1;
                db.EmailScheduleSetting.Add(emailsetting);
            }
            else
            {
                agentVar.Value = templatevariables.AgentID;
                agentVar.Period = 1;

                db.Entry(agentVar).State = EntityState.Modified;
            }

            db.SaveChanges();
            return RedirectToAction("Index");
        }
コード例 #4
0
        public ActionResult _AjaxUpdateExpireLen(string expirelen)
        {
            try
            {
                var emailschedulesetting = db.EmailScheduleSetting.Where(s => s.Name == "ExpireLen").FirstOrDefault();
                if (emailschedulesetting == null)
                {
                    emailschedulesetting = new EEmailScheduleSetting();
                    emailschedulesetting.Name = "ExpireLen";
                    emailschedulesetting.Value = expirelen;
                    emailschedulesetting.Period = 1;
                    db.EmailScheduleSetting.Add(emailschedulesetting);
                }
                else
                {
                    emailschedulesetting.Value = expirelen;
                    emailschedulesetting.Period = 1;
                    db.Entry(emailschedulesetting).State = EntityState.Modified;

                }
                db.SaveChanges();

                var ret = new
                {
                    result = 1,
                    err = ""
                };
                return Json(ret, JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            {
                var ret = new
                {
                    result = 0,
                    err = ex.Message
                };
                return Json(ret, JsonRequestBehavior.AllowGet);
            }
        }