/// <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));
}
