static public int AuthenticateAdv(int UserId, int AdvanceId, int PortalId) { StaffRmbDataContext d = new StaffRmbDataContext(); var adv = from c in d.AP_Staff_AdvanceRequests where c.AdvanceId == AdvanceId && c.PortalId == PortalId select c; if (adv.Count() > 0) { if (adv.First().UserId == UserId) { return(RmbAccess.Owner); } else if (adv.First().ApproverId == UserId) { return(RmbAccess.Approver); } else { var spouseId = StaffBrokerFunctions.GetSpouseId(UserId); if (adv.First().UserId == spouseId) { return(RmbAccess.Spouse); } else { var team = from c in StaffBrokerFunctions.GetTeam(UserId) select c.UserID; if (team.Contains((int)(adv.First().UserId))) { return(RmbAccess.Approver); } } } } return(RmbAccess.Denied); }
static public int GetNewAdvId(int PortalId) { string NextAdvID = StaffBrokerFunctions.GetSetting("NextAdvID", PortalId); if (NextAdvID == "") { StaffRmbDataContext d = new StaffRmbDataContext(); var MaxAdvID = (from c in d.AP_Staff_AdvanceRequests where c.PortalId == PortalId select c.LocalAdvanceId); if (MaxAdvID.Count() == 0) { StaffBrokerFunctions.SetSetting("NextAdvID", "2", PortalId); return(1); } else { StaffBrokerFunctions.SetSetting("NextAdvID", (MaxAdvID.Max() + 1).ToString(), PortalId); return((int)MaxAdvID.First()); } } else { StaffBrokerFunctions.SetSetting("NextAdvID", (Convert.ToInt32(NextAdvID) + 1).ToString(), PortalId); return(Convert.ToInt32(NextAdvID)); } }
static public int Authenticate(int UserId, int RmbNo, int PortalId) { StaffRmbDataContext d = new StaffRmbDataContext(); var rmb = from c in d.AP_Staff_Rmbs where c.RMBNo == RmbNo && c.PortalId == PortalId select c; if (rmb.Count() > 0) { if (rmb.First().UserId == UserId) { return(RmbAccess.Owner); } else if (rmb.First().ApprUserId == UserId) { return(RmbAccess.Approver); } else { var spouseId = StaffBrokerFunctions.GetSpouseId(UserId); if (rmb.First().UserId == spouseId) { return(RmbAccess.Spouse); } else { var team = from c in StaffBrokerFunctions.GetTeam(UserId) select c.UserID; string pcc = StaffBrokerFunctions.GetStaffMember(UserId).CostCenter; if (rmb.First().CostCenter == pcc) { if (team.Contains(rmb.First().UserId)) { return(RmbAccess.Approver); } } else { var depts = from c in StaffBrokerFunctions.GetDepartments(UserId) select c.CostCentre; if (depts.Contains(rmb.First().CostCenter)) { return(RmbAccess.Approver); } else if (team.Contains(rmb.First().UserId)) { return(RmbAccess.Leader); } } } } } return(RmbAccess.Denied); }