Exemplo n.º 1
0
 //Need to check
 private DisbursementItem FetchDisbursementItemsByID(DisbursementItem SearchDisbursementItem, SafeDataReader dr)
 {
     SearchDisbursementItem.WorkOrderNumber = dr.GetString("WOCode").Trim();
     SearchDisbursementItem.ClientNumber = dr.GetString("ClientName");
     SearchDisbursementItem.ID = dr.GetInt32("ID");
     SearchDisbursementItem.RefID = SearchDisbursementItem.ID;
     SearchDisbursementItem.WOID = dr.GetInt32("WOID");
     SearchDisbursementItem.Type = dr.GetString("DIType");
     SearchDisbursementItem.Units = dr.GetInt32("Units");
     SearchDisbursementItem.Code = dr.GetString("ItemCode");
     SearchDisbursementItem.ItemNumber = dr.GetString("ItemNumber");
     SearchDisbursementItem.Amount = dr.GetDecimal("Amount");
     SearchDisbursementItem.Description = dr.GetString("Description");
     SearchDisbursementItem.DateIncurred = dr.GetString("DateIncurred");
     SearchDisbursementItem.VenderRefID = dr.GetString("VenderRefId");
     SearchDisbursementItem.IsVerified = dr.GetBoolean("IsVerified");
     SearchDisbursementItem.IsAdhoc = dr.GetBoolean("IsAdhoc");
     SearchDisbursementItem.IsArchived = dr.GetBoolean("IsArchived");
     SearchDisbursementItem.IsBilled = dr.GetBoolean("IsBilled");
     SearchDisbursementItem.UnitPrice = dr.GetDecimal("UnitPrice");
     SearchDisbursementItem.NeedVerification = dr.GetBoolean("NeedVerification");
     SearchDisbursementItem.NoteCount = dr.GetInt32("NoteCount");
     SearchDisbursementItem.NoteType = dr.GetString("NoteType");
     SearchDisbursementItem.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
     SearchDisbursementItem.ACCPACStatus = dr.GetInt32("ACCPACStatus");
     SearchDisbursementItem.ACCPACDescription = dr.GetString("ACCPACDescription");
     SearchDisbursementItem.ACCPACExplanation = dr.GetString("Explaination");
     SearchDisbursementItem.InvoiceNumber = dr.GetString("InvoiceNumber");
     SearchDisbursementItem.IsMatched = dr.GetBoolean("IsMatched");
     return SearchDisbursementItem;
 }
Exemplo n.º 2
0
        private AGMDetails FetchWOAGMDetails(AGMDetails AGMDetails, SafeDataReader dr)
        {
            AGMDetails.ID = dr.GetInt32("ID");
            AGMDetails.WOIDForWoAGM = dr.GetString("WOID");
            AGMDetails.ROPlaceOfAGM = dr.GetBoolean("ROPlaceofAGM");
            AGMDetails.DateOfAGM = dr.GetDateTime("DateofAGM").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("DateofAGM").ToString("dd/MM/yyyy");
            AGMDetails.TimeOfAGM = dr.GetString("TimeofAGM");
            AGMDetails.FinancialYearEnd = dr.GetDateTime("FinancialYearEnd").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("FinancialYearEnd").ToString("dd/MM/yyyy");
            AGMDetails.DateOfFinancialStatement = dr.GetDateTime("DateofFinancialStatement").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("DateofFinancialStatement").ToString("dd/MM/yyyy");
            AGMDetails.IsAuditor = dr.GetBoolean("IsAuditor");
            AGMDetails.Auditors = dr.GetInt32("Auditors");
            AGMDetails.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure");
            AGMDetails.IsDirectorsFeeAmount = dr.GetBoolean("IsDirectorsFeeAmount");
            AGMDetails.DirectorFeeAmount = dr.GetString("DirectorFeeAmount");
            AGMDetails.DirectorCurrency = dr.GetInt32("DirectorCurrency");
            AGMDetails.IsRemunerationAmount = dr.GetBoolean("IsRemunerationAmount");
            AGMDetails.RemunerationAmount = dr.GetString("RemunerationAmount");
            AGMDetails.RemunerationCurrency = dr.GetInt32("RemunerationCurrency");
            AGMDetails.MeetingNotice = dr.GetString("MeetingNotice");
            AGMDetails.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
            AGMDetails.MeetingMinutes = dr.GetString("MeetingMinutes");
            AGMDetails.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
            AGMDetails.OtherMeetingMinutes = dr.GetString("OtherMeetingMinutes");
            AGMDetails.DesignationofPersonSigningAGM = dr.GetString("DesignationofPersonSigningAGM");
            AGMDetails.S197Certificate = dr.GetString("S197Certificate");
            AGMDetails.S197CertificateSource = dr.GetString("S197CertificateSource");
            AGMDetails.IsS161toIssueShares = dr.GetBoolean("IsS161toIssueShares");
            AGMDetails.S161NoticeofResolution = dr.GetString("S161NoticeofResolution");
            AGMDetails.S161NoticeofResolutionSource = dr.GetString("S161NoticeofResolutionSource");
            AGMDetails.DividentVoucher = dr.GetString("DividentVoucher");
            AGMDetails.DividentVoucherSource = dr.GetString("DividentVoucherSource");
            AGMDetails.IsDirectorsdueforRetirement = dr.GetBoolean("IsDirectorsdueforRetirement");
            AGMDetails.IsDividend = dr.GetBoolean("IsDividend");
            AGMDetails.Dividendpershare = dr.GetString("Dividendpershare");
            AGMDetails.DividendCurrency = dr.GetInt32("DividendCurrency");
            AGMDetails.TotalNetAmountofDividend = dr.GetString("TotalNetAmountofDividend");
            AGMDetails.TotalNoOfShares = dr.GetString("TotalNoOfShares");
            AGMDetails.ApprovalFS = dr.GetBoolean("IsApprovalFS");
            AGMDetails.MeetingAddressLine1 = dr.GetString("MeetingAddressLine1");
            AGMDetails.MeetingAddressLine2 = dr.GetString("MeetingAddressLine2");
            AGMDetails.MeetingAddressLine3 = dr.GetString("MeetingAddressLine3");
            AGMDetails.MeetingAddressCountry = dr.GetInt32("MeetingAddressCountry");
            AGMDetails.MeetingAddressPostalCode = dr.GetString("MeetingAddressPostalCode");

            return AGMDetails;
        }
Exemplo n.º 3
0
 private Corporation FetchCorporation(Corporation Corporation, SafeDataReader dr)
 {
     Corporation.ID = dr.GetInt32("ID");
     Corporation.NameOfCompany = dr.GetString("NameOfCompany");
     Corporation.CountryOfIncorporation = dr.GetInt32("CountryOfIncorporation");
     Corporation.CountryNameOfIncorp = dr.GetString("CountryNameOfIncorp");
     Corporation.DateOfIncorporation = dr.GetDateTime("DateOfIncorporation").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("DateOfIncorporation").ToString("dd/MM/yyyy");
     Corporation.DateOfIncorporationList = Corporation.DateOfIncorporation == "" ? "" : dr.GetDateTime("DateOfIncorporation").ToString("dd MMM yyyy");
     Corporation.RegistrationNo = dr.GetString("RegistrationNo");
     Corporation.AccPacCode = dr.GetString("AccpacCode");
     Corporation.AddressLine1 = dr.GetString("AddressLine1");
     Corporation.AddressLine2 = dr.GetString("AddressLine2");
     Corporation.AddressLine3 = dr.GetString("AddressLine3");
     Corporation.Country = dr.GetInt32("Country");
     Corporation.CountryName = dr.GetString("CountryName");
     Corporation.PostalCode = dr.GetString("PostalCode");
     Corporation.Email = dr.GetString("Email");
     Corporation.ContactNo = dr.GetString("Phone");
     Corporation.Fax = dr.GetString("Fax");
     return Corporation;
 }
Exemplo n.º 4
0
        //need to check
        private DisbursementItem FetchDisbursementItemsForSearch(DisbursementItem SearchDisbursementItem, SafeDataReader dr)
        {
            SearchDisbursementItem.ID = dr.GetInt32("ID");
            SearchDisbursementItem.RefID = SearchDisbursementItem.ID;
            SearchDisbursementItem.WOID = dr.GetInt32("WOID");
            SearchDisbursementItem.Code = dr.GetString("Code");
            SearchDisbursementItem.ItemNumber = dr.GetString("ItemNumber");
            SearchDisbursementItem.DiItemToolTip = dr.GetString("DIItemToolTip");
            SearchDisbursementItem.Name = dr.GetString("Name");
            SearchDisbursementItem.Units = dr.GetInt32("Units");
            SearchDisbursementItem.ClientName = dr.GetString("ClientName");
            SearchDisbursementItem.UnitPrice = dr.GetDecimal("UnitPrice");
            SearchDisbursementItem.Amount = dr.GetDecimal("Amount");
            SearchDisbursementItem.WorkOrderNumber = dr.GetString("WOCode").Trim();
            //SearchDisbursementItem.Currency = dr.GetString("Currency");
            SearchDisbursementItem.VenderRefID = dr.GetString("VenderRefId");
            SearchDisbursementItem.DateIncurred = dr.GetString("DateIncurred");
            SearchDisbursementItem.Description = dr.GetString("Description");
            SearchDisbursementItem.NoteCount = dr.GetInt32("NoteCount");
            SearchDisbursementItem.NoteType = dr.GetString("NoteType");

            string toolTip = dr.GetString("Description");
            if (toolTip.Contains("~^"))
            {
                toolTip = toolTip.Replace("~^", Environment.NewLine);
            }
            SearchDisbursementItem.DescriptionToolTip = toolTip;
            int descLength = SearchDisbursementItem.Description.Length;
            if (descLength > 10)
            {
                string strNewDesc = SearchDisbursementItem.Description.Substring(0, 10);
                strNewDesc = strNewDesc + "...";
                SearchDisbursementItem.Description = strNewDesc;
            }

            SearchDisbursementItem.ACCPACStatus = dr.GetInt32("ACCPACStatus");
            SearchDisbursementItem.ACCPACDescription = dr.GetString("ACCPACDescription");
            SearchDisbursementItem.ACCPACExplanation = dr.GetString("Explaination");
            SearchDisbursementItem.IsAdhoc = dr.GetBoolean("IsAdhoc");
            SearchDisbursementItem.IsArchived = dr.GetBoolean("IsArchived");
            SearchDisbursementItem.IsBilled = dr.GetBoolean("IsBilled");
            SearchDisbursementItem.IsVerified = dr.GetBoolean("IsVerified");
            SearchDisbursementItem.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt");

            return SearchDisbursementItem;
        }
Exemplo n.º 5
0
 internal void FetchScheduleHistory(ScheduleHistory history, SafeDataReader dr)
 {
     history.Id = dr.GetInt32("Id");
     history.ScheduleName = dr.GetString("ScheduleName");
     history.Parameter = dr.GetString("Parameter");
     history.ScheduleDescription = dr.GetString("ScheduleDescription");
     history.RunbySystem = dr.GetString("RunbySystem");
     history.LatRunOn = dr.GetDateTime("LatRunOn").ToString("dd MMM yyyy hh:mm:ss tt");
 }
Exemplo n.º 6
0
 private static CABBatch FetchBatchDetails(CABBatch CABBatch, SafeDataReader dr)
 {
     CABBatch.ID = dr.GetInt32("ID");
     CABBatch.Name = dr.GetString("Name");
     CABBatch.BatchCode = dr.GetString("BatchType");
     CABBatch.BatchID = dr.GetString("BatchID");
     CABBatch.FromDate = dr.GetDateTime("FromDate").ToString("dd/MM/yyyy");
     CABBatch.ToDate = dr.GetDateTime("ToDate").ToString("dd/MM/yyyy");
     CABBatch.FromDateList = CABBatch.FromDate == "" ? "" : dr.GetDateTime("FromDate").ToString("dd MMM yyyy");
     CABBatch.ToDateList = CABBatch.ToDate == "" ? "" : dr.GetDateTime("ToDate").ToString("dd MMM yyyy");
     CABBatch.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt"); ;
     return CABBatch;
 }
Exemplo n.º 7
0
            internal static CABMaster FetchCABMasterReport(CABMaster CABMaster, SafeDataReader dr)
            {
                CABMaster.ID = dr.GetInt32("ID");
                CABMaster.BillToClientCode = dr.GetInt32("BillToClientCode");
                CABMaster.BillToSourceID = dr.GetString("BillToSourceID");
                CABMaster.BillToName = dr.GetString("BillToName");
                CABMaster.BillToAccpacCode = dr.GetString("BillToAccpacCode");
                CABMaster.BillForClientCode = dr.GetInt32("BillForClientCode");
                CABMaster.BillForSourceID = dr.GetString("BillForSourceID");
                CABMaster.BillForName = dr.GetString("BillForName");
                CABMaster.BillForAccpacCode = dr.GetString("BillForAccpacCode");
                CABMaster.IsBillToThirdParty = dr.GetInt32("IsBillToThirdParty");
                CABMaster.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt"); ;
                CABMaster.ISAdhoc = dr.GetBoolean("ISAdhoc");
                CABMaster.Amount = dr.GetDecimal("Amount");
                CABMaster.InvoiceNumber = dr.GetString("InvoiceNumber");
                CABMaster.BillType = dr.GetString("BillType");
                if (string.IsNullOrEmpty(CABMaster.InvoiceNumber))
                    CABMaster.IsInvoice = false;
                else CABMaster.IsInvoice = true;

                CABMaster.HSReceivedStatus = dr.GetInt32("HSReceivedStatus");
                CABMaster.Description = dr.GetString("Description");
                CABMaster.Explaination = dr.GetString("Explaination");

                return CABMaster;
            }
Exemplo n.º 8
0
 internal void FetchCss1IntegrationErrors(Css1IntegrationErrors Css1IntegrationErrors, SafeDataReader dr)
 {
     Css1IntegrationErrors.ErrorNumber = dr.GetString("ErrorNumber");
     Css1IntegrationErrors.ErrorMessage = dr.GetString("ErrorMessage");
     Css1IntegrationErrors.ErrorState = dr.GetString("ErrorState");
     Css1IntegrationErrors.ErrorProcedure = dr.GetString("ErrorProcedure");
     Css1IntegrationErrors.ErrorLine = dr.GetString("ErrorLine");
     Css1IntegrationErrors.Type = dr.GetString("Type");
     Css1IntegrationErrors.CreatedOn = dr.GetDateTime("CreatedOn").ToString("dd MMM yyyy hh:mm:ss tt");
 }
Exemplo n.º 9
0
 internal static CABFeeSchedule FetchCABFeeScheduleReportByMasterID(CABFeeSchedule CABFeeSchedule, SafeDataReader dr)
 {
     CABFeeSchedule.ID = dr.GetInt32("ID");
     CABFeeSchedule.ClientCode = dr.GetString("ClientCode");
     CABFeeSchedule.SourceID = dr.GetString("SourceID");
     CABFeeSchedule.FeeCode = dr.GetString("FeeCode");
     CABFeeSchedule.FromDate = dr.GetDateTime("FromDate").ToString("dd/MMM/yyyy");
     CABFeeSchedule.ToDate = dr.GetDateTime("ToDate").ToString("dd/MMM/yyyy");
     CABFeeSchedule.Amount = dr.GetDecimal("Amount");
     CABFeeSchedule.IsArrear = dr.GetBoolean("IsArrear");
     CABFeeSchedule.CreatedDate = dr.GetString("CreatedDate");
     CABFeeSchedule.IsClubFee = dr.GetBoolean("IsClubFee");
     CABFeeSchedule.IsClubFeeBillGenerated = dr.GetBoolean("IsClubFeeBillGenerated");
     CABFeeSchedule.ClubFeeBillID = dr.GetInt32("ClubFeeBillID");
     CABFeeSchedule.CABMasterID = dr.GetInt32("CABMasterID");
     return CABFeeSchedule;
 }
Exemplo n.º 10
0
 internal static CABFeeScheduleDetails FetchCABFeeScheduleDetailsReportByCABFeeScheduleID(CABFeeScheduleDetails CABFeeScheduleDetails, SafeDataReader dr)
 {
     CABFeeScheduleDetails.ID = dr.GetInt32("ID");
     CABFeeScheduleDetails.ClientCode = dr.GetString("ClientCode");
     CABFeeScheduleDetails.SourceID = dr.GetString("SourceID");
     CABFeeScheduleDetails.FeeCode = dr.GetString("FeeCode");
     CABFeeScheduleDetails.BilledFrom = dr.GetDateTime("BilledFrom").ToString("dd/MMM/yyyy"); ;
     CABFeeScheduleDetails.BilledTo = dr.GetDateTime("BilledTo").ToString("dd/MMM/yyyy"); ;
     CABFeeScheduleDetails.Amount = dr.GetDecimal("Amount");
     CABFeeScheduleDetails.Prorate = dr.GetDecimal("Prorate");
     CABFeeScheduleDetails.BillableAmount = dr.GetDecimal("BillableAmount");
     CABFeeScheduleDetails.IsArrear = dr.GetBoolean("IsArrear");
     CABFeeScheduleDetails.CreatedDate = dr.GetString("CreatedDate");
     CABFeeScheduleDetails.CABFeeScheduleID = dr.GetInt32("CABFeeScheduleID");
     return CABFeeScheduleDetails;
 }
Exemplo n.º 11
0
 private WOFee FetchFeeItemsByWOID(WOFee Item, SafeDataReader dr)
 {
     Item.ID = dr.GetInt32("ID");
     Item.WOCode = dr.GetString("WOCode");
     Item.ClientName = dr.GetString("ClientName");
     Item.ItemNumber = dr.GetString("ItemNumber");
     Item.Code = dr.GetString("Code");
     Item.Units = dr.GetInt32("Units");
     Item.Amount = dr.GetDecimal("Amount");
     Item.IsAdhoc = dr.GetBoolean("IsAdhoc");
     Item.IsArchived = dr.GetBoolean("IsArchived");
     Item.IsBilled = dr.GetBoolean("IsBilled");
     Item.Description = dr.GetString("Description");
     string toolTip = dr.GetString("Description");
     if (toolTip.Contains("~^"))
     {
         toolTip = toolTip.Replace("~^", Environment.NewLine);
     }
     Item.FeeDescriptionToolTip = toolTip;
     int descLength = Item.Description.Length;
     if (descLength > 10)
     {
         string strNewDesc = Item.Description.Substring(0, 10);
         strNewDesc = strNewDesc + "...";
         Item.Description = strNewDesc;
     }
     Item.UnitPrice = dr.GetDecimal("UnitPrice");
     Item.NoteCount = dr.GetInt32("NoteCount");
     Item.NoteType = dr.GetString("NoteType");
     Item.RefID = Item.ID;
     Item.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
     Item.FeeItemToolTip = dr.GetString("FeeToolTip");
     Item.ACCPACStatus = dr.GetInt32("ACCPACStatus");
     Item.ACCPACDescription = dr.GetString("ACCPACDescription");
     Item.ACCPACExplanation = dr.GetString("Explaination");
     return Item;
 }
Exemplo n.º 12
0
        private Dashbord FetchWODraftDetails(Dashbord WorkOrderList, SafeDataReader dr)
        {
            WorkOrderList.WorkOrderID = dr.GetString("WOID");
            WorkOrderList.WorkOrderTypeText = dr.GetString("Type");
            WorkOrderList.Name = dr.GetString("ClientName");
            WorkOrderList.CreatedBy = dr.GetString("CreatedBy");
            WorkOrderList.UpdatedDate = dr.GetDateTime("UpdatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
            WorkOrderList.WOCode = dr.GetString("WO");
            WorkOrderList.GroupCode = dr.GetString("GroupCode");

            WorkOrderList.RefID = dr.GetInt32("WOID");
            WorkOrderList.NoteCount = dr.GetInt32("NoteCount");
            WorkOrderList.NoteType = dr.GetString("NoteType");
            WorkOrderList.RowCount = dr.GetString("RowCount");
            return WorkOrderList;
        }
Exemplo n.º 13
0
        private Dashbord FetchAssignedWODetails(Dashbord WorkOrderList, SafeDataReader dr)
        {
            WorkOrderList.WorkOrderID = dr.GetString("WOID");
            WorkOrderList.WorkOrderTypeText = dr.GetString("Type");
            WorkOrderList.Name = dr.GetString("ClientName");
            WorkOrderList.AssignedTo = dr.GetString("AssignedTo");
            WorkOrderList.AssignedDate = dr.GetDateTime("AssignedDate").ToString("dd MMM yyyy hh:mm:ss tt");
            WorkOrderList.WOCode = dr.GetString("WO");
            WorkOrderList.GroupCode = dr.GetString("GroupCode");

            WorkOrderList.RefID = dr.GetInt32("WOID");
            WorkOrderList.NoteCount = dr.GetInt32("NoteCount");
            WorkOrderList.NoteType = dr.GetString("NoteType");
            WorkOrderList.ColorFlag = dr.GetString("ColorFlag");
            WorkOrderList.RowCount = dr.GetString("RowCount");
            return WorkOrderList;
        }
Exemplo n.º 14
0
 internal void FetchActiveUsers(ActiveUsers user, SafeDataReader dr)
 {
     user.DisplayName = dr.GetString("DisplayName");
     user.UserName = dr.GetString("UserName");
     user.Roles = dr.GetString("Roles");
     user.Login = dr.GetDateTime("Login").ToString("dd MMM yyyy hh:mm:ss tt");
     user.Duration = dr.GetString("Duration");
     user.Logout = (dr.GetDateTime("LogoutOn") == DateTime.MinValue) ? string.Empty : dr.GetDateTime("LogoutOn").ToString("dd MMM yyyy hh:mm:ss tt");
 }
Exemplo n.º 15
0
 public FeeSchedule FetchClientScheduleGapInfo(FeeSchedule getClientScheduleGapInfo, SafeDataReader dr)
 {
     getClientScheduleGapInfo.SNO = dr.GetInt32("new_id");
     getClientScheduleGapInfo.FromDate = dr.GetDateTime("start_date").ToString("dd MMM yyyy");
     getClientScheduleGapInfo.ToDate = dr.GetDateTime("end_date").ToString("dd MMM yyyy");
     getClientScheduleGapInfo.Duration = dr.GetInt32("NoofDays");
     return getClientScheduleGapInfo;
 }
Exemplo n.º 16
0
 internal void FetchCABErrors(CABErrors ErrorLog, SafeDataReader dr)
 {
     ErrorLog.ID = dr.GetInt32("ID");
     ErrorLog.ERROR_NUMBER = dr.GetString("ERROR_NUMBER");
     ErrorLog.ERROR_SEVERITY = dr.GetString("ERROR_SEVERITY");
     ErrorLog.ERROR_STATE = dr.GetString("ERROR_STATE");
     ErrorLog.ERROR_PROCEDURE = dr.GetString("ERROR_PROCEDURE");
     ErrorLog.ERROR_LINE = dr.GetString("ERROR_LINE");
     ErrorLog.ERROR_MESSAGE = dr.GetString("ERROR_MESSAGE");
     ErrorLog.SCCode = dr.GetString("SCCode");
     ErrorLog.ONDate = dr.GetString("ONDate");
     ErrorLog.Client = dr.GetString("Client");
     ErrorLog.FeeCode = dr.GetString("FeeCode");
     ErrorLog.CREATEDATE = dr.GetDateTime("CREATEDATE").ToString("dd MMM yyyy hh:mm:ss tt");
 }
Exemplo n.º 17
0
 private WOStatusAndAssignment FetchGroupHistory(WOStatusAndAssignment objAssignment, SafeDataReader dr)
 {
     objAssignment.WOCode = dr.GetString("WOCode");
     objAssignment.GroupCode = dr.GetString("GroupCode");
     objAssignment.AssignedBy = dr.GetString("CreatedBy");
     objAssignment.DateForHistory = dr.GetDateTime("CreatedDate");
     objAssignment.AssignedDate = objAssignment.DateForHistory.ToString("dd MMM yyyy hh:mm:ss tt");
     return objAssignment;
 }
Exemplo n.º 18
0
 internal void FetchErrorLogs(ErrorLogs ErrorLog, SafeDataReader dr)
 {
     ErrorLog.UserName = dr.GetString("UserName");
     ErrorLog.PageName = dr.GetString("PageName");
     ErrorLog.ErrorTime = dr.GetDateTime("ErrorTime").ToString("dd MMM yyyy hh:mm:ss tt");
     ErrorLog.Browser = dr.GetString("Browser");
     ErrorLog.IPAddress = dr.GetString("IPAddress");
     ErrorLog.ErrorMessage = dr.GetString("ErrorMessage");
 }
Exemplo n.º 19
0
 private WOStatusAndAssignment FetchStatusHistory(WOStatusAndAssignment objStatus, SafeDataReader dr)
 {
     objStatus.WOCode = dr.GetString("WOCode");
     objStatus.StatusCode = dr.GetString("StatusCode");
     objStatus.Comment = dr.GetString("Comment");
     objStatus.DateForHistory = dr.GetDateTime("StatusDate");
     objStatus.StatusDate = objStatus.DateForHistory.ToString("dd MMM yyyy hh:mm:ss tt");
     objStatus.StatusName = dr.GetString("Name");
     objStatus.AssignedBy = dr.GetString("AssignedBy");
     return objStatus;
 }
Exemplo n.º 20
0
        public CABBatch FetchGapInfo(CABBatch GapInfo, SafeDataReader dr)
        {
            GapInfo.SNO = dr.GetInt32("new_id");
            GapInfo.FromDate = dr.GetDateTime("start_date").ToString("dd MMM yyyy");
            GapInfo.ToDate = dr.GetDateTime("end_date").ToString("dd MMM yyyy");
            GapInfo.Duration = dr.GetInt32("NoofDays");

            return GapInfo;
        }
Exemplo n.º 21
0
 private WorkOrders FetchingSerchWOData(WorkOrders SerchWO, SafeDataReader dr)
 {
     SerchWO.ID = dr.GetInt32("ID");
     SerchWO.RefID = SerchWO.ID;
     SerchWO.WorkOrderType = dr.GetString("Type");
     // SerchWO.Description = dr.GetString("Description");
     SerchWO.Status = dr.GetBoolean("Status");
     SerchWO.EditStatus = dr.GetBoolean("EditStatus");
     SerchWO.WorkOrderTypeText = dr.GetString("wotypetext");
     SerchWO.ClientId = dr.GetString("ClientName");
     SerchWO.WorkOrderID = dr.GetString("WOCode");
     SerchWO.NoteCount = dr.GetInt32("NoteCount");
     SerchWO.NoteType = dr.GetString("NoteType");
     SerchWO.StatusCode = dr.GetString("Name");
     SerchWO.BillingPartyName = dr.GetString("BillingPartyName");
     SerchWO.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
     SerchWO.IsAdhoc = dr.GetBoolean("IsAdhoc");
     SerchWO.IsPostedToCss1 = dr.GetBoolean("IsPostedToCss1");
     return SerchWO;
 }
Exemplo n.º 22
0
 private WODuplicateDetails FetchWODuplicateShareHoldersDetails(WODuplicateDetails WODuplicateDetails, SafeDataReader dr)
 {
     WODuplicateDetails.ID = dr.GetInt32("ID");
     WODuplicateDetails.Name = dr.GetString("Name");
     WODuplicateDetails.CertNo = dr.GetString("CertNo");
     WODuplicateDetails.NoofShares = dr.GetString("NoofShares");
     //if NULL Displaying as "" in UI
     WODuplicateDetails.DateOfIssue = dr.GetDateTime("DateOfIssue") == default(DateTime) ? string.Empty : dr.GetDateTime("DateOfIssue").ToString("dd/MM/yy");
     WODuplicateDetails.NoOfNewCertToBeIssued = dr.GetInt32("NoOfNewCertToBeIssued");
     return WODuplicateDetails;
 }
Exemplo n.º 23
0
        private InCorpDetails FetchWOInCorp(InCorpDetails WOIncorpData, SafeDataReader dr)
        {
            WOIncorpData.WOID = dr.GetInt32("WOID");
            WOIncorpData.CompanyName = dr.GetString("CompanyName");
            WOIncorpData.ClientNo = dr.GetString("ClientNo");
            WOIncorpData.ClientID = dr.GetInt32("ClientID");
            WOIncorpData.ClientSource = dr.GetString("ClientSource");
            WOIncorpData.IncropDate = dr.GetDateTime("IncropDate").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("IncropDate").ToString("dd/MM/yyyy");
            WOIncorpData.RegistrationNo = dr.GetString("RegistrationNo");
            WOIncorpData.TypeofCompany = dr.GetString("TypeofCompany");
            WOIncorpData.FMGasRegisteredAddress = dr.GetBoolean("FMGasRegisteredAddress");
            WOIncorpData.AddressLine1 = dr.GetString("AddressLine1");
            WOIncorpData.AddressLine2 = dr.GetString("AddressLine2");
            WOIncorpData.AddressLine3 = dr.GetString("AddressLine3");
            WOIncorpData.Country = dr.GetString("Country");
            WOIncorpData.PostalCode = dr.GetString("PostalCode");
            WOIncorpData.FinancialYearEnd = dr.GetDateTime("FinancialYearEnd").ToString("dd MMMM"); //== "01 January" ? "" : dr.GetDateTime("FinancialYearEnd").ToString("dd MMMM");
            WOIncorpData.FirstFinancialYearEnd = dr.GetDateTime("FirstFinancialYearEnd").ToString("dd MMMM yyyy") == "01 January 0001" ? "" : dr.GetDateTime("FirstFinancialYearEnd").ToString("dd MMMM yyyy");
            WOIncorpData.Currency = dr.GetString("Currency");
            WOIncorpData.ClassofShare = dr.GetString("ClassofShare");
            WOIncorpData.PaidupCapital = dr.GetDecimal("PaidupCapital");
            WOIncorpData.AmountPaidupperShare = dr.GetDecimal("AmountPaidupperShare");
            WOIncorpData.ActivityOne = dr.GetString("ActivityOne");
            WOIncorpData.ActivityOneDescription = dr.GetString("ActivityOneDescription");
            WOIncorpData.ActivityTwo = dr.GetString("ActivityTwo");
            WOIncorpData.ActivityTwoDescription = dr.GetString("ActivityTwoDescription");

            WOIncorpData.AmountGuaranteedByEachMember = dr.GetDecimal("AmountGuaranteedByEachMember");
            WOIncorpData.GuaranteedAmountCurrency = dr.GetString("GuaranteedAmountCurrency");

            WOIncorpData.FMGClient = dr.GetBoolean("FMGClient");
            WOIncorpData.ClientType = dr.GetInt32("ClientType");
            WOIncorpData.IncorporationCountry = dr.GetInt32("IncorporationCountry");
            WOIncorpData.CompanyStatus = dr.GetInt32("CompanyStatus");

            return WOIncorpData;
        }