public IQueryable <Resources> GetByMasterCode(int MasterCode)
{
AccessLevelDataContext dataContext = new AccessLevelDataContext();
var Result = from p in dataContext.Resources
where p.MasterCode.Equals(MasterCode)
select p;
return(Result);
}
public DataTable GetNodeData(int NodeValue)
{
AccessLevelDataContext dataContext = new AccessLevelDataContext();
//string WhereCond = Tools.GetCondition(sFilterCols);
var ListResult = from v in dataContext.Resources
where v.MasterCode.Equals(NodeValue)
select v;
DataTable dt = new Converter <Resources>().ToDataTable(ListResult);
return(dt);
}
public DataTable GetGroupNameByUserCode(int userCode)
{
AccessLevelDataContext dc = new AccessLevelDataContext();
var ListResult = from p in dc.vUserGroups
where p.UserCode.Equals(userCode)
select p;
DataTable dt = new Converter <vUserGroups>().ToDataTable(ListResult);
return(dt);
}
DataTable IBaseBOL.GetDataSource(SearchFilterCollection sFilterCols, string SortString, int PageSize, int CurrentPage)
{
dataContext = new AccessLevelDataContext();
string WhereCond = Tools.GetCondition(sFilterCols);
var ListResult = from v in dataContext.Resources
where !v.MasterCode.HasValue //|| v.TypeCode.Equals(2) || v.TypeCode.Equals(3) || v.TypeCode.Equals(4)
select v;
DataTable dt = new Converter <Resources>().ToDataTable(ListResult);
return(dt);
}
public DataTable GetAllFieldExcpetFields()
{
AccessLevelDataContext dataContext = new AccessLevelDataContext();
DataTable dt = new DataTable();
var ListResult = from r in dataContext.Resources
where (!r.TypeCode.Equals(3))
select r;
dt = new Converter <Resources>().ToDataTable(ListResult);
return(dt);
}
public void GetAccess(int AccessType, int GroupCode, int MasterCode)
{
int ResourceCode;
AccessLevelDataContext dataContext = new AccessLevelDataContext();
var Result = dataContext.sp_GetMultipleAccess(AccessType, GroupCode, MasterCode);
var ListResult = dataContext.ExecuteQuery <GroupResources>(string.Format("exec sp_GetMultipleAccess '{0}','{1}','{2}'", AccessType, GroupCode, MasterCode));
foreach (var r in ListResult)
{
ResourceCode = (int)((GroupResources)r).ResourceCode;
GetAccess(AccessType, GroupCode, ResourceCode);
}
}
internal int GetBalanace(int UserCode)
{
AccessLevelDataContext dataContext = new AccessLevelDataContext();
int?Balance = dataContext.fnGetUserBalance(UserCode);
if (Balance != null)
{
return((int)Balance);
}
else
{
return(0);
}
}
public int?GetCodeByEngName(string EngName)
{
AccessLevelDataContext dataContext = new AccessLevelDataContext();
var Result = dataContext.Resources.SingleOrDefault(p => p.EngName.Equals(EngName));
if (Result == null)
{
return(null);
}
else
{
return(Result.Code);
}
}
public DataTable GetValidAccess(List <AccessListStruct> AccessList, SearchFilterCollection sFilterCols, string SortString, int PageSize, int CurrentPage)
{
DataTable dt = new DataTable();
AccessLevelDataContext dataContext = new AccessLevelDataContext();
string WhereCond = Tools.GetCondition(sFilterCols);
if (HttpContext.Current.Session["UserCode"] != null)
{
//AccessListStruct s=new AccessListStruct("Edit",
ArrayList EditAccess = new ArrayList();
ArrayList ViewAccess = new ArrayList();
for (int i = 0; i < AccessList.Count; i++)
{
if (AccessList[i].AccessName == "EDIT")
{
EditAccess.Add(AccessList[i].FieldName);
}
else if (AccessList[i].AccessName == "VIEW")
{
ViewAccess.Add(AccessList[i].FieldName);
}
}
//string[] EditAccess = HttpContext.Current.Session["Edit"].ToString().Split(',');
//string[] ViewAccess = HttpContext.Current.Session["View"].ToString().Split(',');
string[] arrEditAccess = (string[])EditAccess.ToArray(typeof(string));
string[] arrViewAccess = (string[])ViewAccess.ToArray(typeof(string));
System.Collections.Generic.IEnumerable <String> AllAccess = arrEditAccess.Union(arrViewAccess);
if (AllAccess.Count <string>() > 0)
{
var ListResult = from v in dataContext.Resources
where (v.HCResourceTypeCode.Equals(1) || v.HCResourceTypeCode.Equals(2)) &&
(AllAccess.Contains(v.ResName))
select v;
dt = new Converter <Resources>().ToDataTable(ListResult);
}
}
return(dt);
}
public BaseBOLGuestUserBuys()
{
dataContext = new AccessLevelDataContext();
}
public BaseBOLUserADSs()
{
dataContext = new AccessLevelDataContext();
}
public BaseBOLLoggedUserBuys()
{
dataContext = new AccessLevelDataContext();
}
public BaseBOLGroupResources(params int[] MCodes)
{
MasterCode = Convert.ToInt32(MCodes[0]);
dataContext = new AccessLevelDataContext();
}
public BaseBOLUserTransactions(params int[] MCodes)
{
MasterCode = Convert.ToInt32(MCodes[0]);
dataContext = new AccessLevelDataContext();
}
public BaseBOLAccessGroups()
{
dataContext = new AccessLevelDataContext();
}
public BaseBOLUserGroups(params int[] MCodes)
{
MasterCode = Convert.ToInt32(MCodes[0]);
dataContext = new AccessLevelDataContext();
BaseID = this.ToString().Substring(3, this.ToString().Length - 3);
}
public BaseBOLUserBuyProducts(params int[] MCodes)
{
MasterCode = Convert.ToInt32(MCodes[0]);
dataContext = new AccessLevelDataContext();
}
public BaseBOLResources()
{
dataContext = new AccessLevelDataContext();
}
public BaseBOLForgotPasswords(params int[] MCodes)
{
MasterCode = Convert.ToInt32(MCodes[0]);
dataContext = new AccessLevelDataContext();
}
public GroupResources GetByGroupandResourceCode(int GroupCode, int ResourceCode)
{
AccessLevelDataContext dataContext = new AccessLevelDataContext();
return(dataContext.GroupResources.SingleOrDefault(p => p.GroupCode.Equals(GroupCode) && p.ResourceCode.Equals(ResourceCode)));
}
