public List <ExcelView> SearchTravelRequestExcel(SearchViewModel Search) { List <ExcelView> ResultListLists = new List <ExcelView>(); int RowNum = 0; try { BVNDataContext Travelconn = new BVNDataContext(); var Projectinfo = (from distinct in Travelconn.Tb_BvnIncidents where ((Search.AccountName == null || distinct.AccountNameArray.Contains(Search.AccountName)) && (Search.AccountNumber == null || distinct.AccountNumberArray.Contains(Search.AccountNumber)) && (Search.StaffName == null || distinct.StaffName.Contains(Search.StaffName)) && (Search.Firstname == null || distinct.Firstname.Contains(Search.Firstname)) && (Search.LastName == null || distinct.LastName.Contains(Search.LastName)) && (Search.MiddleName == null || distinct.MiddleName.Contains(Search.MiddleName)) && (Search.BVN == null || distinct.BVN == Search.BVN) && (Search.IsAccountClosed == null || distinct.IsAccountClose == Search.IsAccountClosed) && (Search.StaffNo == null || distinct.StaffNumber == Search.StaffNo) && // (Search.DomicileBranchCode == null || distinct.DomicileBranchCode == Search.DomicileBranchCode) && (Search.BranchCode == null || distinct.StaffBranchCode == Search.BranchCode) && (Search.Irregularity == null || distinct.Irregularity == Search.Irregularity) && (Search.Date_From == null || distinct.DateSubmitted >= Convert.ToDateTime(Search.Date_From) || distinct.DateSubmitted == Convert.ToDateTime(Search.Date_From)) && (Search.Date_To == null || distinct.DateSubmitted <= Convert.ToDateTime(Search.Date_To).AddDays(1))) select new { RequestID = distinct.DocumentID, Irregularity = distinct.Irregularity, IrregularityDetails = distinct.Nature_Of_The_Irregular, DateSubmitted = distinct.DateSubmitted, Staffname = distinct.StaffName, StaffNo = distinct.StaffNumber, InitiatorBranchName = distinct.StaffBranch, JobTitle = distinct.StaffTitle, Email = distinct.Email, AccountNo = distinct.AccountNumberArray, AccountName = distinct.AccountNameArray, AccountStatus = distinct.AccountStatusArray, dateOfBirth = distinct.dateOfBirth, CustomerName = distinct.CustomerNames, FirstName = distinct.Firstname, MiddleName = distinct.MiddleName, LastName = distinct.LastName, Comment = distinct.Comment, DomicileBranch = distinct.DomicileBranch, IsAccountClosed = distinct.IsAccountClose, BVN = distinct.BVN }); foreach (var result_set in Projectinfo) { ExcelView result = new ExcelView(); RowNum = RowNum + 1; result.SN = RowNum; result.AccountName = result_set.AccountName; // result.AccountNumber = result_set.AccountNo; result.BVN = result_set.BVN; result.Firstname = result_set.FirstName; result.LastName = result_set.LastName; result.MiddleName = result_set.MiddleName; result.StaffNo = result_set.StaffNo; result.StaffName = result_set.Staffname; result.JobTitle = result_set.JobTitle; result.Branch = result_set.InitiatorBranchName; result.Email = result_set.Email; result.Account_Closed = (result_set.IsAccountClosed == 1) ? "Yes" : "No"; result.dateOfBirth = (result_set.dateOfBirth == null) ? "" : result_set.dateOfBirth; result.AccountName = (result_set.AccountName == null) ? "" : result_set.AccountName.Replace(";", "<hr>"); result.AccountNumber = (result_set.AccountNo == null) ? "" : result_set.AccountNo.Replace(";", "<hr>"); result.AccountStatus = (result_set.AccountStatus == null) ? "" : result_set.AccountStatus.Replace(";", "<hr>"); result.Comment = result_set.Comment; result.DateSubmitted = result_set.DateSubmitted; result.Irregularity = result_set.Irregularity.Trim(); result.IrregularityDetails = result_set.IrregularityDetails.Trim(); ResultListLists.Add(result); } } catch (Exception ex) { // return ex.Message; } return(ResultListLists); }
public List<InputClass> SearchBranchRequest(string BranchCode) { List<InputClass> RequestList = new List<InputClass>(); try { BVNDataContext projectconn = new BVNDataContext(); var Projectinfo = (from distinct in projectconn.Tb_BvnIncidents where (distinct.StaffBranchCode == int.Parse(BranchCode.ToString())) select new { RequestID = distinct.DocumentID, InitiatorName = distinct.StaffName, AccountName = distinct.AccountName, AccountNumber = distinct.AccountNumber, InitiatorBranch = distinct.StaffBranch, RequestStage = distinct.InputStage, date_Submitted = distinct.DateSubmitted, accountNameArray = distinct.AccountNameArray, accountNumberArray = distinct.AccountNumberArray, accountStatusArrary = distinct.AccountStatusArray, BVN = distinct.BVN }); foreach (var requestList in Projectinfo) { InputClass Myrequest = new InputClass(); Profile profile = new Profile(); Account account = new Account(); profile.StaffName = requestList.InitiatorName; profile.Branch = requestList.InitiatorBranch; account.AccountName = requestList.AccountName; account.AccountNumber = requestList.AccountNumber; account.AccountName = (requestList.accountNameArray == null) ? "" : requestList.accountNameArray.Replace(";", "<BR><hr><BR>"); account.AccountNumber = (requestList.accountNumberArray == null) ? "" : requestList.accountNumberArray.Replace(";", "<BR><hr><BR>"); account.AccountStatus = (requestList.accountStatusArrary == null) ? "" : requestList.accountStatusArrary.Replace(";", "<BR><hr><BR>"); account.BVN = requestList.BVN; Myrequest.RequesterDetails = profile; Myrequest.AccountDetials= account; Myrequest.InputStage = "IC & A Review"; Myrequest.DateSubmitted = requestList.date_Submitted; Myrequest.DocumentID = requestList.RequestID; RequestList.Add(Myrequest); } } catch (Exception ex) { // return ex.Message; } return RequestList; }
public List <InputClass> SearchTravelRequest(SearchViewModel Search) { List <InputClass> ResultListLists = new List <InputClass>(); try { BVNDataContext Travelconn = new BVNDataContext(); var Projectinfo = (from distinct in Travelconn.Tb_BvnIncidents where ((Search.AccountName == null || distinct.AccountNameArray.Contains(Search.AccountName)) && (Search.AccountNumber == null || distinct.AccountNumberArray.Contains(Search.AccountNumber)) && (Search.StaffName == null || distinct.StaffName.Contains(Search.StaffName)) && (Search.Firstname == null || distinct.Firstname.Contains(Search.Firstname)) && (Search.LastName == null || distinct.LastName.Contains(Search.LastName)) && (Search.MiddleName == null || distinct.MiddleName.Contains(Search.MiddleName)) && (Search.BVN == null || distinct.BVN == Search.BVN) && (Search.IsAccountClosed == null || distinct.IsAccountClose == Search.IsAccountClosed) && (Search.StaffNo == null || distinct.StaffNumber == Search.StaffNo) && // (Search.DomicileBranchCode == null || distinct.DomicileBranchCode == Search.DomicileBranchCode) && (Search.BranchCode == null || distinct.StaffBranchCode == Search.BranchCode) && (Search.Irregularity == null || distinct.Irregularity == Search.Irregularity) && (Search.Date_From == null || distinct.DateSubmitted >= Convert.ToDateTime(Search.Date_From) || distinct.DateSubmitted == Convert.ToDateTime(Search.Date_From)) && (Search.Date_To == null || distinct.DateSubmitted <= Convert.ToDateTime(Search.Date_To).AddDays(1))) select new { RequestID = distinct.DocumentID, BVN = distinct.BVN, Staffname = distinct.StaffName, StaffNo = distinct.StaffNumber, AccountNo = distinct.AccountNumberArray, AccountName = distinct.AccountNameArray, AccountStatus = distinct.AccountStatusArray, DomicileBranch = distinct.DomicileBranch, InitiatorBranchName = distinct.StaffBranch, Irregularity = distinct.Irregularity, OtherDetails = distinct.Nature_Of_The_Irregular, FirstName = distinct.Firstname, MiddleName = distinct.MiddleName, LastName = distinct.LastName, IsAccountClosed = distinct.IsAccountClose, DateSubmitted = distinct.DateSubmitted }); foreach (var result_set in Projectinfo) { InputClass input = new InputClass(); Profile profile = new Profile(); Account account = new Account(); input.DocumentID = result_set.RequestID; input.Irregularity = (result_set.Irregularity == "Others") ? result_set.OtherDetails : result_set.Irregularity; input.DateSubmitted = result_set.DateSubmitted; profile.StaffName = result_set.Staffname; profile.StaffNo = result_set.StaffNo; profile.Branch = result_set.InitiatorBranchName; account.AccountName = (result_set.AccountNo == null) ? "" : result_set.AccountNo.Replace(";", "<BR><hr><BR>"); account.AccountNumber = (result_set.AccountName == null) ? "" : result_set.AccountName.Replace(";", "<BR><hr><BR>"); account.AccountStatus = (result_set.AccountStatus == null) ? "" : result_set.AccountStatus.Replace(";", "<BR><hr><BR>"); account.DomicileBranch = result_set.DomicileBranch; account.Firstname = result_set.FirstName; account.LastName = result_set.LastName; account.MiddleName = result_set.MiddleName; account.IsAccountClosedString = (result_set.IsAccountClosed == 1) ? "Yes" : "No"; account.BVN = result_set.BVN; input.RequesterDetails = profile; input.AccountDetials = account; ResultListLists.Add(input); } } catch (Exception ex) { // return ex.Message; } return(ResultListLists); }
public List<InputClass> GetEntry(string DocumentID) { List<InputClass> RequestList = new List<InputClass>(); try { BVNDataContext projectconn = new BVNDataContext(); var Projectinfo = (from distinct in projectconn.Tb_BvnIncidents where (distinct.DocumentID == DocumentID) select new { RequestID = distinct.DocumentID, Irregularity = distinct.Irregularity, IrregularityDetails = distinct.Nature_Of_The_Irregular, DateSubmitted = distinct.DateSubmitted, Staffname = distinct.StaffName, StaffNo = distinct.StaffNumber, InitiatorBranchName = distinct.StaffBranch, JobTitle = distinct.StaffTitle, Email = distinct.Email, AccountNo = distinct.AccountNumber, AccountName = distinct.AccountName, CustomerName = distinct.CustomerNames, Firstname = distinct.Firstname, LastName = distinct.LastName, MiddleName = distinct.MiddleName, DOB = distinct.dateOfBirth, AccountnameArray = distinct.AccountNameArray, AccountNumberArray = distinct.AccountNumberArray, AccountStatusArray = distinct.AccountStatusArray, Comment = distinct.Comment, DomicileBranch = distinct.DomicileBranch, IsAccountClosed = distinct.IsAccountClose, BVN = distinct.BVN }); foreach (var requestList in Projectinfo) { InputClass Myrequest = new InputClass(); Profile profile = new Profile(); Account account = new Account(); profile.StaffName = requestList.Staffname; profile.Branch = requestList.InitiatorBranchName; profile.JobTitle = requestList.JobTitle; profile.Email = requestList.Email; profile.StaffNo = requestList.StaffNo; account.AccountName = requestList.AccountName; account.AccountNumber = requestList.AccountNo; account.customerNames = requestList.CustomerName; account.BVN = requestList.BVN; account.DomicileBranch = requestList.DomicileBranch; account.Firstname = requestList.Firstname; account.MiddleName = requestList.MiddleName; account.LastName = requestList.LastName; account.dateOfBirth = requestList.DOB; //account.IsAccountClosed = (requestList.IsAccountClosed == 1) ? true : false; account.IsAccountClosed = requestList.IsAccountClosed; Myrequest.RequesterDetails = profile; Myrequest.AccountDetials = account; Myrequest.DateSubmitted = requestList.DateSubmitted; Myrequest.Irregularity = requestList.Irregularity; Myrequest.IrregularityDetails = requestList.IrregularityDetails; Myrequest.DocumentID = requestList.RequestID; Myrequest.Comment = requestList.Comment; if (requestList.AccountnameArray != null) { List<Account> AccountNamelist = new List<Account>(); string[] availabledcard = requestList.AccountnameArray.Split(';'); string[] availabledAccNumber = requestList.AccountNumberArray.Split(';'); string[] availabledStatusNumber = requestList.AccountStatusArray.Split(';'); for (int i = 0; i < availabledcard.Count(); i++) { Account card = new Account(); card.AccountName = availabledcard[i]; card.AccountNumber = availabledAccNumber[i]; card.AccountStatus = availabledStatusNumber[i]; AccountNamelist.Add(card); } Myrequest.accountNamelist = AccountNamelist; } RequestList.Add(Myrequest); } } catch (Exception ex) { // return ex.Message; } return RequestList; }