public JsonResult searchDept(string dept, string sdept, string iclass, string siclass) { var xList = new List <DeptModel>(); var opObj = new RequesVal() { dept = dept, sdept = sdept, iclass = iclass, siclass = siclass }; if (string.IsNullOrEmpty(dept) && string.IsNullOrEmpty(sdept) && string.IsNullOrEmpty(iclass) && string.IsNullOrEmpty(siclass)) { xList = Srch(1, 1, opObj); } else if (!string.IsNullOrEmpty(dept) && string.IsNullOrEmpty(sdept) && string.IsNullOrEmpty(iclass) && string.IsNullOrEmpty(siclass)) { xList = Srch(3, 2, opObj); } else if (!string.IsNullOrEmpty(dept) && !string.IsNullOrEmpty(sdept) && string.IsNullOrEmpty(iclass) && string.IsNullOrEmpty(siclass)) { xList = Srch(2, 3, opObj); } else if (!string.IsNullOrEmpty(dept) && !string.IsNullOrEmpty(sdept) && !string.IsNullOrEmpty(iclass) && string.IsNullOrEmpty(siclass)) { xList = Srch(3, 4, opObj); } return(Json(xList, JsonRequestBehavior.AllowGet)); }
private List <DeptModel> Srch(int codee, int chkr, RequesVal objj) { var currentUser = User.Identity.Name.Substring(0, 6); var xList = new List <DeptModel>(); var cbt = 0; string csvHandlerLine = ""; string[] csvHandler; var obj = new DeptModel() { }; using (StreamReader CsvReader = new StreamReader(Server.MapPath("~/CSV/Dept_List.csv"))) { string inputLine = ""; while ((inputLine = CsvReader.ReadLine()) != null) { cbt++; if (cbt != 1) { csvHandlerLine = inputLine.Trim().Replace(" ", ""); char[] delimiterChars = { '\"', ',' }; csvHandler = csvHandlerLine.Split(delimiterChars); if (chkr.Equals(1)) // Department { if (csvHandler[0].Equals(currentUser)) { obj = new DeptModel() { Code = csvHandler[codee].ToString(), Name = csvHandler[2].ToString() }; if (!xList.Any(s => s.Code.Equals(obj.Code))) { xList.Add(obj); } } } else if (chkr.Equals(2)) // Sub-Department { if (csvHandler[0].Equals(currentUser) && csvHandler[1].Equals(objj.dept) && !csvHandler[3].Equals(0)) { obj = new DeptModel() { Code = csvHandler[3].ToString(), Name = csvHandler[4].ToString() }; if (!xList.Any(s => s.Code.Equals(obj.Code))) { xList.Add(obj); } } } else if (chkr.Equals(3)) // Class { if (csvHandler[0].Equals(currentUser) && csvHandler[1].Equals(objj.dept) && csvHandler[3].Equals(objj.sdept) && !csvHandler[5].Equals(0)) { obj = new DeptModel() { Code = csvHandler[5].ToString(), Name = csvHandler[6].ToString() }; if (!xList.Any(s => s.Code.Equals(obj.Code))) { xList.Add(obj); } } } else if (chkr.Equals(4)) // Sub-Class { if (csvHandler[0].Equals(currentUser) && csvHandler[1].Equals(objj.dept) && csvHandler[3].Equals(objj.sdept) && csvHandler[5].Equals(objj.iclass) && !csvHandler[7].Equals(0)) { obj = new DeptModel() { Code = csvHandler[7].ToString(), Name = csvHandler[8].ToString() }; if (!xList.Any(s => s.Code.Equals(obj.Code))) { xList.Add(obj); } } } } } CsvReader.Close(); } return(xList); }