public EnquireUserViewModel GetEnquireUser(string modules, string loginId, string user_group) { loginId = loginId.Replace("\\", "/").ToLower(); DataSet ds = new DataSet(); EnquireUserViewModel user = new EnquireUserViewModel(); user.AdminUserInfo = new UserInfo(); var sql = "select login_id, user_name, password, pwd_expiry, inst_code, "; sql = sql + " domain_user, isnull(convert(char(12), last_login, 106) + convert(char(5), last_login, 108), '-') last_login "; sql = sql + " from user_info where login_id = '" + loginId + "'"; using (SqlConnection sqlConn = new SqlConnection(Context.Database.GetDbConnection().ConnectionString)) { using (SqlCommand sqlCmd = new SqlCommand(sql, sqlConn)) { SqlDataAdapter adp = new SqlDataAdapter(sqlCmd); adp.Fill(ds); if (ds != null && ds.Tables.Count != 0 && ds.Tables[0].Rows.Count > 0) { user.AdminUserInfo.LoginId = ds.Tables[0].Rows[0][0].ToString(); user.AdminUserInfo.UserName = ds.Tables[0].Rows[0][1].ToString().Trim() ?? ""; user.AdminUserInfo.Password = ds.Tables[0].Rows[0][2].ToString().Trim() ?? ""; user.AdminUserInfo.PwdExpiry = ds.Tables[0].Rows[0][3].ToString().Trim() ?? "N"; user.AdminUserInfo.InstCode = ds.Tables[0].Rows[0][4].ToString().Trim() ?? ""; user.AdminUserInfo.DomainUser = ds.Tables[0].Rows[0][5].ToString().Trim() ?? "Y"; user.LastLogin_string = ds.Tables[0].Rows[0][6].ToString().Trim() ?? ""; AccessRightD rightD = AccessRightDRepository.GetAccessRightD(loginId); AccessRightM rightM = AccessRightMRepository.GetAccessRightM(loginId); AccessRightY rightY = AccessRightYRepository.GetAccessRightY(loginId); switch (modules) { case "D": user.AdminUserInfo.UserGroup = rightD.UserGroup ?? user_group; user.AdminRightD = rightD; break; case "M": user.AdminUserInfo.UserGroup = rightM.UserGroup ?? user_group; user.AdminRightM = rightM; break; case "Y": user.AdminUserInfo.UserGroup = rightY.UserGroup ?? user_group; user.AdminRightY = rightY; break; } } } } return(user); }
public string GetPrivilage(string access_type, string admin_login_id, string privilage_default) { string privilage = privilage_default; var recordD = AccessRightDRepository.GetAccessRightD(admin_login_id); var recordM = AccessRightMRepository.GetAccessRightM(admin_login_id); var recordY = AccessRightYRepository.GetAccessRightY(admin_login_id); switch (access_type) { case "admin_D": privilage = recordD.AdminD; break; case "admin_M": privilage = recordM.AdminM; break; case "admin_Y": privilage = recordY.AdminY; break; case "asoi_input": privilage = recordY.AsoiInput; break; case "asoi_rpt_D": privilage = recordD.AsoiRpt; break; case "asoi_rpt_M": privilage = recordM.AsoiRpt; break; case "asoi_rpt_Y": privilage = recordY.AsoiRpt; break; case "cbv": privilage = recordM.Cbv; break; case "cbv_funding": privilage = recordM.CbvFunding; break; case "cbv_ori_update": privilage = recordM.CbvOriUpdate; break; case "closing_Y": privilage = recordY.Closing; break; case "cluster_admin_M": privilage = recordM.ClusterAdminM; break; case "cwrf": privilage = recordM.Cwrf; break; case "cwrf_hpd": privilage = recordM.CwrfHpd; break; case "cwrf_cwd": privilage = recordM.CwrfCwd; break; case "cwrf_funding": privilage = recordM.CwrfFunding; break; case "cwrf_ho": privilage = recordM.CwrfHo; break; case "cwrf_status": privilage = recordM.CwrfStatus; break; case "cwrf_submenu": privilage = recordM.CwrfSubmenu; break; case "donation": privilage = recordD.Donation; break; case "far_access": privilage = recordY.FarAccess; break; case "fv_input": privilage = recordY.FvInput; break; case "fv_cluster": privilage = recordY.FvCluster; break; case "fv_user_admin": privilage = recordY.FvUserAdmin; break; case "report_D": privilage = recordD.ReportD; break; case "report_M": privilage = recordM.ReportM; break; case "report_Y": privilage = recordY.ReportY; break; } return(privilage); }