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