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 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 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 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 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 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 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 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 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);
}
static ReadXML()
{
string PathType = ConfigurationManager.AppSettings[MicroEnums.appSettings.XMLPathType.GetStringValue()];
string FilePath = ConfigurationManager.AppSettings[MicroEnums.appSettings.XMLFilePath_Message.GetStringValue()];
string theXMLFileNameAndPath = MicroGlobals.GetFilePath(PathType, FilePath);
if (System.IO.File.Exists(theXMLFileNameAndPath))
{
// Load the messages to an XML element once for re use across application
xmlMessages = XElement.Load(theXMLFileNameAndPath);
}
else
{
// File doesn't exists
throw (new Exception("XML file not found : " + theXMLFileNameAndPath));
}
}
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);
}
