/// <summary> /// Data Access Layer for Getting Module /// </summary> public static DataSet GetModules(int action, ContentBO content) { DataSet ds = new DataSet(); MySqlConnection conn = new MySqlConnection(ConnectionManager.connectionString); try { conn.Open(); string stm = "spGetModule"; MySqlCommand cmd = new MySqlCommand(stm, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("p_Action", action); cmd.Parameters.AddWithValue("p_TopicID", content.TopicID); cmd.Parameters.AddWithValue("p_CompID", content.CompID); cmd.Parameters.AddWithValue("p_IsActive", Convert.ToInt32(content.IsActive)); cmd.Parameters.AddWithValue("p_CreatedBy", content.CreatedBy); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(ds, "Data"); return(ds); } catch (Exception ex) { Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); } finally { conn.Close(); } return(ds); }
/// <summary> /// Data Access Layer for GetContentList /// </summary> /// <param name="contentBO"></param> public static DataSet GetContentList(ContentBO content) { DataSet ds = new DataSet(); MySqlConnection conn = new MySqlConnection(ConnectionManager.connectionString); try { conn.Open(); string stm = "spGetContents"; MySqlCommand cmd = new MySqlCommand(stm, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("p_CompID", content.CompID); cmd.Parameters.AddWithValue("p_TopicID", content.TopicID); cmd.Parameters.AddWithValue("p_ModuleID", content.ModuleID); cmd.Parameters.AddWithValue("p_ContentID", content.ContentID); cmd.Parameters.AddWithValue("p_TypeID", content.ContentTypeID); cmd.Parameters.AddWithValue("p_IsGift", content.IsGift); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(ds, "Data"); return(ds); } catch (Exception ex) { Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); } finally { conn.Close(); } return(ds); }
public ActionResult Category(int?id, string slug) { if (id == 1) { ViewBag.img = "/Content/Images/wm.png"; ViewBag.des = "تعمیر ماشین لباسشویی خود را به متخصصان حرفه ای دینا سرویس بسپارید"; } if (id == 2) { ViewBag.img = "/Content/Images/dwm.png"; ViewBag.des = "تعمیر ماشین ظرفشویی خود را به متخصصان حرفه ای دینا سرویس بسپارید"; } string filter = slug.Replace('-', ' '); ViewBag.PageTitle = $"{filter} تعمیرات تخصصی ماشین لباسشویی,تعمیرات تخصصی ماشین ظرفشویی,تعمیر ماشین لباسشویی,تعمیر ماشین ظرفشویی"; List <DataStructure.Content> list = new List <DataStructure.Content>(); if (id == 3) { list = new ContentBO().Where(c => c.Place == SliderProject.Wash); } else { list = new ContentBO().Where(c => c.Place == SliderProject.Wash && c.Title.Contains(filter)); } return(View(list)); }
public ActionResult Items(int id, string slug) { DataStructure.Content content = new ContentBO().Get(id); ViewBag.brand = new BrandsBO().Get(content.BId).Title; ViewBag.KeyWord = content.KeyWords.Split(',').ToList(); return(View(content)); }
public override bool Delete(params object[] keys) { try { this.ConnectionHandler.StartTransaction(IsolationLevel.ReadUncommitted); this.ContentManagerConnection.StartTransaction(IsolationLevel.ReadUncommitted); var congressContentBo = new ContentBO(); var obj = congressContentBo.Get(this.ConnectionHandler, keys); if (!congressContentBo.Delete(this.ConnectionHandler, keys)) { throw new Exception("خطایی در حذف محتوا وجود دارد"); } if (!ContentManagerComponent.Instance.ContentTransactionalFacade(this.ContentManagerConnection).Delete(obj.ContentId)) { throw new Exception("خطایی در حذف محتوا وجود دارد"); } this.ConnectionHandler.CommitTransaction(); this.ContentManagerConnection.CommitTransaction(); return(true); } catch (KnownException knownException) { this.ConnectionHandler.RollBack(); this.ContentManagerConnection.RollBack(); throw new KnownException(knownException.Message, knownException); } catch (Exception ex) { this.ConnectionHandler.RollBack(); this.ContentManagerConnection.RollBack(); throw new KnownException(ex.Message, ex); } }
public ActionResult Edit(int id) { ViewBag.BrandsId = new SelectList(new BrandsBO().GetAll(), "BrandsId", "Title"); var content = new ContentBO().Get(id); return(View(content)); }
public override bool Delete(params object[] keys) { try { this.ConnectionHandler.StartTransaction(IsolationLevel.ReadUncommitted); this.FileManagerConnection.StartTransaction(IsolationLevel.ReadUncommitted); var obj = new MenuBO().Get(this.ConnectionHandler, keys); if (obj == null) { return(false); } if (obj.ImageUrl != null) { if ( !FileManagerComponent.Instance.FileTransactionalFacade(this.FileManagerConnection) .Delete(obj.ImageUrl)) { return(false); } } var contents = new ContentBO().Where(ConnectionHandler, content => content.MenuId == obj.Id); if (contents.Count > 0) { foreach (var content in contents) { content.MenuId = null; if (!new ContentBO().Update(this.ConnectionHandler, content)) { throw new Exception("خطایی در ویرایش منوی محتوا وجود دارد"); } } } if (!new MenuBO().Delete(this.ConnectionHandler, keys)) { throw new Exception("خطایی در ویرایش منو وجود دارد"); } this.ConnectionHandler.CommitTransaction(); this.FileManagerConnection.CommitTransaction(); return(true); } catch (KnownException ex) { this.ConnectionHandler.RollBack(); this.FileManagerConnection.RollBack(); Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } catch (Exception ex) { this.ConnectionHandler.RollBack(); this.FileManagerConnection.RollBack(); Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
public ActionResult List(int id, string slug) { var contents = new ContentBO().Where(c => c.BId == id); var title = new BrandsBO().FirstOrDefault(c => c.BrandsId == id); ViewBag.Brand = title.Title; ViewBag.FileId = title.FileId; ViewBag.Des = $"نمایندگی تعمیرات {title.Title},نمایندگی تعمیر لوازم خانگی {title.Title},تعمیر لوازم خانگی {title.Title},لوازم خانگی {title.Title}"; return(View(contents)); }
public IHttpActionResult GetQuestionAnswer(JObject requestParams) { var data = string.Empty; ContentBO content = new ContentBO(); try { var identity = MyAuthorizationServerProvider.AuthenticateUser(); if (identity != null) { if (!string.IsNullOrEmpty(Convert.ToString(requestParams["QuestionID"]))) { int CompID = identity.CompId; string UserID = identity.UserID; int QuestionID = Convert.ToInt32(requestParams["QuestionID"]); var ds = ContentBL.GetQuestionAnswer(Convert.ToInt32(ConstantMessages.Action.VIEW), CompID, QuestionID, UserID); if (ds != null) { if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { data = Utility.ConvertDataSetToJSONString(ds); data = Utility.Successful(data); } else { data = ConstantMessages.WebServiceLog.GenericErrorMsg; data = Utility.API_Status(Convert.ToInt32(ConstantMessages.StatusCode.Failure).ToString(), data); } } else { data = ConstantMessages.WebServiceLog.GenericErrorMsg; data = Utility.API_Status(Convert.ToInt32(ConstantMessages.StatusCode.Failure).ToString(), data); } } else { data = ConstantMessages.WebServiceLog.InValidValues; data = Utility.API_Status(Convert.ToInt32(ConstantMessages.StatusCode.Failure).ToString(), data); } } else { data = Utility.AuthenticationError(); data = Utility.API_Status(Convert.ToInt32(ConstantMessages.StatusCode.Failure).ToString(), data); } } catch (Exception ex) { data = ex.Message; data = Utility.API_Status(Convert.ToInt32(ConstantMessages.StatusCode.Failure).ToString(), data); } return(new APIResult(Request, data)); }
public ActionResult Result(int id, string slug) { ViewBag.img = "/Content/Images/wm.png"; ViewBag.des = "تعمیر ماشین لباسشویی و تعمیر ماشین ظرفشویی خود را به متخصصان حرفه ای دینا سرویس بسپارید"; string filter = slug.Replace('-', ' '); List <DataStructure.Content> list = new ContentBO().Where(c => c.Place == SliderProject.Wash && c.Title.Contains(filter)); return(View(list)); }
/// <summary> /// Data Access Layer for Content Creation and Modification /// </summary> public static DataSet CreateContent(int Action, ContentBO content) { DataSet ds = new DataSet(); MySqlConnection conn = new MySqlConnection(ConnectionManager.connectionString); try { conn.Open(); string stm = "spCreateContent"; MySqlCommand cmd = new MySqlCommand(stm, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("p_Action", Action); cmd.Parameters.AddWithValue("p_CompID", content.CompID); cmd.Parameters.AddWithValue("p_TopicID", content.TopicID); cmd.Parameters.AddWithValue("p_ModuleID", content.ModuleID); cmd.Parameters.AddWithValue("p_ContentID", content.ContentID); cmd.Parameters.AddWithValue("p_TypeID", content.ContentTypeID); cmd.Parameters.AddWithValue("p_DocType", content.DocType); cmd.Parameters.AddWithValue("p_ContentFileID", content.ContentFileID); cmd.Parameters.AddWithValue("p_Title", content.ContentTitle.Trim()); cmd.Parameters.AddWithValue("p_FlashcardHighlights", content.FlashcardHighlights); cmd.Parameters.AddWithValue("p_Description", content.ContentDescription); cmd.Parameters.AddWithValue("p_Points", content.Points); cmd.Parameters.AddWithValue("p_Overview", content.ModuleOverview);//Overview column cmd.Parameters.AddWithValue("p_FlashcardTitle", content.FlashcardTitle); cmd.Parameters.AddWithValue("p_SkipFlashcards", Convert.ToInt32(content.SkipFlashcard)); cmd.Parameters.AddWithValue("p_IsGift", Convert.ToInt32(content.IsGift)); cmd.Parameters.AddWithValue("p_IsPublished", Convert.ToInt32(content.IsPublished)); cmd.Parameters.AddWithValue("p_IsActive", Convert.ToInt32(content.IsActive)); cmd.Parameters.AddWithValue("p_TotalScore", content.TotalScore); cmd.Parameters.AddWithValue("p_PassingPercent", content.PassingPercent); cmd.Parameters.AddWithValue("p_PassingScore", content.PassingScore); cmd.Parameters.AddWithValue("p_CreatedBy", content.CreatedBy); cmd.Parameters.AddWithValue("p_CourseTime", content.CourseTime); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(ds, "Data"); return(ds); } catch (Exception ex) { Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); } finally { conn.Close(); } return(ds); }
public ContentResult GetRSS() { StringBuilder builder = new StringBuilder(); builder.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?>"); List <Content> contents = new ContentBO().GetSiteMapContent(SliderProject.Wash); XDocument rss = new XDocument(new XDeclaration("1.0", "utf-8", "yes"), new XElement("rss", new XAttribute("version", "2.0"), new XElement("channel", new XElement("title", "آخرین مطالب سایت دیناسرویس"), new XElement("link", "http://dinaservice.com/feed.xml"), new XElement("description", "آخرین مطالب سایت دیناسرویس"), new XElement("copyright", "(c)" + DateTime.Now.Year + ", دینا سرویس.تمامی حقوق محفوظ است"), from item in contents select new XElement("item", new XElement("title", item.Title), new XElement("description", item.Description), new XElement("link", item.Link), new XElement("pubDate", item.PublicDate) ) ) ) ); builder.AppendLine(rss.ToString()); string path = Server.MapPath("~/feed.xml"); if (!System.IO.File.Exists(path)) { using (FileStream fs = System.IO.File.Create(path)) { byte[] info = new UTF8Encoding(true).GetBytes(builder.ToString()); fs.Write(info, 0, info.Length); } } else { using (FileStream fs = System.IO.File.OpenWrite(path)) { byte[] info = new UTF8Encoding(true).GetBytes(builder.ToString()); fs.Write(info, 0, info.Length); } } return(Content(rss.ToString(), "text/xml")); }
public static DataSet CreateContent(ContentBO content) { DataSet ds = new DataSet(); try { ds = ContentDAL.CreateContent((int)ConstantMessages.Action.INSERT, content); } catch (Exception ex) { Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); } return(ds); }
public static DataSet ModifyTopic(ContentBO content) { DataSet ds = new DataSet(); try { ds = ContentDAL.CreateTopic(Convert.ToInt32(ConstantMessages.Action.MODIFY), content); } catch (Exception ex) { Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); } return(ds); }
public static DataSet DeleteTopic(ContentBO content, int Action) { DataSet ds = new DataSet(); try { ds = ContentDAL.DeleteTopic(content, Action); } catch (Exception ex) { Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); } return(ds); }
public static DataSet AssignTopics(ContentBO content) { DataSet ds = new DataSet(); try { ds = ContentDAL.AssignTopics(content); } catch (Exception ex) { Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); } return(ds); }
public static DataSet GetModules(int action, ContentBO content) { DataSet ds = new DataSet(); try { ds = ContentDAL.GetModules(action, content); } catch (Exception ex) { Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); } return(ds); }
public IHttpActionResult DeleteContent(JObject requestParams) { var data = ""; var identity = MyAuthorizationServerProvider.AuthenticateUser(); if (identity != null) { try { var compId = identity.CompId; var userId = identity.UserID; ContentBO content = new ContentBO(); content.CompID = identity.CompId; content.CreatedBy = identity.UserID; content.ContentID = Convert.ToInt32(requestParams["ContentID"]); var ds = ContentBL.DeleteContent(content); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows[0]["StatusCode"].ToString() == "1") { // Successful data = Utility.Successful(""); } else { // Error. Check Logs data = Utility.API_Status("1", "There might be some error. Please try again later"); } } else { // Unknown Error data = Utility.API_Status("1", "Unknown Error"); } } catch (Exception ex) { data = Utility.Exception(ex);; } } else { data = Utility.AuthenticationError(); } return(new APIResult(Request, data)); }
public IEnumerable <Content> Search(string qry) { try { var list = new ContentBO().Search(this.ConnectionHandler, qry); return(list); } catch (KnownException ex) { throw new KnownException(ex.Message, ex); } catch (Exception ex) { Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
public List <Partials> GetContentPartials(string culture) { try { var contentBo = new ContentBO(); var contents = contentBo.Where(ConnectionHandler, x => x.Enabled && x.IsExternal == false); return(new PartialsBO().GetContentPartials(ConnectionHandler, contents, culture)); } catch (KnownException ex) { throw new KnownException(ex.Message, ex); } catch (Exception ex) { Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
public List <Partials> GetWebDesignContent(Guid WebId, string culture) { try { var contents = new ContentBO().Select(this.ConnectionHandler, new Expression <Func <Content, object> >[] { x => x.ContentId, x => x.WebSiteContent.Title, x => x.WebSiteContent.Enabled }, x => x.WebId == WebId); var @select = contents.Select(i => (int)i.ContentId); return(ContentManagerComponent.Instance.PartialsFacade.GetContentPartials(@select, culture)); } catch (KnownException ex) { throw new KnownException(ex.Message, ex); } catch (Exception ex) { throw new KnownException(ex.Message, ex); } }
public List <Partials> GetContentPartials(IEnumerable <int> idlist, string culture) { try { var contentBo = new ContentBO(); var contents = contentBo.Where(ConnectionHandler, x => x.Id.In(idlist)); return(new PartialsBO().GetContentPartials(ConnectionHandler, contents, culture)); } catch (KnownException ex) { throw new KnownException(ex.Message, ex); } catch (Exception ex) { Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
public string GetHtml(int Id, string culture) { try { var content = new ContentBO().Get(this.ConnectionHandler, Id); if (content == null) { return(string.Empty); } return(new ContentBO().GetHtml(this.ConnectionHandler, content, culture)); } catch (KnownException ex) { throw new KnownException(ex.Message, ex); } catch (Exception ex) { Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
public ContentResult GetSiteMap() { StringBuilder builder = new StringBuilder(); builder.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?>"); XNamespace ns = "http://www.sitemaps.org/schemas/sitemap/0.9"; List <Content> contents = new ContentBO().GetSiteMapContent(SliderProject.Orgin); XDocument sitemap = new XDocument(new XDeclaration("1.0", "utf-8", "yes"), new XElement(ns + "urlset", from item in contents select new XElement("url", new XElement("loc", item.Link), new XElement("changefreq", "monthly"), new XElement("priority", "0.5")))); var x = sitemap.ToString(); string res = x.Replace("<url xmlns=\"\">", "<url>"); builder.AppendLine(res); string path = Server.MapPath("~/Sitemap.xml"); if (!System.IO.File.Exists(path)) { using (FileStream fs = System.IO.File.Create(path)) { byte[] info = new UTF8Encoding(true).GetBytes(builder.ToString()); // Add some information to the file. fs.Write(info, 0, info.Length); } } else { using (FileStream fs = System.IO.File.OpenWrite(path)) { byte[] info = new UTF8Encoding(true).GetBytes(builder.ToString()); fs.Write(info, 0, info.Length); } } return(Content(sitemap.ToString(), "text/xml")); }
public override bool Delete(params object[] keys) { try { this.ConnectionHandler.StartTransaction(IsolationLevel.ReadUncommitted); var obj = new ContentBO().Get(this.ConnectionHandler, keys); var contentContents = new ContentContentBO().Where(ConnectionHandler, contentContent => contentContent.Id == obj.Id); if (contentContents.Count > 0) { foreach (var contentContent in contentContents) { if ( !new ContentContentBO().Delete(this.ConnectionHandler, contentContent.Id, contentContent.LanguageId)) { throw new Exception("خطایی در حذف محتوای محتوا وجود دارد"); } } } if (!new ContentBO().Delete(this.ConnectionHandler, keys)) { throw new Exception("خطایی در حذف محتوا وجود دارد"); } this.ConnectionHandler.CommitTransaction(); return(true); } catch (KnownException ex) { this.ConnectionHandler.RollBack(); throw new KnownException(ex.Message, ex); } catch (Exception ex) { this.ConnectionHandler.RollBack(); Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
public IHttpActionResult GetContentList(JObject requestParams) { var data = ""; var identity = MyAuthorizationServerProvider.AuthenticateUser(); if (identity != null) { try { var topicId = Convert.ToInt32(Convert.ToString(requestParams["TopicID"])); var moduleId = Convert.ToInt32(Convert.ToString(requestParams["ModuleID"])); var contentId = Convert.ToInt32(Convert.ToString(requestParams["ContentID"])); var contentTypeId = Convert.ToInt32(Convert.ToString(requestParams["ContentTypeID"])); var isGift = Convert.ToBoolean(Convert.ToInt32(requestParams["IsGift"])); ContentBO _content = new ContentBO(); _content.CompID = identity.CompId; _content.TopicID = topicId; _content.ModuleID = moduleId; _content.ContentID = contentId; _content.ContentTypeID = contentTypeId; _content.IsGift = isGift; var lstContent = new List <ContentBO>(); var ds = ContentBL.GetContentList_Formatted(_content, ref lstContent); var contentJson = JsonConvert.SerializeObject(lstContent); data = Utility.Successful(contentJson); } catch (Exception ex) { data = Utility.Exception(ex);; } } else { data = Utility.AuthenticationError(); } return(new APIResult(Request, data)); }
public override bool Delete(params object[] keys) { try { this.ConnectionHandler.StartTransaction(IsolationLevel.ReadUncommitted); var containerBO = new ContainerBO(); var obj = containerBO.Get(this.ConnectionHandler, keys); var contents = new ContentBO().Any(ConnectionHandler, container => container.ContainerId == obj.Id); if (contents) { throw new Exception("این قالب در محتوا استفاده شده است و قابل حذف نیست"); } if (!containerBO.Delete(this.ConnectionHandler, keys)) { throw new Exception("خطایی در حذف قالب وجود دارد"); } this.ConnectionHandler.CommitTransaction(); return(true); } catch (KnownException ex) { this.ConnectionHandler.RollBack(); Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } catch (Exception ex) { this.ConnectionHandler.RollBack(); Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
/// <summary> /// Data Access Layer for Module Creation and Modification /// </summary> public static DataSet CreateModule(int Action, ContentBO content) { DataSet ds = new DataSet(); MySqlConnection conn = new MySqlConnection(ConnectionManager.connectionString); try { conn.Open(); string stm = "spCreateModule"; MySqlCommand cmd = new MySqlCommand(stm, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("p_Action", Action); cmd.Parameters.AddWithValue("p_ModuleID", content.ModuleID); cmd.Parameters.AddWithValue("p_TopicID", content.TopicID); cmd.Parameters.AddWithValue("p_CompID", content.CompID); //if (!string.IsNullOrEmpty(content.UserIDs)) //{ // cmd.Parameters.AddWithValue("p_UserID", content.UserIDs); //} //else //{ // cmd.Parameters.AddWithValue("p_UserID", DBNull.Value); //} if (!string.IsNullOrEmpty(content.ModuleTitle)) { cmd.Parameters.AddWithValue("p_Title", content.ModuleTitle.Trim().ToString()); } else { cmd.Parameters.AddWithValue("p_Title", DBNull.Value); } if (!string.IsNullOrEmpty(content.ModuleOverview)) { cmd.Parameters.AddWithValue("p_Overview", content.ModuleOverview); } else { cmd.Parameters.AddWithValue("p_Overview", DBNull.Value); } if (!string.IsNullOrEmpty(content.ModuleDescription)) { cmd.Parameters.AddWithValue("p_Description", content.ModuleDescription); } else { cmd.Parameters.AddWithValue("p_Description", DBNull.Value); } cmd.Parameters.AddWithValue("p_SrNo", content.SrNo); cmd.Parameters.AddWithValue("p_IsPublished", Convert.ToInt32(content.IsPublished)); cmd.Parameters.AddWithValue("p_IsActive", Convert.ToInt32(content.IsActive)); cmd.Parameters.AddWithValue("p_CreatedBy", content.CreatedBy); cmd.Parameters.AddWithValue("p_Points", content.Points); if (!string.IsNullOrEmpty(content.CourseTime)) { cmd.Parameters.AddWithValue("p_CourseTime", content.CourseTime); } else { cmd.Parameters.AddWithValue("p_CourseTime", DBNull.Value); } MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(ds, "Data"); return(ds); } catch (Exception ex) { Log(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); } finally { conn.Close(); } return(ds); }
// GET: Content public ActionResult Index() { List <DataStructure.Content> list = new ContentBO().Where(c => c.Place == SliderProject.Wash); return(PartialView("PVIndex", list)); }
public IHttpActionResult SaveContent(JObject requestParams) { var data = ""; var identity = MyAuthorizationServerProvider.AuthenticateUser(); if (identity != null) { try { ContentBO content = new ContentBO(); content.CompID = identity.CompId; content.CreatedBy = identity.UserID; content.TopicID = Convert.ToInt32(Convert.ToString(requestParams["TopicID"])); content.ModuleID = Convert.ToInt32(Convert.ToString(requestParams["ModuleID"])); content.ContentID = 0; if (!string.IsNullOrEmpty(Convert.ToString(requestParams["ContentID"]))) { content.ContentID = Convert.ToInt32(requestParams["ContentID"]); } content.ContentTypeID = Convert.ToInt32(Convert.ToString(requestParams["ContentTypeID"])); content.ContentTitle = Convert.ToString(requestParams["Title"]); content.ContentDescription = Convert.ToString(requestParams["Description"]); content.FlashcardTitle = Convert.ToString(requestParams["IntroTitle"]); content.IsPublished = Convert.ToBoolean(Convert.ToString(requestParams["IsPublished"])); content.SkipFlashcard = Convert.ToBoolean(Convert.ToString(requestParams["SkipFlashcard"])); content.IsActive = true; content.IsGift = Convert.ToBoolean(Convert.ToString(requestParams["IsGift"])); var totalScore = 0.0; var passingScore = 0.0; var passingPercent = 0.0; var docType = ""; if (content.ContentTypeID == 2) { // Survey docType = "SURVEY"; } else if (content.ContentTypeID == 3) { // Flashcards docType = "FLASHCARD"; } else if (content.ContentTypeID == 5) { // Final Quiz docType = "FINALQUIZ"; totalScore = Convert.ToDouble(Convert.ToString(requestParams["TotalScore"])); passingScore = Convert.ToDouble(Convert.ToString(requestParams["PassingScore"])); passingPercent = Convert.ToDouble(Convert.ToString(requestParams["PassingPercentage"])); } content.TotalScore = totalScore; content.PassingScore = passingScore; content.PassingPercent = passingPercent; content.DocType = docType; content.ContentFileID = null; content.FlashcardHighlights = null; var ds = new DataSet(); if (content.ContentID > 0) { ds = ContentBL.ModifyContent(content); } else { ds = ContentBL.CreateContent(content); } if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows[0]["StatusCode"].ToString() == "1") { // Successful data = Utility.Successful(""); } else { // Error. Check Logs data = Utility.API_Status("1", "There might be some error. Please try again later"); } } else { // Unknown Error data = Utility.API_Status("1", "Unknown Error"); } } catch (Exception ex) { data = Utility.Exception(ex);; } } else { data = Utility.AuthenticationError(); } return(new APIResult(Request, data)); }