Пример #1
0
        public static ReadFrequencyList ViewReadFrequencyRecord(Int32 FrequencyID)
        {
            ReadFrequencyList objFrequency = new ReadFrequencyList();
               using (var context = new SycousCon())
               {
               try
               {

                   objFrequency = (from N in context.ReadFrequencies
                                join C in context.ClientMasters
                                   on N.ClientID equals C.ClientID
                                join S in context.SiteMasters
                                on N.SiteID equals S.Id
                                   where (N.IsDeleted == 0 && N.ID == FrequencyID)
                                   select new ReadFrequencyList
                                {
                                    ID = SqlFunctions.StringConvert((Double)N.ID).Trim(),
                                    FrequencyName = N.FrequencyName,
                                    Site = S.SiteName,
                                    ClientID = SqlFunctions.StringConvert((Double)C.ClientID).Trim(),
                                    Client = C.Name,
                                    SiteID = SqlFunctions.StringConvert((Double)S.Id).Trim(),

                                    FrequencyDay =
                                    (
                                         SqlFunctions.StringConvert((Double)N.FrequencyDay).Trim() == "1" ? "Sunday" :
                                         SqlFunctions.StringConvert((Double)N.FrequencyDay).Trim() == "2" ? "Monday" :
                                         SqlFunctions.StringConvert((Double)N.FrequencyDay).Trim() == "3" ? "Tuesday" :
                                         SqlFunctions.StringConvert((Double)N.FrequencyDay).Trim() == "4" ? "Wednesday" :
                                         SqlFunctions.StringConvert((Double)N.FrequencyDay).Trim() == "5" ? "Thursday" :
                                         SqlFunctions.StringConvert((Double)N.FrequencyDay).Trim() == "6" ? "Friday" :
                                         SqlFunctions.StringConvert((Double)N.FrequencyDay).Trim() == "7" ? "Saturday" : "UnKnown"
                                    ),
                                    FrequencyMode = (SqlFunctions.StringConvert((Double)N.FrequencyMode).Trim() == "1" ? "Daily" :
                                                       SqlFunctions.StringConvert((Double)N.FrequencyMode).Trim() == "2" ? "Weekly" :
                                                       SqlFunctions.StringConvert((Double)N.FrequencyMode).Trim() == "3" ? "Monthly" : ""
                                    ),
                                    DayOfMonth = N.DayOfMonth

                                }).FirstOrDefault();

                   return objFrequency;

               }
               catch (Exception ex)
               {
                   context.Dispose();
                   throw;
               }
               }
        }
 public ActionResult DView(String ID)
 {
     if (Session["Login"] != null)
     {
         LoginSession loginsession = (LoginSession)Session["Login"];
         ViewBag.CompanyLogo = loginsession.CompanyLogo;
         ViewBag.Layout1 = BAL.Common.LayoutType(loginsession.UserType);
         String actionName = this.ControllerContext.RouteData.Values["action"].ToString();
         String controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
         ViewBag.Menu = BAL.Common.GetActiveMenu(controllerName, actionName, BAL.Common.LayoutType(loginsession.UserType));
         ViewBag.RoleName = loginsession.RoleName;
         if (ID != null)
         {
             String DecID = BAL.Security.URLDecrypt(ID);
             ReadFrequencyList Frequency = new ReadFrequencyList();
             if ((DecID != "0") && (DecID != null))
             {
                 Frequency = BAL.ReadFrequencyModel.ViewReadingFrequency(DecID);
             }
             return View(Frequency);
         }
         else
         { return RedirectToAction("Index", "ReadingFrequency"); }
     }
     else
     { return RedirectToAction("Index", "Home"); }
 }
Пример #3
0
        public Object ViewRecord(Int64 FrequenceID)
        {
            DAL.ReadFrequencyList Frequence = new ReadFrequencyList();

               try
               {
               Frequence = DAL.DALReadFrequency.ViewReadFrequencyRecord(Convert.ToInt32(FrequenceID));
               }
               catch (Exception ex)
               {
               throw;
               }
               return Frequence;
        }