public static DefaultFeeSetup DataRowToObject(DataRow dr) { DefaultFeeSetup TheFee = new DefaultFeeSetup { QualID = int.Parse(dr["QualID"].ToString()), StreamID = int.Parse(dr["StreamID"].ToString()), STREAM = dr["STREAM"].ToString(), QUALIFICATION = dr["QUALIFICATION"].ToString(), AccountTypeID = int.Parse(dr["AccountTypeID"].ToString()), ACCOUNT_TYPE = dr["ACCOUNT_TYPE"].ToString(), ACCOUNT_CODE = dr["ACCOUNT_CODE"].ToString(), AccountGroupID = int.Parse(dr["AccountGroupID"].ToString()), ACCOUNT_GROUP = dr["ACCOUNT_GROUP"].ToString(), AccountID = int.Parse(dr["AccountID"].ToString()), ACCOUNT_NAME = dr["ACCOUNT_NAME"].ToString(), DefaultFee = decimal.Parse(MicroGlobals.ReturnZeroIfNull(dr["DefaultFee"].ToString())), IsActive = bool.Parse(dr["IsActive"].ToString()), IsDeleted = bool.Parse(dr["IsDeleted"].ToString()), AddedBy = int.Parse(dr["AddedBy"].ToString()), OfficeID = int.Parse(dr["OfficeID"].ToString()), CompanyID = int.Parse(dr["CompanyID"].ToString()), }; return(TheFee); }
public static List <GuarantorLoanRecoveries> GetActiveLoanDetails(int loanApplicantId, string loanAppliedBy) { List <GuarantorLoanRecoveries> GuarantorLoanRecoveriesList = new List <GuarantorLoanRecoveries>(); DataTable GuarantorLoanRecoveryTable = GuarantorLoanRecoveryDataAccess.GetInstance.GetActiveLoanDetails(loanApplicantId, loanAppliedBy); foreach (DataRow dr in GuarantorLoanRecoveryTable.Rows) { GuarantorLoanRecoveries TheGuarantorLoanRecoveries = new GuarantorLoanRecoveries(); TheGuarantorLoanRecoveries.GuarantorLoanID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["GuarantorLoanID"].ToString())); if (TheGuarantorLoanRecoveries.GuarantorLoanID != 0) { TheGuarantorLoanRecoveries.GuarantorLoanCode = dr["GuarantorLoanCode"].ToString(); TheGuarantorLoanRecoveries.LoanApplicationDate = DateTime.Parse(dr["LoanApplicationDate"].ToString()).ToString(MicroConstants.DateFormat); TheGuarantorLoanRecoveries.LoanIssueDate = DateTime.Parse(dr["LoanIssueDate"].ToString()).ToString(MicroConstants.DateFormat); if (TheGuarantorLoanRecoveries.LastRecoveryDate != null) { TheGuarantorLoanRecoveries.LastRecoveryDate = DateTime.Parse(dr["LastRecoveryDate"].ToString()).ToString(MicroConstants.DateFormat); } TheGuarantorLoanRecoveries.LoanAmount = decimal.Parse(MicroGlobals.ReturnZeroIfNull(dr["LoanAmount"].ToString())); TheGuarantorLoanRecoveries.DuePrincipalAmount = decimal.Parse(MicroGlobals.ReturnZeroIfNull(dr["DuePrincipalAmount"].ToString())); TheGuarantorLoanRecoveries.DueInterestAmount = decimal.Parse(MicroGlobals.ReturnZeroIfNull(dr["DueInterestAmount"].ToString())); TheGuarantorLoanRecoveries.InterestPaid = decimal.Parse(MicroGlobals.ReturnZeroIfNull(dr["InterestPaid"].ToString())); TheGuarantorLoanRecoveries.LoanAmountRecovered = decimal.Parse(MicroGlobals.ReturnZeroIfNull(dr["LoanAmountRecovered"].ToString())); TheGuarantorLoanRecoveries.NumberOfInstallmentsPaid = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["NumberOfInstallmentsPaid"].ToString())); GuarantorLoanRecoveriesList.Add(TheGuarantorLoanRecoveries); } } return(GuarantorLoanRecoveriesList); }
public static FieldForceChain DataRowToObject(DataRow dr) { FieldForceChain TheFieldForceChain = new FieldForceChain(); TheFieldForceChain.FieldForceChainID = int.Parse(dr["FieldForceChainID"].ToString()); TheFieldForceChain.FieldForceID = int.Parse(dr["FieldForceID"].ToString()); TheFieldForceChain.FieldForceCode = dr["FieldForceCode"].ToString(); TheFieldForceChain.FieldForceName = dr["FieldForceName"].ToString(); TheFieldForceChain.FieldForceRankID = int.Parse(dr["FieldForceRankID"].ToString()); TheFieldForceChain.FieldForceRankName = dr["FieldForceRankName"].ToString(); TheFieldForceChain.FieldForceRankDescription = dr["FieldForceRankDescription"].ToString(); TheFieldForceChain.ReportingToFieldForceID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ReportingToFieldForceID"].ToString())); if (TheFieldForceChain.ReportingToFieldForceID > 0) { TheFieldForceChain.ReportingToFieldForceCode = dr["ReportingToFieldForceCode"].ToString(); TheFieldForceChain.ReportingToFieldForceName = dr["ReportingToFieldForceName"].ToString(); TheFieldForceChain.ReportingToRankID = int.Parse(dr["ReportingToRankID"].ToString()); TheFieldForceChain.ReportingToRankName = dr["ReportingToRankName"].ToString(); TheFieldForceChain.ReportingToRankDescription = dr["ReportingToRankDescription"].ToString(); } TheFieldForceChain.ChainCode = dr["ChainCode"].ToString(); TheFieldForceChain.OfficeID = int.Parse(dr["OfficeID"].ToString()); TheFieldForceChain.OfficeName = dr["OfficeName"].ToString(); TheFieldForceChain.EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat); if (!string.IsNullOrEmpty(dr["EffectiveDateTo"].ToString())) { TheFieldForceChain.EffectiveDateTo = DateTime.Parse(dr["EffectiveDateTo"].ToString()).ToString(MicroConstants.DateFormat); } return(TheFieldForceChain); }
public static AccountTransaction DataRowToObject(DataRow dr) { AccountTransaction TheAccountTransaction = new AccountTransaction { TransactionID = int.Parse(dr["TransactionID"].ToString()), TransactionCode = dr["TransactionCode"].ToString(), TransactionDate = DateTime.Parse(dr["TransactionDate"].ToString()).ToString(MicroConstants.DateFormat), AccountID = int.Parse(dr["AccountID"].ToString()), AccountDescription = dr["AccountDescription"].ToString(), AccountHeadID = int.Parse(dr["AccountHeadID"].ToString()), AccountHeadDescription = dr["AccountHeadDescription"].ToString(), AccountHeadType = dr["AccountHeadType"].ToString(), ParentAccountHeadID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ParentAccountHeadID"].ToString())), ParentAccountHeadDescription = dr["ParentAccountHeadDescription"].ToString(), ParentAccountID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ParentAccountID"].ToString())), IsPrimary = bool.Parse(dr["IsPrimary"].ToString()), AccessType = dr["AccessType"].ToString(), AnalysisFlag = dr["AnalysisFlag"].ToString(), DisplayOrder = int.Parse(dr["DisplayOrder"].ToString()), ThirdPartyDescription = dr["ThirdPartyDescription"].ToString(), TransactionAmount = decimal.Parse(dr["TransactionAmount"].ToString()), TransactionMode = dr["TransactionMode"].ToString(), TransactionReference = dr["TransactionReference"].ToString(), EntrySide = dr["EntrySide"].ToString(), Remarks = dr["Remarks"].ToString(), OfficeID = int.Parse(dr["OfficeID"].ToString()), OfficeName = dr["OfficeName"].ToString(), CompanyID = int.Parse(dr["CompanyID"].ToString()), CompanyName = dr["CompanyName"].ToString() }; return(TheAccountTransaction); }
public static Company DataRowToObject(DataRow dr) { Company TheMicroCompany = new Company(); TheMicroCompany.CompanyID = int.Parse(dr["CompanyID"].ToString()); TheMicroCompany.CompanyName = dr["CompanyName"].ToString(); TheMicroCompany.CompanyAliasName = dr["CompanyAliasName"].ToString(); TheMicroCompany.CompanyCode = dr["CompanyCode"].ToString(); TheMicroCompany.CompanyMailingName = dr["CompanyMailingName"].ToString(); TheMicroCompany.CompanyRegisteredOfficeID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["CompanyRegisteredOfficeID"].ToString())); TheMicroCompany.CompanyHeadOfficeID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["CompanyHeadOfficeID"].ToString())); TheMicroCompany.CompanyRegistrationNumber = dr["CompanyRegistrationNumber"].ToString(); TheMicroCompany.IsActive = bool.Parse(dr["IsActive"].ToString()); TheMicroCompany.CompanyEPFRegistrationNumber = dr["CompanyEPFRegistrationNumber"].ToString(); TheMicroCompany.EstablishmentDate = DateTime.Parse(dr["EstablishmentDate"].ToString()); if (!string.IsNullOrEmpty(dr["CompanyLogoBigSize"].ToString())) { TheMicroCompany.CompanyLogoBigSize = (byte[])dr["CompanyLogoBigSize"]; } if (!string.IsNullOrEmpty(dr["CompanyLogoMediumSize"].ToString())) { TheMicroCompany.CompanyLogoMediumSize = (byte[])dr["CompanyLogoMediumSize"]; } if (!string.IsNullOrEmpty(dr["CompanyLogoSmallSize"].ToString())) { TheMicroCompany.CompanyLogoSmallSize = (byte[])dr["CompanyLogoSmallSize"]; } if (!string.IsNullOrEmpty(dr["CompanyLoginImage"].ToString())) { TheMicroCompany.CompanyLoginImage = (byte[])dr["CompanyLoginImage"]; } TheMicroCompany.CompanyLoginLabelForeColor = dr["CompanyLoginLabelForeColor"].ToString(); return(TheMicroCompany); }
public static CustomerLoan DataRowToObject(DataRow dr) { CustomerLoan TheCustomerLoan = new CustomerLoan(); TheCustomerLoan.CustomerLoanID = int.Parse(dr["CustomerLoanID"].ToString()); TheCustomerLoan.CustomerLoanCode = dr["CustomerLoanCode"].ToString(); TheCustomerLoan.CustomerAccountID = int.Parse(dr["CustomerAccountID"].ToString()); TheCustomerLoan.CustomerAccountCode = dr["CustomerAccountCode"].ToString(); TheCustomerLoan.CustomerID = int.Parse(dr["CustomerID"].ToString()); TheCustomerLoan.CustomerCode = dr["CustomerCode"].ToString(); TheCustomerLoan.CustomerName = dr["CustomerName"].ToString(); TheCustomerLoan.LoanApplicationNumber = dr["LoanApplicationNumber"].ToString(); TheCustomerLoan.LoanApplicationDate = DateTime.Parse(dr["LoanApplicationDate"].ToString()).ToString(MicroConstants.DateFormat); TheCustomerLoan.LoanApplicationFee = decimal.Parse(dr["LoanApplicationFee"].ToString()); TheCustomerLoan.LoanAmount = decimal.Parse(dr["LoanAmount"].ToString()); TheCustomerLoan.RateOfInterest = decimal.Parse(dr["RateOfInterest"].ToString()); TheCustomerLoan.RequiredFor = dr["RequiredFor"].ToString(); TheCustomerLoan.InstallmentType = dr["InstallmentType"].ToString(); TheCustomerLoan.SanctionedByID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["SanctionedByID"].ToString())); TheCustomerLoan.SanctionedByName = dr["SanctionedByName"].ToString(); TheCustomerLoan.IsClosed = bool.Parse(dr["IsClosed"].ToString()); if (TheCustomerLoan.IsClosed) { TheCustomerLoan.ClosureDate = DateTime.Parse(dr["ClosureDate"].ToString()).ToString(MicroConstants.DateFormat); } TheCustomerLoan.OfficeID = int.Parse(dr["OfficeID"].ToString()); TheCustomerLoan.OfficeName = dr["OfficeName"].ToString(); return(TheCustomerLoan); }
public static FieldForcePromotion DataRowToObject(DataRow dr) { FieldForcePromotion TheFieldForcePromotion = new FieldForcePromotion(); TheFieldForcePromotion.FieldForcePromotionID = int.Parse(dr["FieldForcePromotionID"].ToString()); TheFieldForcePromotion.FieldForceID = int.Parse(dr["FieldForceID"].ToString()); TheFieldForcePromotion.FieldForceName = dr["FieldForceName"].ToString(); TheFieldForcePromotion.FieldForceCode = dr["FieldForceCode"].ToString(); TheFieldForcePromotion.BusinessFromDate = DateTime.Parse(dr["BusinessFromDate"].ToString()).ToString(MicroConstants.DateFormat); TheFieldForcePromotion.BusinessToDate = DateTime.Parse(dr["BusinessToDate"].ToString()).ToString(MicroConstants.DateFormat); TheFieldForcePromotion.BusinessNew = decimal.Parse(dr["BusinessNew"].ToString()); TheFieldForcePromotion.BusinessRenew = decimal.Parse(dr["BusinessRenew"].ToString()); TheFieldForcePromotion.BusinessOneTime = decimal.Parse(dr["BusinessOneTime"].ToString()); TheFieldForcePromotion.ExistingRankID = int.Parse(dr["ExistingRankID"].ToString()); TheFieldForcePromotion.ExistingRankDescription = dr["ExistingRankDescription"].ToString(); TheFieldForcePromotion.PromotedToRankID = int.Parse(dr["PromotedToRankID"].ToString()); TheFieldForcePromotion.PromotedToRankDescription = dr["PromotedToRankDescription"].ToString(); TheFieldForcePromotion.PromotionStatus = dr["PromotionStatus"].ToString(); TheFieldForcePromotion.HasAccepted = bool.Parse(dr["HasAccepted"].ToString()); if (!string.IsNullOrEmpty(dr["StatusChangeDate"].ToString())) { TheFieldForcePromotion.StatusChangeDate = DateTime.Parse(dr["StatusChangeDate"].ToString()).ToString(MicroConstants.DateFormat); } TheFieldForcePromotion.StatusChangedByEmployeeID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["StatusChangedByEmployeeID"].ToString())); TheFieldForcePromotion.Remarks = dr["Remarks"].ToString(); TheFieldForcePromotion.OfficeID = int.Parse(dr["OfficeID"].ToString()); return(TheFieldForcePromotion); }
public static AccountHead DataRowToObject(DataRow dr) { AccountHead TheAccountHead = new AccountHead(); TheAccountHead.AccountHeadID = int.Parse(dr["AccountHeadID"].ToString()); TheAccountHead.AccountHeadDescription = dr["AccountHeadDescription"].ToString(); TheAccountHead.AccountHeadType = dr["AccountHeadType"].ToString(); TheAccountHead.ParentAccountHeadID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ParentAccountHeadID"].ToString())); TheAccountHead.ParentAccountHeadDescription = dr["ParentAccountHeadDescription"].ToString(); TheAccountHead.IsPrimary = bool.Parse(dr["IsPrimary"].ToString()); TheAccountHead.DisplayOrder = int.Parse(dr["DisplayOrder"].ToString()); return(TheAccountHead); }
public static UserSetting UserSettingDataRowToObject(DataRow dr) { UserSetting TheUserSetting = new UserSetting { UserSettingKeyID = int.Parse(dr["UserSettingKeyID"].ToString()), UserSettingKeyName = dr["UserSettingKeyName"].ToString(), UserSettingKeyDescription = dr["UserSettingKeyDescription"].ToString(), UserSettingID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["UserSettingID"].ToString())), UserSettingValue = dr["UserSettingValue"].ToString(), UserID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["UserID"].ToString())), }; return(TheUserSetting); }
public static MicroModule DataRowToObject(DataRow dr) { MicroModule TheMicroModule = new MicroModule { ModuleID = int.Parse(dr["ModuleID"].ToString()), ModuleName = dr["ModuleName"].ToString(), ModuleMenuText = dr["ModuleMenuText"].ToString(), ParentModuleID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ParentModuleID"].ToString())), IsActive = bool.Parse(dr["IsActive"].ToString()), IsDeleted = bool.Parse(dr["IsDeleted"].ToString()) }; return(TheMicroModule); }
public static DCDevice DataRowToObject(DataRow dr) { DCDevice TheDCDevice = new DCDevice(); TheDCDevice.DCCollectorID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["DCCollectorID"].ToString())); TheDCDevice.DCDeviceID = int.Parse(dr["DCDeviceID"].ToString()); TheDCDevice.DCDeviceCode = dr["DCDeviceCode"].ToString(); TheDCDevice.DCDeviceSerialNumber = dr["DCDeviceSerialNumber"].ToString(); TheDCDevice.DCCollectorCode = dr["DCCollectorCode"].ToString(); TheDCDevice.DCCollectorName = dr["DCCollectorName"].ToString(); TheDCDevice.AddedBy = int.Parse(dr["AddedBy"].ToString()); TheDCDevice.OfficeID = int.Parse(dr["OfficeID"].ToString()); TheDCDevice.OfficeName = dr["OfficeName"].ToString(); TheDCDevice.DateAdded = DateTime.Parse(dr["DateAdded"].ToString()).ToString(MicroConstants.DateFormat); return(TheDCDevice); }
public static DCDeviceAllotment DataRowToObject(DataRow dr) { DCDeviceAllotment TheDCDeviceAllotment = new DCDeviceAllotment(); TheDCDeviceAllotment.DCDeviceAllotmentID = int.Parse(dr["DCDeviceAllotmentID"].ToString()); TheDCDeviceAllotment.DCDeviceID = int.Parse(dr["DCDeviceID"].ToString()); TheDCDeviceAllotment.DCDeviceCode = dr["DCDeviceCode"].ToString(); TheDCDeviceAllotment.DCDeviceSerialNumber = dr["DCDeviceSerialNumber"].ToString(); TheDCDeviceAllotment.DCCollectorID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["DCCollectorID"].ToString())); TheDCDeviceAllotment.DCCollectorName = dr["DCCollectorName"].ToString(); TheDCDeviceAllotment.EffectiveDateFrom = dr["EffectiveDateFrom"].ToString(); TheDCDeviceAllotment.EffectiveDateTo = dr["EffectiveDateTo"].ToString(); TheDCDeviceAllotment.AddedBy = int.Parse(dr["AddedBy"].ToString()); TheDCDeviceAllotment.OfficeID = int.Parse(dr["OfficeID"].ToString()); TheDCDeviceAllotment.DateAdded = DateTime.Parse(dr["DateAdded"].ToString()).ToString(MicroConstants.DateFormat); return(TheDCDeviceAllotment); }
public static AccountName DataRowToObject(DataRow dr) { AccountName TheAccount = new AccountName { AccountID = int.Parse(dr["AccountID"].ToString()), AccountDescription = dr["AccountDescription"].ToString(), AccountHeadID = int.Parse(dr["AccountHeadID"].ToString()), AccountHeadDescription = dr["AccountHeadDescription"].ToString(), AccountHeadType = dr["AccountHeadType"].ToString(), ParentAccountHeadID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ParentAccountHeadID"].ToString())), ParentAccountHeadDescription = dr["ParentAccountHeadDescription"].ToString(), ParentAccountID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ParentAccountID"].ToString())), IsPrimary = bool.Parse(dr["IsPrimary"].ToString()), AccessType = dr["AccessType"].ToString(), AnalysisFlag = dr["AnalysisFlag"].ToString(), DisplayOrder = int.Parse(dr["DisplayOrder"].ToString()) }; return(TheAccount); }
public static Establishment DataRowToObject(DataRow dr) { Establishment theestablishment = new Establishment(); theestablishment.EstbID = int.Parse(dr["EstbID"].ToString()); theestablishment.EstbCode = dr["EstbCode"].ToString(); theestablishment.EstbTypeCode = dr["EstbTypeCode"].ToString(); theestablishment.EstbTitle = dr["EstbTitle"].ToString(); theestablishment.EstbDescription = dr["EstbDescription"].ToString(); theestablishment.EstbMessage = dr["EstbMessage"].ToString(); if (dr["EstbDate"] != null) { theestablishment.EstbDate = DateTime.Parse(DateTime.Parse(dr["EstbDate"].ToString()).ToString(MicroConstants.DateTimeFormat)); } //if (dr["EstbUploadFile"] != null) //{ // theestablishment.EstbUploadFile = ((byte[])(dr["EstbUploadFile"])); // dr["EstbUploadFile"].ToString(); //} theestablishment.EstbViewStartDate = DateTime.Parse(dr["EstbViewStartDate"].ToString()); //.ToString(MicroConstants.DateFormat); theestablishment.EstbViewEndDate = DateTime.Parse(dr["EstbViewEndDate"].ToString()); //.ToString(MicroConstants.DateFormat); theestablishment.EstbStatusFlag = dr["ESTBSTATUSFLAG"].ToString(); theestablishment.IsActive = bool.Parse(dr["IsActive"].ToString()); theestablishment.IsDeleted = bool.Parse(dr["IsDeleted"].ToString()); theestablishment.AddedBy = int.Parse(dr["AddedBy"].ToString()); theestablishment.ModifiedBy = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ModifiedBy"].ToString())); //theestablishment. = DateTime.Parse(dr["DateAdded"].ToString()).ToString(MicroConstants.DateFormat); if (theestablishment.DateAdded != null) { theestablishment.DateAdded = DateTime.Parse(dr["DateAdded"].ToString()).ToString(MicroConstants.DateFormat); } if (theestablishment.DateModified != null) { theestablishment.DateModified = DateTime.Parse(dr["DateModified"].ToString()).ToString(MicroConstants.DateFormat); } theestablishment.OfficeID = int.Parse(dr["OfficeID"].ToString()); theestablishment.CompanyID = int.Parse(dr["CompanyID"].ToString()); theestablishment.FileNameWithPath = dr["VC_FIELD2"].ToString(); theestablishment.AuthorOrContributorName = dr["EmployeeName"].ToString().Trim(); return(theestablishment); }
public static MicroMenu DataRowToObject(DataRow dr) { MicroMenu TheMicroMenu = new MicroMenu { MenuID = int.Parse(dr["MenuID"].ToString()), MenuItemName = dr["MenuItemName"].ToString(), ShortCutKey = dr["ShortCutKey"].ToString(), ShortCutDisplayString = dr["ShortCutDisplayString"].ToString(), ParentMenuID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ParentMenuID"].ToString())), ModuleID = int.Parse(dr["ModuleID"].ToString()), FormID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["FormID"].ToString())), FormName = dr["FormName"].ToString(), ActualFormName = dr["ActualFormName"].ToString(), ActualFormClassName = dr["ActualFormClassName"].ToString(), DisplayOrder = int.Parse(dr["DisplayOrder"].ToString()), IsActive = bool.Parse(dr["IsActive"].ToString()), IsDeleted = bool.Parse(dr["IsDeleted"].ToString()) }; return(TheMicroMenu); }
internal static PaymentsLICMoneyback DataRowToObject(DataRow dr) { PaymentsLICMoneyback TheLICMoneybackPayment = new PaymentsLICMoneyback(); { TheLICMoneybackPayment.LICMoneyBackID = int.Parse(dr["LICMoneyBackID"].ToString()); TheLICMoneybackPayment.CustomerAccountID = int.Parse(dr["CustomerAccountID"].ToString()); TheLICMoneybackPayment.CustomerAccountCode = dr["CustomerAccountCode"].ToString(); TheLICMoneybackPayment.CustomerName = dr["CustomerName"].ToString(); TheLICMoneybackPayment.DueDateOfPayment = DateTime.Parse(dr["DueDateOfPayment"].ToString()).ToString(MicroConstants.DateFormat); TheLICMoneybackPayment.MoneyBackPayable = decimal.Parse(dr["MoneyBackPayable"].ToString()); TheLICMoneybackPayment.MoneyBackDescription = dr["MoneyBackDescription"].ToString(); if (!string.IsNullOrEmpty(dr["ActualDateOfPayment"].ToString())) { TheLICMoneybackPayment.ActualDateOfPayment = DateTime.Parse(dr["ActualDateOfPayment"].ToString()).ToString(MicroConstants.DateFormat); } TheLICMoneybackPayment.ActualMoneyBackAmountPaid = decimal.Parse(MicroGlobals.ReturnZeroIfNull(dr["ActualMoneyBackAmountPaid"].ToString())); TheLICMoneybackPayment.PaymentStatus = dr["PaymentStatus"].ToString(); } return(TheLICMoneybackPayment); }
public static Customer DataRowToObject(DataRow dr) { Customer TheCustomer = new Customer { CustomerID = int.Parse(dr["CustomerID"].ToString()), CustomerCode = dr["CustomerCode"].ToString(), Salutation = dr["Salutation"].ToString(), CustomerName = dr["CustomerName"].ToString(), FatherName = dr["FatherName"].ToString(), HusbandName = dr["HusbandName"].ToString(), Gender = dr["Gender"].ToString(), MaritalStatus = dr["MaritalStatus"].ToString(), DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString()).ToString(MicroConstants.DateFormat), Age = int.Parse(dr["Age"].ToString()), Address_Present_TownOrCity = dr["Address_Present_TownOrCity"].ToString(), Address_Present_Landmark = dr["Address_Present_Landmark"].ToString(), Address_Present_PinCode = dr["Address_Present_PinCode"].ToString(), Address_Present_DistrictID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["Address_Present_DistrictID"].ToString())), Address_Present_DistrictName = dr["Address_Present_DistrictName"].ToString(), Address_Present_StateName = dr["Address_Present_StateName"].ToString(), Address_Present_CountryName = dr["Address_Present_CountryName"].ToString(), Address_Permanent_TownOrCity = dr["Address_Permanent_TownOrCity"].ToString(), Address_Permanent_Landmark = dr["Address_Permanent_Landmark"].ToString(), Address_Permanent_PinCode = dr["Address_Permanent_PinCode"].ToString(), Address_Permanent_DistrictID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["Address_Permanent_DistrictID"].ToString())), Address_Permanent_DistrictName = dr["Address_Permanent_DistrictName"].ToString(), Address_Permanent_StateName = dr["Address_Permanent_StateName"].ToString(), Address_Permanent_CountryName = dr["Address_Permanent_CountryName"].ToString(), PhoneNumber = dr["PhoneNumber"].ToString(), Mobile = dr["Mobile"].ToString(), EMailID = dr["EMailID"].ToString(), Occupation = dr["Occupation"].ToString(), OfficeID = int.Parse(dr["OfficeID"].ToString()), OfficeName = dr["OfficeName"].ToString() }; return(TheCustomer); }
public static CustomerAccount DataRowToObject(DataRow dr) { CustomerAccount TheCustomerAccount = new CustomerAccount(); TheCustomerAccount.CustomerAccountID = int.Parse(dr["CustomerAccountID"].ToString()); TheCustomerAccount.CustomerID = int.Parse(dr["CustomerID"].ToString()); TheCustomerAccount.CustomerCode = dr["CustomerCode"].ToString(); TheCustomerAccount.CustomerName = dr["CustomerName"].ToString(); TheCustomerAccount.CustomerAccountCode = dr["CustomerAccountCode"].ToString(); TheCustomerAccount.IsJointApplication = bool.Parse(dr["IsJointApplication"].ToString()); TheCustomerAccount.ApplicationFormNumber = dr["ApplicationFormNumber"].ToString(); TheCustomerAccount.ApplicationDate = DateTime.Parse(dr["ApplicationDate"].ToString()).ToString(MicroConstants.DateFormat); if (TheCustomerAccount.IsJointApplication) { TheCustomerAccount.SecondApplicantName = dr["SecondApplicantName"].ToString(); TheCustomerAccount.SecondApplicantAge = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["SecondApplicantAge"].ToString())); if (!string.IsNullOrEmpty(dr["SecondApplicantSignature"].ToString())) { TheCustomerAccount.SecondApplicantSignature = (byte[])dr["SecondApplicantSignature"]; } TheCustomerAccount.SecondApplicantPANGIR = dr["SecondApplicantPANGIR"].ToString(); TheCustomerAccount.ThirdApplicantName = dr["ThirdApplicantName"].ToString(); TheCustomerAccount.ThirdApplicantAge = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ThirdApplicantAge"].ToString())); if (!string.IsNullOrEmpty(dr["ThirdApplicantSignature"].ToString())) { TheCustomerAccount.ThirdApplicantSignature = (byte[])dr["ThirdApplicantSignature"]; } TheCustomerAccount.ThirdApplicantPANGIR = dr["ThirdApplicantPANGIR"].ToString(); } TheCustomerAccount.NomineeName = dr["NomineeName"].ToString(); TheCustomerAccount.Nominee_Permanent_TownOrCity = dr["Nominee_Permanent_TownOrCity"].ToString(); TheCustomerAccount.Nominee_Permanent_Landmark = dr["Nominee_Permanent_Landmark"].ToString(); TheCustomerAccount.Nominee_Permanent_PinCode = dr["Nominee_Permanent_PinCode"].ToString(); TheCustomerAccount.Nominee_Permanent_DistrictID = int.Parse(dr["Nominee_Permanent_DistrictID"].ToString()); TheCustomerAccount.Nominee_Permanent_DistrictName = dr["Nominee_Permanent_DistrictName"].ToString(); TheCustomerAccount.Nominee_Permanent_StateName = dr["Nominee_Permanent_StateName"].ToString(); TheCustomerAccount.Nominee_Permanent_CountryName = dr["Nominee_Permanent_CountryName"].ToString(); TheCustomerAccount.NomineeRelationship = dr["NomineeRelationship"].ToString(); TheCustomerAccount.NomineeAge = int.Parse(dr["NomineeAge"].ToString()); TheCustomerAccount.PolicyName = dr["PolicyName"].ToString(); TheCustomerAccount.PolicyTypeID = int.Parse(dr["PolicyTypeID"].ToString()); TheCustomerAccount.PolicyTypeDescription = dr["PolicyTypeDescription"].ToString(); TheCustomerAccount.InstallmentMode = dr["InstallmentMode"].ToString(); TheCustomerAccount.TermInMonths = int.Parse(dr["TermInMonths"].ToString()); TheCustomerAccount.InstallmentAmount = decimal.Parse(dr["InstallmentAmount"].ToString()); TheCustomerAccount.NumberOfInstallmentsToBePaid = int.Parse(dr["NumberOfInstallmentsToBePaid"].ToString()); TheCustomerAccount.NumberOfInstallmentsPaid = int.Parse(dr["NumberOfInstallmentsPaid"].ToString()); TheCustomerAccount.FieldForceRankID = int.Parse(dr["FieldForceRankID"].ToString()); TheCustomerAccount.FieldForceID = int.Parse(dr["FieldForceID"].ToString()); TheCustomerAccount.FieldForceCode = dr["FieldForceCode"].ToString(); TheCustomerAccount.FieldForceName = dr["FieldForceName"].ToString(); TheCustomerAccount.DueDateOfLastPayment = DateTime.Parse(dr["DueDateOfLastPayment"].ToString()).ToString(MicroConstants.DateFormat); TheCustomerAccount.DueDateOfMaturity = DateTime.Parse(dr["DueDateOfMaturity"].ToString()).ToString(MicroConstants.DateFormat); TheCustomerAccount.PayToCompany = decimal.Parse(dr["PayToCompany"].ToString()); TheCustomerAccount.GuaranteedDividend = decimal.Parse(dr["GuaranteedDividend"].ToString()); TheCustomerAccount.BonusAmount = decimal.Parse(dr["BonusAmount"].ToString()); TheCustomerAccount.PayByCompany = decimal.Parse(dr["PayByCompany"].ToString()); TheCustomerAccount.MoneybackPayable = decimal.Parse(dr["MoneybackPayable"].ToString()); TheCustomerAccount.RevivalState = bool.Parse(dr["RevivalState"].ToString()); TheCustomerAccount.SellingState = bool.Parse(dr["SellingState"].ToString()); TheCustomerAccount.MaturityState = bool.Parse(dr["MaturityState"].ToString()); TheCustomerAccount.DCAccountID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["DCAccountID"].ToString())); TheCustomerAccount.OfficeID = int.Parse(dr["OfficeID"].ToString()); return(TheCustomerAccount); }
public static FieldForce DataRowToObject(DataRow dr) { FieldForce TheFieldForce = new FieldForce(); TheFieldForce.FieldForceID = int.Parse(dr["FieldForceID"].ToString()); TheFieldForce.FieldForceCode = dr["FieldForceCode"].ToString(); TheFieldForce.FieldForceRankID = int.Parse(dr["FieldForceRankID"].ToString()); TheFieldForce.FieldForceRankName = dr["FieldForceRankName"].ToString(); TheFieldForce.FieldForceRankDescription = dr["FieldForceRankDescription"].ToString(); TheFieldForce.ReportingToFieldForceRankID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ReportingToFieldForceRankID"].ToString())); if (TheFieldForce.ReportingToFieldForceRankID > 0) { TheFieldForce.ReportingToFieldForceRankName = dr["ReportingToFieldForceRankName"].ToString(); TheFieldForce.ReportingToFieldForceRankDescription = dr["ReportingToFieldForceRankDescription"].ToString(); TheFieldForce.ReportingToFieldForceID = int.Parse(dr["ReportingToFieldForceID"].ToString()); TheFieldForce.ReportingToFieldForceCode = dr["ReportingToFieldForceCode"].ToString(); TheFieldForce.ReportingToFieldForceName = dr["ReportingToFieldForceName"].ToString(); } TheFieldForce.Salutation = dr["Salutation"].ToString(); TheFieldForce.FieldForceName = dr["FieldForceName"].ToString(); TheFieldForce.FatherName = dr["FatherName"].ToString(); TheFieldForce.HusbandName = dr["HusbandName"].ToString(); TheFieldForce.Gender = dr["Gender"].ToString(); TheFieldForce.MaritalStatus = dr["MaritalStatus"].ToString(); TheFieldForce.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString()).ToString(MicroConstants.DateFormat); TheFieldForce.Age = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["Age"].ToString())); TheFieldForce.Address_Present_TownOrCity = dr["Address_Present_TownOrCity"].ToString(); TheFieldForce.Address_Present_Landmark = dr["Address_Present_Landmark"].ToString(); TheFieldForce.Address_Present_PinCode = dr["Address_Present_PinCode"].ToString(); TheFieldForce.Address_Present_DistrictID = int.Parse(dr["Address_Present_DistrictID"].ToString()); TheFieldForce.Address_Present_DistrictName = dr["Address_Present_DistrictName"].ToString(); TheFieldForce.Address_Present_StateName = dr["Address_Present_StateName"].ToString(); TheFieldForce.Address_Present_CountryName = dr["Address_Present_CountryName"].ToString(); TheFieldForce.Address_Permanent_TownOrCity = dr["Address_Permanent_TownOrCity"].ToString(); TheFieldForce.Address_Permanent_Landmark = dr["Address_Permanent_Landmark"].ToString(); TheFieldForce.Address_Permanent_PinCode = dr["Address_Permanent_PinCode"].ToString(); TheFieldForce.Address_Permanent_DistrictID = int.Parse(dr["Address_Permanent_DistrictID"].ToString()); TheFieldForce.Address_Permanent_DistrictName = dr["Address_Permanent_DistrictName"].ToString(); TheFieldForce.Address_Permanent_StateName = dr["Address_Permanent_StateName"].ToString(); TheFieldForce.Address_Permanent_CountryName = dr["Address_Permanent_CountryName"].ToString(); TheFieldForce.PhoneNumber = dr["PhoneNumber"].ToString(); TheFieldForce.Mobile = dr["Mobile"].ToString(); TheFieldForce.EMailID = dr["EMailID"].ToString(); TheFieldForce.FieldForce_Qualification = dr["FieldForce_Qualification"].ToString(); TheFieldForce.Occupation = dr["Occupation"].ToString(); TheFieldForce.Nationality = dr["Nationality"].ToString(); TheFieldForce.Religion = dr["Religion"].ToString(); TheFieldForce.Caste = dr["Caste"].ToString(); TheFieldForce.NomineeName = dr["NomineeName"].ToString(); TheFieldForce.Nominee_Permanent_TownOrCity = dr["Nominee_Permanent_TownOrCity"].ToString(); TheFieldForce.Nominee_Permanent_Landmark = dr["Nominee_Permanent_Landmark"].ToString(); TheFieldForce.Nominee_Permanent_PinCode = dr["Nominee_Permanent_PinCode"].ToString(); TheFieldForce.Nominee_Permanent_DistrictID = int.Parse(dr["Nominee_Permanent_DistrictID"].ToString()); TheFieldForce.Nominee_Permanent_DistrictName = dr["Nominee_Permanent_DistrictName"].ToString(); TheFieldForce.Nominee_Permanent_StateName = dr["Nominee_Permanent_StateName"].ToString(); TheFieldForce.Nominee_Permanent_CountryName = dr["Nominee_Permanent_CountryName"].ToString(); TheFieldForce.NomineeRelationship = dr["NomineeRelationship"].ToString(); TheFieldForce.NomineeAge = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["NomineeAge"].ToString())); TheFieldForce.IsNomineeACoWorker = bool.Parse(dr["IsNomineeACoWorker"].ToString()); TheFieldForce.Nominee_Qualification = dr["Nominee_Qualification"].ToString(); TheFieldForce.BankBranchID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["BankBranchID"].ToString())); if (TheFieldForce.BankBranchID > 0) { TheFieldForce.BankName = dr["BankName"].ToString(); TheFieldForce.BankBranchName = dr["BankBranchName"].ToString(); TheFieldForce.BankAccountNumber = dr["BankAccountNumber"].ToString(); } TheFieldForce.HasServiceComplain = bool.Parse(dr["HasServiceComplain"].ToString()); TheFieldForce.OfficeID = int.Parse(dr["OfficeID"].ToString()); TheFieldForce.OfficeName = dr["OfficeName"].ToString(); return(TheFieldForce); }