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