/// Function Header*******************************************************
/// Function Name: InesrtSectionVisitedDetails
/// Function Type: Function
/// Functionality: used to insert the section visited details
/// Input:
/// Output:
/// Return Value:
/// Note:
/// *********************************************************************
public void InesrtSectionVisitedDetails(Entity.UserInfo oUserInfo)
{
using (TLWDALDataContext _db = new TLWDALDataContext())
{
bool blnIsExists = false;
var _varSectionVisited = (from _sv in _db.SectionVisiteds
orderby _sv.dtCreatedOn descending
select _sv
).ToList().Take(1);
if (_varSectionVisited != null)
{
if (_varSectionVisited.ElementAt(0).strSectionVisited.ToLower().Equals(oUserInfo.StrSectionVisited.ToLower())
&&
_varSectionVisited.ElementAt(0).strUserId.ToLower().Equals(oUserInfo.StrUserId.ToLower()))
{
blnIsExists = true;
}
}
if (!blnIsExists)
{
DAL.SectionVisited oSectionVisited = new SectionVisited();
oSectionVisited.strUserId = oUserInfo.StrUserId;
oSectionVisited.strUserType = oUserInfo.StrUserType;
oSectionVisited.dtCreatedOn = oUserInfo.DtCreatedOn;
oSectionVisited.strAgent = oUserInfo.StrAgent;
oSectionVisited.strVisitedIP = oUserInfo.StrVisitedIP;
oSectionVisited.strSectionVisited = oUserInfo.StrSectionVisited;
_db.SectionVisiteds.InsertOnSubmit(oSectionVisited);
_db.SubmitChanges();
oSectionVisited = null;
}
}
}
/// Function Header*******************************************************
/// Function Name: InesrtSectionVisitedDetails
/// Function Type: Function
/// Functionality: used to insert the section visited details
/// Input:
/// Output:
/// Return Value:
/// Note:
/// *********************************************************************
public List<Entity.UserInfo> GetSectionVisitedDetails(Entity.UserInfo oUserInfo)
{
using (TLWDALDataContext _db = new TLWDALDataContext())
{
DAL.SectionVisited oSectionVisited = new SectionVisited();
var _varSectionVisited = (from _sv in _db.SectionVisiteds
where _sv.dtCreatedOn >= Convert.ToDateTime(oUserInfo.StrDateFrom)
&& _sv.dtCreatedOn <= Convert.ToDateTime(oUserInfo.StrDateTo)
orderby _sv.dtCreatedOn descending
select new Entity.UserInfo
{
IntSectionVisitedId = _sv.intSectionVisitedId,
StrUserId = _sv.strUserId,
StrUserType = _sv.strUserType.Equals("A") ? "Administrator" : _sv.strUserType.Equals("U") ? "User" : "Company",
DtCreatedOn = _sv.dtCreatedOn,
StrAgent = _sv.strAgent,
StrVisitedIP = _sv.strVisitedIP,
StrSectionVisited = _sv.strSectionVisited
}).ToList();
if (!oUserInfo.StrUserType.ToLower().Equals("x"))
_varSectionVisited = _varSectionVisited.Where(x => x.StrUserType.ToLower().Equals(oUserInfo.StrUserType.ToLower())).ToList();
if (!oUserInfo.StrSectionVisited.Equals(string.Empty))
_varSectionVisited = _varSectionVisited.Where(x => x.StrSectionVisited.ToLower().Contains(oUserInfo.StrSectionVisited.ToLower())).ToList();
return _varSectionVisited;
}
}