Exemplo n.º 1
0
        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;
        }
Exemplo n.º 2
0
        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;
        }