public static List<TrainingCourse> GetCoursesByLocation(string _location)
{
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
var courseList = dbContext.proc_GetCoursesByLocation(_location);
List<TrainingCourse> mylist = new List<TrainingCourse>();
foreach (var c in courseList)
{
TrainingCourse tc = new TrainingCourse();
//tc.Id = c.tc_id.ToString();
tc.Guid = c.tc_empId.ToString();
//tc.Name = c.tc_name;
//tc.Certificate = (int)c.tc_certificate;
//tc.Category = (int)c.tc_category;
//tc.Location = (int)c.tc_location;
tc.Length = c.tc_length;
tc.Timetable = c.tc_timetable;
tc.Cost = c.tc_cost;
tc.Entry = c.tc_entryRequirement;
tc.Contact = c.tc_contact;
tc.Coursecontent = c.tc_courseContent;
tc.Benefit = c.tc_teacherBenefit;
tc.ViewCount = (int)c.tc_viewCount;
mylist.Add(tc);
}
return mylist;
}
public static List<FeaturedLogo> GetAll()
{
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
var all = dbContext.tbl_feature_logos.Where(x=>x.active==true).OrderByDescending(x => x.SortOrder);
List<FeaturedLogo> list = new List<FeaturedLogo>();
foreach (var obj in all)
{
FeaturedLogo fl = new FeaturedLogo();
fl.orgName = obj.OrganizationName;
fl.logo = obj.logo;
fl.username = obj.username;
list.Add(fl);
}
return list;
}
public static FeaturedLogo GetFeatureLogoById(int _id)
{
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
proc_feature_logo_GetByIdResult logo = dbContext.proc_feature_logo_GetById(_id).FirstOrDefault();
if (logo != null)
{
FeaturedLogo fl = new FeaturedLogo();
fl.id = logo.id;
fl.Active = (bool)logo.active;
fl.OrgName = logo.OrganizationName;
fl.Logo = logo.logo;
fl.Username = logo.username;
fl.SortOrder = Convert.ToInt32(logo.SortOrder);
return fl;
}
return null;
}
public static List<TrainingCourse> GetAllTrainingCourse()
{
try
{
List<TrainingCourse> tcList = new List<TrainingCourse>();
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
var allTrainingCourseList = (from tc in dbContext.tbl_TrainingCourses
where tc.tc_active == true
select tc).Take(100);
foreach (var c in allTrainingCourseList)
{
TrainingCourse tc = new TrainingCourse();
tc.Id = c.tc_id.ToString();
tc.Guid = c.tc_empId.ToString();
tc.Name = c.tc_name;
tc.Certificate = (int)c.tc_certificate;
tc.Category = (int)c.tc_category;
tc.Location = (int)c.tc_location;
tc.Length = c.tc_length;
tc.Timetable = c.tc_timetable;
tc.Cost = c.tc_cost;
tc.Entry = c.tc_entryRequirement;
tc.Contact = c.tc_contact;
tc.Coursecontent = c.tc_courseContent;
tc.Benefit = c.tc_teacherBenefit;
tc.ViewCount = (int)c.tc_viewCount;
tcList.Add(tc);
}
return tcList;
}
catch (Exception ex)
{
throw ex;
}
}
public static List<Intership> GetAll()
{
dbContext = new TeachinVietnamDataContext();
var allIntership = dbContext.tbl_Interships.Where(x => x.active == true).OrderByDescending(x => x.createdDate);
List<Intership> ilist = new List<Intership>();
foreach (var i in allIntership)
{
Intership _intership = new Intership();
_intership.id = i.id;
_intership.articleName = i.articleName;
_intership.articleIntroduction = i.articleIntroduction.Replace(Environment.NewLine, "<br />");
_intership.articleContent = i.articleContent.Replace(Environment.NewLine, "<br />");
_intership.active = (bool)i.active;
_intership.createdDate = (DateTime)i.createdDate;
_intership.enableFreeGuide = i.EnableFreeGuide != null ? (bool)i.EnableFreeGuide : false;
_intership.enableApplyOnline = i.EnableApplyOnline != null ? (bool)i.EnableApplyOnline : false;
ilist.Add(_intership);
}
return ilist;
}
public static void UpdateLogo(int _id, int _displayOrder, bool _active)
{
try
{
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
dbContext.proc_feature_logo_update(_id, _active,_displayOrder);
}
catch (Exception e)
{
throw e;
}
}
public CourseBusinessFacade()
{
dbContext = new TeachinVietnamDataContext();
}
public static void DeleteAIntershipArticle(int id)
{
try
{
dbContext = new TeachinVietnamDataContext();
dbContext.proc_deleteAIntershipArticle(id);
}
catch (Exception e)
{
throw e;
}
}
public InternshipGuide()
{
dbContext = new TeachinVietnamDataContext();
}
public InternshipUserSubmit()
{
dbContext = new TeachinVietnamDataContext();
}
public static void InsertNewCourse(string _guid, string _certificate, string _length, string _timetable, string _cost, string _entry, string _contact, string _content, string _benefit)
{
try
{
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
Guid guid = new Guid(_guid);
//dbContext.proc_InsertTrainingCourse(guid, _certificate, _length, _timetable, _cost, _entry, _contact, _content, _benefit,true);
dbContext.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public static void UpdateArticle(int _id, int _parentId, string _title, string _mainContent, bool _displayOnMenu, int _displayOrder, bool _active)
{
try
{
dbContext = new TeachinVietnamDataContext();
dbContext.proc_service_article_updateArticleById(_id, _parentId, _title, _mainContent, _displayOnMenu, _displayOrder, _active);
}
catch (Exception e)
{
throw e;
}
}
public static List<ServiceArticle> GetAll()
{
dbContext = new TeachinVietnamDataContext();
var allArticles = dbContext.tbl_service_articles.Where(x => x.active == true).OrderByDescending(x => x.displayOrder).ThenByDescending(x => x.createdDate).ToList();
List<ServiceArticle> saList = new List<ServiceArticle>();
foreach (var article in allArticles)
{
ServiceArticle sa = new ServiceArticle();
sa.id = article.id;
sa.parentId = Convert.ToInt32(article.parentId);
sa.title = article.title;
sa.mainContent = article.maincontent.Replace(Environment.NewLine, "<br />");
sa.createdDate = (DateTime)article.createdDate;
sa.displayOnMenu = (bool)article.displayOnMenu;
sa.DisplayOrder = Convert.ToInt32(article.displayOrder);
sa.active = (bool)article.active;
saList.Add(sa);
}
return saList;
}
public static bool hasParentNotRoot(int _id)
{
bool hasParent = false;
dbContext = new TeachinVietnamDataContext();
if (dbContext.proc_service_article_hasParentNotRoot(_id).Count() > 0)
{
hasParent = true;
}
return hasParent;
}
public static List<ServiceArticle> GetSubArticlesById(int _id)
{
dbContext = new TeachinVietnamDataContext();
var list = dbContext.proc_service_article_GetSubArtiles(_id);
List<ServiceArticle> saList = new List<ServiceArticle>();
foreach (var article in list)
{
ServiceArticle sa = new ServiceArticle();
sa.id = article.id;
sa.parentId = Convert.ToInt32(article.parentId);
sa.title = article.title;
sa.mainContent = article.maincontent.Replace(Environment.NewLine, "<br />");
sa.createdDate = (DateTime)article.createdDate;
sa.displayOnMenu = (bool)article.displayOnMenu;
sa.DisplayOrder = Convert.ToInt32(article.displayOrder);
sa.active = (bool)article.active;
saList.Add(sa);
}
return saList;
}
public static ServiceArticle GetArticleById(int id)
{
dbContext = new TeachinVietnamDataContext();
proc_service_article_getArticleByIdResult article = dbContext.proc_service_article_getArticleById(id).FirstOrDefault();
if (article != null)
{
ServiceArticle sa = new ServiceArticle();
sa.id = article.id;
sa.parentId = Convert.ToInt32(article.parentId);
sa.title = article.title;
sa.mainContent = article.maincontent.Replace(Environment.NewLine, "<br />");
sa.createdDate = (DateTime)article.createdDate;
sa.DisplayOrder =Convert.ToInt32(article.displayOrder);
sa.displayOnMenu = (bool)article.displayOnMenu;
sa.active = (bool)article.active;
return sa;
}
return null;
}
public static List<KeyValuePair<int, string>> GetAllIdAndTitle()
{
dbContext = new TeachinVietnamDataContext();
List<KeyValuePair<int, string>> allArticles = dbContext.tbl_service_articles.Where(x => x.active == true).Select(x => new KeyValuePair<int, string>(x.id, x.title)).ToList();
return allArticles;
}
public static void Insert(string title, string firstname,string lastname,string email,string country,string phone)
{
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
dbContext.proc_Internship_Guide_Insert(title,firstname,lastname, email, country, phone);
}
public static void InsertNewLogo(string _username, int _displayOrder)
{
try
{
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
dbContext.proc_feature_logo_insert(_username, _displayOrder);
}
catch (Exception e)
{
throw e;
}
}
public static Intership getIntershipById(int id, bool selectAll = false)
{
dbContext = new TeachinVietnamDataContext();
BusinessLogic.proc_getIntershipByIdResult i = null;
if (selectAll == false)
{
i = dbContext.proc_getIntershipById(id).Where(x => x.active == true).FirstOrDefault();
}
else
{
i = dbContext.proc_getIntershipById(id).FirstOrDefault();
}
if (i != null)
{
Intership _intership = new Intership();
_intership.id = i.id;
_intership.articleName = i.articleName;
_intership.articleIntroduction = i.articleIntroduction.Replace(Environment.NewLine, "<br />");
_intership.articleContent = i.articleContent.Replace(Environment.NewLine, "<br />");
_intership.active = (bool)i.active;
_intership.createdDate = (DateTime)i.createdDate;
_intership.enableFreeGuide = i.EnableFreeGuide != null ? (bool)i.EnableFreeGuide : false;
_intership.enableApplyOnline = i.EnableApplyOnline != null ? (bool)i.EnableApplyOnline : false;
return _intership;
}
return null;
}
public static List<TrainingCourse> SearchCourses(string _courseName,string _cateId,string _levelId,string _locationId)
{
try
{
int? cId=0;
//int? cId = Convert.ToInt16(_cateId);
//int? leId = Convert.ToInt16(_levelId);
//int? loId = Convert.ToInt16(_locationId);
short cIdd;
if (Int16.TryParse(_cateId, out cIdd))
{
cId = cIdd;
}
List<TrainingCourse> tcList = new List<TrainingCourse>();
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
var allTrainingCourseList = from tc in dbContext.tbl_TrainingCourses
where tc.tc_active == true &&
tc.tc_name.Contains(_courseName) &&
tc.tc_category==cId //&&
//tc.tc_location==loId &&
//tc.tc_certificate==leId
select tc;
foreach (var c in allTrainingCourseList)
{
TrainingCourse tc = new TrainingCourse();
tc.Id = c.tc_id.ToString();
tc.Guid = c.tc_empId.ToString();
tc.Name = c.tc_name;
tc.Certificate = (int)c.tc_certificate;
tc.Category = (int)c.tc_category;
tc.Location = (int)c.tc_location;
tc.Length = c.tc_length;
tc.Timetable = c.tc_timetable;
tc.Cost = c.tc_cost;
tc.Entry = c.tc_entryRequirement;
tc.Contact = c.tc_contact;
tc.Coursecontent = c.tc_courseContent;
tc.Benefit = c.tc_teacherBenefit;
tc.ViewCount = (int)c.tc_viewCount;
tcList.Add(tc);
}
return tcList;
}
catch (Exception ex)
{
throw ex;
}
}
public static void Insert(string title, string introduction, string body, bool isActive, bool enableFreeGuide, bool enableApplyOnline)
{
try
{
//dbContext = new TeachinVietnamDataContext();
//string insertCommand = string.Format("EXEC [dbo].[proc_insertIntership] N'{0}',N'{1}',N'{2}',{3},{4},{5}", title, introduction, body, isActive == true ? "1" : "0", enableFreeGuide == true ? "1" : "0", enableApplyOnline == true ? "1" : "0");
//dbContext.ExecuteCommand(insertCommand);
dbContext = new TeachinVietnamDataContext();
var result = dbContext.proc_insertIntership(title, introduction, body, isActive, enableFreeGuide, enableApplyOnline);
}
catch (Exception e)
{
throw e;
}
}
public static void UpdateIntership(int id, string title, string intro, string body, bool active, bool enableFreeGuide, bool enableApplyOnline)
{
dbContext = new TeachinVietnamDataContext();
var result = dbContext.proc_UpdateInternship(id, title, intro, body, active, enableFreeGuide, enableApplyOnline);
}
public Intership()
{
dbContext = new TeachinVietnamDataContext();
}
public static void Insert(string title, string firstname, string lastname, string email, string country, string phone, string whenshouldwecall,string fullPath)
{
TeachinVietnamDataContext dbContext = new TeachinVietnamDataContext();
dbContext.proc_Internship_UserSubmit_Insert(title, firstname, lastname, email, country, phone, whenshouldwecall, fullPath);
}
public TrainingCourse()
{
dbContext = new TeachinVietnamDataContext();
}
