private List <ContactUSList> ProductData() { List <ContactUSList> objContactUsList = new List <ContactUSList>(); CSDBEntities objCSDBEntities = new CSDBEntities(); var ContactUsItem = (from data in objCSDBEntities.vw_ContactUs select data).ToList(); //objContactUsList=new List<ContactUSList>(ContactUsItem); //List<ContactUSList> objContactUsList1 = new List<ContactUSList>(ContactUsItem); //List<MyType> copy = new List<MyType>(original); //objContactUsList = (from data in objCSDBEntities.vw_ContactUs // select data).ToList(); foreach (var item in ContactUsItem) { objContactUsList.Add(new ContactUSList { Id = item.Id, Name = item.Name, Email = item.Email, MobileNo = item.MobileNo, BusinessWebsite = item.BusinessWebsite, Subject = item.Subject, BusinessMessage = item.BusinessMessage, hasReplied = item.hasReplied, ReplySentOn = Convert.ToString(item.ReplySentOn), CreatedBy = item.CreatedBy, CreatedOn = item.CreatedOn, UpdatedBy = item.UpdatedBy, UpdatedOn = Convert.ToString(item.UpdatedOn) }); } return(objContactUsList); }
public cs_news Get(int NewsID) { using (CSDBEntities objDB = new CSDBEntities()) { var objNews = objDB.cs_news.Where(n => n.news_id == NewsID).FirstOrDefault(); return(objNews); } }
//[HttpGet] //public ActionResult BusinessQuery() //{ // return View(); //} public ActionResult ContactUsQuery() { objBusinessContactUsReplyModel = new BusinessContactUsReplyModel(); objCSDBEntities = new CSDBEntities(); var ContactUsItem = (from data in objCSDBEntities.vw_ContactUs select data).ToList(); ViewBag.ContactUsList = ContactUsItem; //objBusinessContactUsReplyModel.objContactUsList = ProductData(); //return View(objBusinessContactUsReplyModel); return(View()); }
public bool AddContactUs(ContactUsModel objContactUsModel) { try { CSDBEntities objCSDBEntities = new CSDBEntities(); tbl_ContactUS objtblContactUS = new tbl_ContactUS(); objtblContactUS.Name = objContactUsModel.Name; objtblContactUS.MobileNo = objContactUsModel.MobileNo; objtblContactUS.Email = objContactUsModel.Email; objtblContactUS.BusinessWebsite = objContactUsModel.BusinessWebsite; objtblContactUS.Subject = objContactUsModel.Subject; objtblContactUS.BusinessMessage = objContactUsModel.BusinessMessage; objCSDBEntities.tbl_ContactUS.Add(objtblContactUS); objCSDBEntities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } finally { } }
public List <vw_ContactUs> getContactUsDetailByID(Int64 ContactUsID) { List <vw_ContactUs> objvw_ContactUsList = new List <vw_ContactUs>(); try { objCSDBEntities = new CSDBEntities(); objvw_ContactUsList = (from Data in objCSDBEntities.vw_ContactUs where Data.Id == ContactUsID select Data).ToList(); //dtRecord= tmpRecord.to return(objvw_ContactUsList); } catch (Exception ex) { throw ex; } finally { objvw_ContactUsList = null; objCSDBEntities = null; } }
private List <NewsList> GetNewsList(NewsListCondition objCondition) { using (CSDBEntities objDB = new CSDBEntities()) { var sqlNews1 = objDB.cs_news.Where(n => n.enabled == "Y" && n.begin_date <= DateTime.Now && n.top_news == "Y") .Select(n => new NewsList { news_id = n.news_id, title = n.title, content = n.content, begin_date = n.begin_date, end_date = n.end_date, top_news = n.top_news, kind = n.news_kind }).AsEnumerable(); var sqlNews2 = objDB.cs_news.Where(n => n.enabled == "Y" && n.begin_date <= DateTime.Now && n.top_news != "Y") .Select(n => new NewsList { news_id = n.news_id, title = n.title, content = n.content, begin_date = n.begin_date, end_date = n.end_date, top_news = n.top_news, kind = n.news_kind }).AsEnumerable(); if (objCondition != null) { if (String.IsNullOrEmpty(objCondition.search_title) == false) { sqlNews1 = sqlNews1.Where(n => n.title.Contains(objCondition.search_title)); sqlNews2 = sqlNews2.Where(n => n.title.Contains(objCondition.search_title)); } if (String.IsNullOrEmpty(objCondition.searc_content) == false) { sqlNews1 = sqlNews1.Where(n => n.content.Contains(objCondition.searc_content)); sqlNews2 = sqlNews2.Where(n => n.content.Contains(objCondition.searc_content)); } if (String.IsNullOrEmpty(objCondition.search_date) == false) { DateTime dteSearch; if (DateTime.TryParse(objCondition.search_date, out dteSearch)) { sqlNews1 = sqlNews1.Where(n => DateTime.Compare(dteSearch, n.begin_date) >= 0 && (n.end_date is null || DateTime.Compare((DateTime)n.end_date, dteSearch) >= 0)); sqlNews2 = sqlNews2.Where(n => DateTime.Compare(dteSearch, n.begin_date) >= 0 && (n.end_date is null || DateTime.Compare((DateTime)n.end_date, dteSearch) >= 0)); } } if (String.IsNullOrEmpty(objCondition.search_kind) == false) { sqlNews1 = sqlNews1.Where(n => n.kind == objCondition.search_kind); sqlNews2 = sqlNews2.Where(n => n.kind == objCondition.search_kind); } } var lstNews = sqlNews1.Concat(sqlNews2).ToList(); lstNews.ForEach( n => { if (n.top_news == "Y") { n.top_news = "v"; } else { n.top_news = ""; } n.begin_end_date = n.begin_date.ToString("yyyy/MM/dd"); if (n.end_date != null) { n.begin_end_date += " ~ " + n.end_date.Value.ToString("yyyy/MM/dd"); } } ); return(lstNews); } }
public List <QuestionList> Get(string SearchStatus, string SearchDateBegin, string SearchDateEnd, string SearchTitle) { using (CSDBEntities objDB = new CSDBEntities()) { var sqlQuestion = objDB.cs_question.AsQueryable(); if (String.IsNullOrEmpty(SearchStatus) == false) { sqlQuestion = sqlQuestion.Where(q => q.q_status == SearchStatus); } if (String.IsNullOrEmpty(SearchDateBegin) == false) { DateTime dteSearch; if (DateTime.TryParse(SearchDateBegin, out dteSearch)) { sqlQuestion = sqlQuestion.Where(q => DateTime.Compare(dteSearch, q.apply_date) <= 0); } } if (String.IsNullOrEmpty(SearchDateEnd) == false) { DateTime dteSearch; if (DateTime.TryParse(SearchDateEnd, out dteSearch)) { sqlQuestion = sqlQuestion.Where(q => DateTime.Compare(dteSearch, q.apply_date) >= 0); } } if (String.IsNullOrEmpty(SearchTitle) == false) { sqlQuestion = sqlQuestion.Where(q => q.q_title.Contains(SearchTitle)); } List <QuestionList> lstQuestion; lstQuestion = (from q in sqlQuestion from pk in objDB.cs_code_kind.Where(k => k.kind == "Q_PRIORITY").DefaultIfEmpty() from pc in objDB.cs_code.Where(c => c.kind == pk.kind && c.enabled == "Y" && c.code == q.q_priority).DefaultIfEmpty() from kk in objDB.cs_code_kind.Where(k => k.kind == "Q_KIND").DefaultIfEmpty() from kc in objDB.cs_code.Where(c => c.kind == kk.kind && c.enabled == "Y" && c.code == q.q_kind).DefaultIfEmpty() from sk in objDB.cs_code_kind.Where(k => k.kind == "Q_STATUS").DefaultIfEmpty() from sc in objDB.cs_code.Where(c => c.kind == sk.kind && c.enabled == "Y" && c.code == q.q_status).DefaultIfEmpty() select new QuestionList() { q_code = q.q_code, q_priority_desc = pc.description, q_kind_desc = kc.description, q_title = q.q_title, q_content = q.q_content, q_status_desc = sc.description, apply_date = q.apply_date, }).ToList(); lstQuestion.ForEach( q => { q.apply_date_desc = q.apply_date.ToString("yyyy/MM/dd"); }); return(lstQuestion); } }