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