private WOAppointmentOrCessationOfAuditors FetchWOAppointOrCessationDetails(WOAppointmentOrCessationOfAuditors AppointmentOrCessationOfAuditors, SafeDataReader dr)
{
AppointmentOrCessationOfAuditors.WOID=dr.GetInt32("WOID");
AppointmentOrCessationOfAuditors.ModeofAppointment = dr.GetInt32("ModeofAppointment");
AppointmentOrCessationOfAuditors.Auditor = dr.GetInt32("Auditor");
AppointmentOrCessationOfAuditors.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure");
AppointmentOrCessationOfAuditors.IsROPlaceOfMeeting = dr.GetBoolean("IsROPlaceOfMeeting");
AppointmentOrCessationOfAuditors.MAddressLine1 = dr.GetString("MeetingAddressLine1");
AppointmentOrCessationOfAuditors.MAddressLine2 = dr.GetString("MeetingAddressLine2");
AppointmentOrCessationOfAuditors.MAddressLine3 = dr.GetString("MeetingAddressLine3");
AppointmentOrCessationOfAuditors.MAddressCountry = dr.GetInt32("MAddressCountry");
AppointmentOrCessationOfAuditors.MAddressPostalCode = dr.GetString("MPostalCode");
AppointmentOrCessationOfAuditors.MeetingNotice = dr.GetInt32("MeetingNotice");
AppointmentOrCessationOfAuditors.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
AppointmentOrCessationOfAuditors.MeetingMinutes = dr.GetInt32("MeetingMinutes");
AppointmentOrCessationOfAuditors.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
AppointmentOrCessationOfAuditors.OtherMeetingMinutes = dr.GetString("OtherMeetingMinutes");
AppointmentOrCessationOfAuditors.Designation = dr.GetString("Designation");
AppointmentOrCessationOfAuditors.OutgoingAuditor = dr.GetString("OutgoingAuditor");
AppointmentOrCessationOfAuditors.NameOfAuditor = dr.GetString("NameOfAuditor");
return AppointmentOrCessationOfAuditors;
}
private Vendor FetchMatchedVendorDetails(Vendor vendor, SafeDataReader dr)
{
vendor.VenderReferenceID = dr.GetString("VENDORREF");
vendor.VendorAmount = dr.GetDecimal("VENDORAMOUNT");
vendor.DI = dr.GetString("DI");
vendor.DIRef = dr.GetString("DIREF");
vendor.DIAmount = dr.GetDecimal("DIAMOUNT");
vendor.IsBilled = dr.GetBoolean("BILLED");
vendor.Type = dr.GetString("TYPE");
vendor.IsVerified = dr.GetBoolean("ISVERIFIED");
vendor.VRID = dr.GetInt32("VRID");
vendor.VRDID = dr.GetInt32("VRDID");
vendor.ItemCode = dr.GetString("ItemCode");
vendor.ItemNumber = dr.GetString("ItemNumber");
vendor.WOCode = dr.GetString("WOCode");
vendor.InvoiceNumber = dr.GetString("InvoiceNumber");
vendor.ClientName = dr.GetString("ClientName");
vendor.Date = dr.GetString("DATE");
vendor.UsedBy = dr.GetString("SIC");
vendor.GroupName = dr.GetString("GroupName");
return vendor;
}
private Vendor FetchUnmatchedVendorDetails(Vendor vendor, SafeDataReader dr)
{
vendor.VenderReferenceID = dr.GetString("VENDERREFID");
vendor.VendorAmount = dr.GetDecimal("VENDORAMOUNT");
vendor.DI = dr.GetString("DI");
vendor.DIAmount = dr.GetDecimal("DIAMOUNT");
vendor.IsBilled = dr.GetBoolean("BILLED");
vendor.Type = dr.GetString("TYPE");
vendor.VerifyAmount = dr.GetDecimal("VERIFYAMOUNT");
vendor.WOID = dr.GetInt32("WOID");
vendor.ID = dr.GetInt32("ID");
vendor.IsAdhoc = dr.GetInt32("IsAdhoc");
return vendor;
}
private WOEGMChangeOfName FetchEGMChangeOfNameDetailsByWOID(WOEGMChangeOfName WOEGMChangeOfName, SafeDataReader dr)
{
WOEGMChangeOfName.WOID = dr.GetInt32("WOID");
WOEGMChangeOfName.NewName = dr.GetString("NewName");
WOEGMChangeOfName.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure");
WOEGMChangeOfName.IsROPlaceOfMeeting = dr.GetBoolean("IsROPlaceOfMeeting");
WOEGMChangeOfName.MAddressLine1 = dr.GetString("MeetingAddressLine1");
WOEGMChangeOfName.MAddressLine2 = dr.GetString("MeetingAddressLine2");
WOEGMChangeOfName.MAddressLine3 = dr.GetString("MeetingAddressLine3");
WOEGMChangeOfName.MAddressCountry = dr.GetInt32("MAddressCountry");
WOEGMChangeOfName.MAddressPostalCode = dr.GetString("MPostalCode");
WOEGMChangeOfName.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
WOEGMChangeOfName.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
WOEGMChangeOfName.MeetingNotice = dr.GetInt32("MeetingNotice");
WOEGMChangeOfName.MeetingMinutes = dr.GetInt32("MeetingMinutes");
WOEGMChangeOfName.OthersMeetingMinutes = dr.GetString("OthersMeetingMinutes");
WOEGMChangeOfName.Designation = dr.GetString("Designation");
WOEGMChangeOfName.NoticeResolutionSource = dr.GetString("NoticeResolutionSource");
WOEGMChangeOfName.NoticeResolution = dr.GetInt32("NoticeResolution");
return WOEGMChangeOfName;
}
private TemplateMapping FetchTemplateFileDetails(TemplateMapping TMapping, SafeDataReader dr)
{
TMapping.SetID = dr.GetInt32("SetID");
TMapping.SetName = dr.GetString("SetName");
TMapping.FileName = dr.GetString("FileName");
TMapping.FileID = dr.GetInt32("FileID");
TMapping.FileFullName = dr.GetString("FileFullName");
TMapping.FilePath = dr.GetString("FilePath");
TMapping.TFileStatus = dr.GetBoolean("TFileStatus");
TMapping.Description = dr.GetString("Description");
TMapping.IsDefault = dr.GetString("IsDefault");
TMapping.IsMultiple = dr.GetString("IsMultiple");
TMapping.MultipleEntity = dr.GetString("MultipleEntity");
TMapping.SetDescription = dr.GetString("SetDescription");
TMapping.SetStatus = dr.GetBoolean("SetStatus");
return TMapping;
}
//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;
}
private WOTypes FetchService(WOTypes wotypes, SafeDataReader dr)
{
wotypes.WOTypeId = dr.GetInt32("ID");
wotypes.WOName = dr.GetString("Name");
wotypes.WOCategoryCode = dr.GetString("CategoryCode");
wotypes.WOCode = dr.GetString("Code");
wotypes.WODescription = dr.GetString("Description");
wotypes.Status = dr.GetBoolean("Status");
return wotypes;
}
public FeeMapping FetchClientFeeMappingInfo(FeeMapping getClientFeeMappingInfo, SafeDataReader dr)
{
getClientFeeMappingInfo.CFMID = dr.GetInt32("ID");
getClientFeeMappingInfo.BillingFrequency = dr.GetString("BillingFrequency");
getClientFeeMappingInfo.BillingMonth = dr.GetString("BillingMonth");
getClientFeeMappingInfo.IsBillArrears = dr.GetBoolean("IsBillArrears");
getClientFeeMappingInfo.Status = dr.GetString("Status");
getClientFeeMappingInfo.FeeCode = dr.GetString("FeeCode");
getClientFeeMappingInfo.SecurityDeposit = dr.GetDecimal("SecurityDeposit");
getClientFeeMappingInfo.SecurityDepositInvoiceNo = dr.GetString("SecurityDepositInvoiceNo");
getClientFeeMappingInfo.FeeDueToNominee = dr.GetString("FeeDueToNominee");
return getClientFeeMappingInfo;
}
public FeeSetting FetchClientFeeSettingInfo(FeeSetting getClientFeeSettingInfo, SafeDataReader dr)
{
getClientFeeSettingInfo.BillTo = dr.GetInt32("BillTo");
getClientFeeSettingInfo.BillingPartyCode = dr.GetString("BillingPartyCode");
getClientFeeSettingInfo.IsClubFee = dr.GetBoolean("IsClubFee");
getClientFeeSettingInfo.AccountCode = dr.GetString("AccountCode");
return getClientFeeSettingInfo;
}
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;
}
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;
}
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;
}
private Billing FetchBillingFeeInfoClient(Billing getBillingFrequencyAndMonth, SafeDataReader dr)
{
getBillingFrequencyAndMonth.ID = dr.GetInt32("ID");
getBillingFrequencyAndMonth.Code = dr.GetString("Code");
getBillingFrequencyAndMonth.Name = dr.GetString("Name");
getBillingFrequencyAndMonth.NeedSecurityDeposit = dr.GetBoolean("NeedSecurityDeposit");
getBillingFrequencyAndMonth.IsExists = dr.GetInt32("IsExists");
getBillingFrequencyAndMonth.FeeType = dr.GetString("FeeType");
return getBillingFrequencyAndMonth;
}
private Service FetchService(Service service, SafeDataReader dr)
{
service.Id = dr.GetInt32("ID");
service.Code = dr.GetString("Code");
service.Description = dr.GetString("Description");
service.Status = dr.GetBoolean("Status");
return service;
}
private DisbursementItem FetchDITypeDetailsByItemNumber(DisbursementItem dIType, SafeDataReader dr)
{
dIType.Code = dr.GetString("Code");
if (dr["UnitPrice"] != null)
{
dIType.UnitPrice = dr.GetDecimal("UnitPrice");
}
else
{
dIType.UnitPrice = null;
}
dIType.Description = dr.GetString("Description");
dIType.NeedVerification = dr.GetBoolean("NeedVerification");
dIType.Quantity = dr.GetInt32("Units");
return dIType;
}
internal static WOBonusIssue FetchWOBonusByWOID(WOBonusIssue bonusData, SafeDataReader dr)
{
bonusData.ID = dr.GetInt32("ID");
bonusData.WOID = dr.GetInt32("WOID");
bonusData.BonusIssuePerShare = dr.GetString("BonusIssuePerShare");
bonusData.RegisterOfMembersOn = dr.GetString("RegisterOfMembersOn");
bonusData.AmountPaidOnEachShare = dr.GetString("AmountPaidOnEachShare");
bonusData.TotalNoOfIssuedShares = dr.GetString("TotalNoOfIssuedShares");
bonusData.ResultantIssuedCapital = dr.GetString("ResultantIssuedCapital");
bonusData.ClassOfShare = dr.GetInt32("ClassOfShare");
bonusData.ResultantPaidUpCapital = dr.GetString("ResultantPaidUpCapital");
bonusData.IsRegisteredAddressAsPlaceOfMeeting = dr.GetBoolean("IsRegisteredAddressAsPlaceOfMeeting");
bonusData.MeetingAddressLine1 = dr.GetString("MeetingAddressLine1");
bonusData.MeetingAddressLine2 = dr.GetString("MeetingAddressLine2");
bonusData.MeetingAddressLine3 = dr.GetString("MeetingAddressLine3");
bonusData.MeetingAddressCountry = dr.GetInt32("MeetingAddressCountry");
bonusData.MeetingAddressPostalCode = dr.GetString("MeetingAddressPostalCode");
bonusData.MeetingNotice = dr.GetInt32("MeetingNotice");
bonusData.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
bonusData.MeetingMinutes = dr.GetInt32("MeetingMinutes");
bonusData.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
bonusData.OthersMeetingMinutes = dr.GetString("OthersMeetingMinutes");
bonusData.Designation = dr.GetString("Designation");
bonusData.NoticeOfResolution = dr.GetInt32("NoticeOfResolution");
bonusData.NoticeOfResolutionSource = dr.GetString("NoticeOfResolutionSource");
bonusData.LetterOfAllotment = dr.GetInt32("LetterOfAllotment");
bonusData.LetterOfAllotmentSource = dr.GetString("LetterOfAllotmentSource");
bonusData.ReturnOfAllotment = dr.GetInt32("ReturnOfAllotment");
bonusData.ReturnOfAllotmentSource = dr.GetString("ReturnOfAllotmentSource");
bonusData.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure");
bonusData.ConsiderationOfEachShare = dr.GetString("ConsiderationOfEachShare");
bonusData.TotalNoOfNewSharesToBeAllotted = dr.GetString("TotalNoOfNewSharesToBeAllotted");
bonusData.TotalConsideration = dr.GetString("TotalConsideration");
bonusData.Currency = dr.GetInt32("Currency");
return bonusData;
}
private DisbursementItem FetchDisbursementItems(DisbursementItem disbursementItems, SafeDataReader dr)
{
disbursementItems.ID = dr.GetInt32("ID");
disbursementItems.WOID = dr.GetInt32("WOID");
disbursementItems.Amount = dr.GetDecimal("Amount");
disbursementItems.ItemCode = dr.GetString("ItemCode");
disbursementItems.Description = dr.GetString("Description");
disbursementItems.VenderRefID = dr.GetString("VenderRefId");
disbursementItems.Units = dr.GetInt32("Units");
disbursementItems.Code = dr.GetString("Code");
disbursementItems.Type = dr.GetString("DIType");
disbursementItems.IsBilled = dr.GetBoolean("IsBilled");
disbursementItems.IsAdhoc = dr.GetBoolean("IsAdhoc");
disbursementItems.IsArchived = dr.GetBoolean("IsArchived");
disbursementItems.IsVerified = dr.GetBoolean("IsVerified");
return disbursementItems;
}
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;
}
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;
}
private WorkOrders FetchingSerchWODataByWO(WorkOrders SerchWO, SafeDataReader dr)
{
SerchWO.ID = dr.GetInt32("ID");
SerchWO.ClientId = dr.GetString("ClientCode");
SerchWO.WOCode = dr.GetString("WOCode");
SerchWO.GroupCode = dr.GetString("GroupCode");
SerchWO.IsBillable = dr.GetBoolean("IsBillable");
SerchWO.IsAdhoc = dr.GetBoolean("IsAdhoc");
SerchWO.IsPostedToCss1 = dr.GetBoolean("IsPostedToCss1");
SerchWO.CategoryCode = dr.GetString("CategoryCode");
SerchWO.SourceID = dr.GetString("SourceID");
SerchWO.WorkOrderType = dr.GetString("Type");
SerchWO.ClientName = dr.GetString("ClientName");
SerchWO.StatusCode = dr.GetString("StatusCode");
// SerchWO.Status = dr.GetBoolean("Status");
SerchWO.WorkOrderTypeText = dr.GetString("TypeName");
SerchWO.BillingPartyName = dr.GetString("BillingParty");
SerchWO.BillingPartyID = dr.GetInt32("BillingPartyID");
SerchWO.BillingPartySourceID = dr.GetString("BillingPartySourceID");
SerchWO.Description = dr.GetString("Description");
return SerchWO;
}
private GlobalSetting FetchGlobalSettings(GlobalSetting setting, SafeDataReader dr)
{
setting.Id = dr.GetInt32("ID");
setting.Code = dr.GetString("Code");
setting.Value = dr.GetString("Value");
setting.RangeMin = dr.GetString("RangeMin");
setting.RangeMax = dr.GetString("RangeMax");
setting.Description = dr.GetString("Description");
setting.Status = dr.GetBoolean("Status");
return setting;
}
private GLCode FetchGLCode(GLCode glcode, SafeDataReader dr)
{
glcode.Id = dr.GetInt32("ID");
glcode.Code = dr.GetString("Code");
glcode.Description = dr.GetString("Description");
glcode.Status = dr.GetBoolean("Status");
return glcode;
}
private TemplateMapping FetchTemplate(TemplateMapping TMapping, SafeDataReader dr)
{
TMapping.WOID = dr.GetInt32("WOID");
TMapping.SetID = dr.GetInt32("SetID");
TMapping.SetName = dr.GetString("SetName");
TMapping.FileName = dr.GetString("FileName");
TMapping.FileID = dr.GetInt32("FileID");
TMapping.FileFullName = dr.GetString("FileFullName");
TMapping.FilePath = dr.GetString("FilePath");
TMapping.TFileStatus = dr.GetBoolean("TFileStatus");
return TMapping;
}
private Fee FetchFee(Fee Fee, SafeDataReader dr)
{
Fee.ID = dr.GetInt32("ID");
Fee.Code = dr.GetString("Code");
Fee.Name = dr.GetString("Name");
Fee.ItemNumber = dr.GetString("ItemNumber");
Fee.ACCPACCode = dr.GetString("ACCPACCode");
Fee.Description = dr.GetString("Description");
Fee.FeeType = dr.GetString("FeeType");
string data = dr.GetString("Description");
if (data.Contains("~^"))
{
data = data.Replace("~^", Environment.NewLine);
}
Fee.DescriptionWithBreak = data;
Fee.Status = dr.GetBoolean("Status");
Fee.NeedSecurityDeposit = dr.GetBoolean("NeedSecurityDeposit");
Fee.IsUsed = dr.GetInt32("isUsed");
return Fee;
}
public static WOTemplateFileDetails FetchTemplate(WOTemplateFileDetails TMapping, SafeDataReader dr)
{
TMapping.FileName = dr.GetString("FileName");
TMapping.FilePath = dr.GetString("FilePath");
TMapping.IsDefault = dr.GetBoolean("IsDefault");
TMapping.IsMultiple = dr.GetBoolean("IsMultiple");
TMapping.MultipleEntity = dr.GetString("MultipleEntity");
return TMapping;
}
private AllotmentDetails FetchWOAllot(AllotmentDetails WOAllotData, SafeDataReader dr)
{
WOAllotData.WOID = dr.GetInt32("WOID");
WOAllotData.ReturnOfAllotmentOfShares = dr.GetInt32("ReturnOfAllotmentOfShares");
WOAllotData.Currency = dr.GetInt32("Currency");
WOAllotData.ClassOfShare = dr.GetInt32("ClassOfShare");
WOAllotData.NumberOfNewSharesToBeAllotted = dr.GetString("NumberOfNewSharesToBeAllotted");
WOAllotData.ConsiderationOfEachShare = dr.GetString("ConsiderationOfEachShare");
WOAllotData.AmountToBeTreatedAsPaidOnEachShare = dr.GetString("AmountToBeTreatedAsPaidOnEachShare");
WOAllotData.TotalConsideration = dr.GetString("TotalConsideration");
WOAllotData.ResultantTotalNoOfIssuedShares = dr.GetString("ResultantTotalNoOfIssuedShares");
WOAllotData.ResultantIssuedCapital = dr.GetString("ResultantIssuedCapital");
WOAllotData.ResultantPaidUpCapital = dr.GetString("ResultantPaidUpCapital");
WOAllotData.MeetingNotice = dr.GetInt32("MeetingNotice");
WOAllotData.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
WOAllotData.MeetingMinutes = dr.GetInt32("MeetingMinutes");
WOAllotData.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
WOAllotData.OtherMeetingMinutes = dr.GetString("OtherMeetingMinutes");
WOAllotData.Designation = dr.GetString("DesignationOfThePersonSigningTheAllotment");
WOAllotData.NoticeOfResolution = dr.GetInt32("NoticeOfResolution");
WOAllotData.NoticeOfResolutionSource = dr.GetString("NoticeOfResolutionSource");
WOAllotData.F24F25 = dr.GetInt32("F24F25");
WOAllotData.F24F25Source = dr.GetString("F24F25Source");
WOAllotData.ShareholdingStructure = dr.GetInt32("ShareholdingStructure");
WOAllotData.IsROPlaceOfMeeting = dr.GetBoolean("IsROPlaceOfMeeting");
WOAllotData.MAddressLine1 = dr.GetString("MeetingAddressLine1");
WOAllotData.MAddressLine2 = dr.GetString("MeetingAddressLine2");
WOAllotData.MAddressLine3 = dr.GetString("MeetingAddressLine3");
WOAllotData.MAddressCountry = dr.GetInt32("MAddressCountry");
WOAllotData.MAddressPostalCode = dr.GetString("MPostalCode");
return WOAllotData;
}
private Vendor FetchMultiDiscrepancyVendorDetails(Vendor vendor, SafeDataReader dr, bool IsUnbilled)
{
vendor.VenderReferenceID = dr.GetString("VENDORREF");
vendor.VendorAmount = dr.GetDecimal("VENDORAMOUNT");
vendor.DI = dr.GetString("DI");
vendor.DIRef = dr.GetString("DIREF");
vendor.DIAmount = dr.GetDecimal("DIAMOUNT");
vendor.IsBilled = dr.GetBoolean("BILLED");
vendor.Type = dr.GetString("TYPE");
vendor.Discrepancy = (IsUnbilled ? dr.GetDecimal("UnBilledDiscrepancy") : dr.GetDecimal("Discrepancy"));
vendor.VRID = dr.GetInt32("VRID");
vendor.VRDID = dr.GetInt32("VRDID");
vendor.ItemCode = dr.GetString("ItemCode");
vendor.ItemNumber = dr.GetString("ItemNumber");
vendor.Status = dr.GetString("STATUS");
vendor.RowNo = dr.GetInt32("RowNo");
vendor.IsDiscVisible = false;
vendor.WOCode = dr.GetString("WOCode");
vendor.InvoiceNumber = dr.GetString("InvoiceNumber");
vendor.ClientName = dr.GetString("ClientName");
vendor.Date = dr.GetString("DATE");
vendor.UsedBy = dr.GetString("SIC");
vendor.GroupName = dr.GetString("GroupName");
return vendor;
}
//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;
}
private WOExistingClientEngaging FetchECEDetails(WOExistingClientEngaging ECEData, SafeDataReader dr)
{
ECEData.Currency = dr.GetInt32("Currency");
ECEData.ClassOfShare = dr.GetInt32("ClassOfShare");
ECEData.NewAllottedShares = dr.GetString("NewAllottedShares");
ECEData.EachShare = dr.GetString("ConsiderationOfEachShare");
ECEData.AmountPaidToEachShare = dr.GetString("AmountPaidToEachShare");
ECEData.TotalConsideration = dr.GetString("TotalConsideration");
ECEData.NoOfIssuedShares = dr.GetString("ResultantNoOfIssuedShares");
ECEData.IssuedCapital = dr.GetString("IssuedCapital");
ECEData.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
ECEData.MeetingNotice = dr.GetInt32("MeetingNotice");
ECEData.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
ECEData.MeetingMinutes = dr.GetInt32("MeetingMinutes");
ECEData.OthersMeetingMinutes = dr.GetString("OthersMeetingMinutes");
ECEData.Designation = dr.GetString("Designation");
ECEData.NoticeResolutionSource = dr.GetString("NoticeResolutionSource");
ECEData.NoticeResolution = dr.GetInt32("NoticeResolution");
ECEData.F24F25Source = dr.GetString("F24F25Source");
ECEData.F24F25ID = dr.GetInt32("F24F25ID");
ECEData.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure");
ECEData.ResultantPaidupCapital = dr.GetString("ResultantPaidupCapital");
ECEData.IsROPlaceOfMeeting = dr.GetBoolean("IsROPlaceOfMeeting");
ECEData.MAddressLine1 = dr.GetString("MeetingAddressLine1");
ECEData.MAddressLine2 = dr.GetString("MeetingAddressLine2");
ECEData.MAddressLine3 = dr.GetString("MeetingAddressLine3");
ECEData.MAddressCountry = dr.GetInt32("MAddressCountry");
ECEData.MAddressPostalCode = dr.GetString("MPostalCode");
return ECEData;
}
private WOEGMAcquisitionDisposal FetchEGMByWOID(WOEGMAcquisitionDisposal GetDetails, SafeDataReader dr)
{
GetDetails.WOID = dr.GetInt32("WOID");
GetDetails.MeetingNotice = dr.GetString("MeetingNotice");
GetDetails.MeetingNoticeSource = dr.GetString("MeetingNoticeSource");
GetDetails.MeetingMinutes = dr.GetString("MeetingMinutes");
GetDetails.MeetingMinutesSource = dr.GetString("MeetingMinutesSource");
GetDetails.OthersMeetingMinutes = dr.GetString("OthersMeetingMinutes");
GetDetails.Designation = dr.GetString("Designation");
GetDetails.ShareHoldingStructure = dr.GetInt32("ShareHoldingStructure");
GetDetails.ConsiderationCurrency = dr.GetInt32("ConsiderationCurrency");
GetDetails.ConsiderationAmount = dr.GetString("ConsiderationAmount");
GetDetails.NameVendor = dr.GetString("NameVendor");
GetDetails.IsROPlaceOfMeeting = dr.GetBoolean("ISROPlaceOfMeeting");
GetDetails.MeetingAddressLine1 = dr.GetString("MeetingAddressLine1");
GetDetails.MeetingAddressLine2 = dr.GetString("MeetingAddressLine2");
GetDetails.MeetingAddressLine3 = dr.GetString("MeetingAddressLine3");
GetDetails.MeetingAddressCountry = dr.GetInt32("MeetingAddressCountry");
GetDetails.MeetingAddressPostalCode = dr.GetString("MeetingAddressPostalCode");
GetDetails.PropertyAddressLine1 = dr.GetString("PropertyAddressLine1");
GetDetails.PropertyAddressLine2 = dr.GetString("PropertyAddressLine2");
GetDetails.PropertyAddressLine3 = dr.GetString("PropertyAddressLine3");
GetDetails.PropertyAddressCountry = dr.GetInt32("PropertyAddressCountry");
GetDetails.PropertyAddressPostalCode = dr.GetString("PropertyAddressPostalCode");
return GetDetails;
}