//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 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 Corporation FetchCorporation(Corporation Corporation, SafeDataReader dr)
{
Corporation.ID = dr.GetInt32("ID");
Corporation.NameOfCompany = dr.GetString("NameOfCompany");
Corporation.CountryOfIncorporation = dr.GetInt32("CountryOfIncorporation");
Corporation.CountryNameOfIncorp = dr.GetString("CountryNameOfIncorp");
Corporation.DateOfIncorporation = dr.GetDateTime("DateOfIncorporation").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("DateOfIncorporation").ToString("dd/MM/yyyy");
Corporation.DateOfIncorporationList = Corporation.DateOfIncorporation == "" ? "" : dr.GetDateTime("DateOfIncorporation").ToString("dd MMM yyyy");
Corporation.RegistrationNo = dr.GetString("RegistrationNo");
Corporation.AccPacCode = dr.GetString("AccpacCode");
Corporation.AddressLine1 = dr.GetString("AddressLine1");
Corporation.AddressLine2 = dr.GetString("AddressLine2");
Corporation.AddressLine3 = dr.GetString("AddressLine3");
Corporation.Country = dr.GetInt32("Country");
Corporation.CountryName = dr.GetString("CountryName");
Corporation.PostalCode = dr.GetString("PostalCode");
Corporation.Email = dr.GetString("Email");
Corporation.ContactNo = dr.GetString("Phone");
Corporation.Fax = dr.GetString("Fax");
return Corporation;
}
//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;
}
internal void FetchScheduleHistory(ScheduleHistory history, SafeDataReader dr)
{
history.Id = dr.GetInt32("Id");
history.ScheduleName = dr.GetString("ScheduleName");
history.Parameter = dr.GetString("Parameter");
history.ScheduleDescription = dr.GetString("ScheduleDescription");
history.RunbySystem = dr.GetString("RunbySystem");
history.LatRunOn = dr.GetDateTime("LatRunOn").ToString("dd MMM yyyy hh:mm:ss tt");
}
private static CABBatch FetchBatchDetails(CABBatch CABBatch, SafeDataReader dr)
{
CABBatch.ID = dr.GetInt32("ID");
CABBatch.Name = dr.GetString("Name");
CABBatch.BatchCode = dr.GetString("BatchType");
CABBatch.BatchID = dr.GetString("BatchID");
CABBatch.FromDate = dr.GetDateTime("FromDate").ToString("dd/MM/yyyy");
CABBatch.ToDate = dr.GetDateTime("ToDate").ToString("dd/MM/yyyy");
CABBatch.FromDateList = CABBatch.FromDate == "" ? "" : dr.GetDateTime("FromDate").ToString("dd MMM yyyy");
CABBatch.ToDateList = CABBatch.ToDate == "" ? "" : dr.GetDateTime("ToDate").ToString("dd MMM yyyy");
CABBatch.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt"); ;
return CABBatch;
}
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 void FetchCss1IntegrationErrors(Css1IntegrationErrors Css1IntegrationErrors, SafeDataReader dr)
{
Css1IntegrationErrors.ErrorNumber = dr.GetString("ErrorNumber");
Css1IntegrationErrors.ErrorMessage = dr.GetString("ErrorMessage");
Css1IntegrationErrors.ErrorState = dr.GetString("ErrorState");
Css1IntegrationErrors.ErrorProcedure = dr.GetString("ErrorProcedure");
Css1IntegrationErrors.ErrorLine = dr.GetString("ErrorLine");
Css1IntegrationErrors.Type = dr.GetString("Type");
Css1IntegrationErrors.CreatedOn = dr.GetDateTime("CreatedOn").ToString("dd MMM yyyy hh:mm:ss tt");
}
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;
}
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;
}
private WOFee FetchFeeItemsByWOID(WOFee Item, SafeDataReader dr)
{
Item.ID = dr.GetInt32("ID");
Item.WOCode = dr.GetString("WOCode");
Item.ClientName = dr.GetString("ClientName");
Item.ItemNumber = dr.GetString("ItemNumber");
Item.Code = dr.GetString("Code");
Item.Units = dr.GetInt32("Units");
Item.Amount = dr.GetDecimal("Amount");
Item.IsAdhoc = dr.GetBoolean("IsAdhoc");
Item.IsArchived = dr.GetBoolean("IsArchived");
Item.IsBilled = dr.GetBoolean("IsBilled");
Item.Description = dr.GetString("Description");
string toolTip = dr.GetString("Description");
if (toolTip.Contains("~^"))
{
toolTip = toolTip.Replace("~^", Environment.NewLine);
}
Item.FeeDescriptionToolTip = toolTip;
int descLength = Item.Description.Length;
if (descLength > 10)
{
string strNewDesc = Item.Description.Substring(0, 10);
strNewDesc = strNewDesc + "...";
Item.Description = strNewDesc;
}
Item.UnitPrice = dr.GetDecimal("UnitPrice");
Item.NoteCount = dr.GetInt32("NoteCount");
Item.NoteType = dr.GetString("NoteType");
Item.RefID = Item.ID;
Item.CreatedDate = dr.GetDateTime("CreatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
Item.FeeItemToolTip = dr.GetString("FeeToolTip");
Item.ACCPACStatus = dr.GetInt32("ACCPACStatus");
Item.ACCPACDescription = dr.GetString("ACCPACDescription");
Item.ACCPACExplanation = dr.GetString("Explaination");
return Item;
}
private Dashbord FetchWODraftDetails(Dashbord WorkOrderList, SafeDataReader dr)
{
WorkOrderList.WorkOrderID = dr.GetString("WOID");
WorkOrderList.WorkOrderTypeText = dr.GetString("Type");
WorkOrderList.Name = dr.GetString("ClientName");
WorkOrderList.CreatedBy = dr.GetString("CreatedBy");
WorkOrderList.UpdatedDate = dr.GetDateTime("UpdatedDate").ToString("dd MMM yyyy hh:mm:ss tt");
WorkOrderList.WOCode = dr.GetString("WO");
WorkOrderList.GroupCode = dr.GetString("GroupCode");
WorkOrderList.RefID = dr.GetInt32("WOID");
WorkOrderList.NoteCount = dr.GetInt32("NoteCount");
WorkOrderList.NoteType = dr.GetString("NoteType");
WorkOrderList.RowCount = dr.GetString("RowCount");
return WorkOrderList;
}
private Dashbord FetchAssignedWODetails(Dashbord WorkOrderList, SafeDataReader dr)
{
WorkOrderList.WorkOrderID = dr.GetString("WOID");
WorkOrderList.WorkOrderTypeText = dr.GetString("Type");
WorkOrderList.Name = dr.GetString("ClientName");
WorkOrderList.AssignedTo = dr.GetString("AssignedTo");
WorkOrderList.AssignedDate = dr.GetDateTime("AssignedDate").ToString("dd MMM yyyy hh:mm:ss tt");
WorkOrderList.WOCode = dr.GetString("WO");
WorkOrderList.GroupCode = dr.GetString("GroupCode");
WorkOrderList.RefID = dr.GetInt32("WOID");
WorkOrderList.NoteCount = dr.GetInt32("NoteCount");
WorkOrderList.NoteType = dr.GetString("NoteType");
WorkOrderList.ColorFlag = dr.GetString("ColorFlag");
WorkOrderList.RowCount = dr.GetString("RowCount");
return WorkOrderList;
}
internal void FetchActiveUsers(ActiveUsers user, SafeDataReader dr)
{
user.DisplayName = dr.GetString("DisplayName");
user.UserName = dr.GetString("UserName");
user.Roles = dr.GetString("Roles");
user.Login = dr.GetDateTime("Login").ToString("dd MMM yyyy hh:mm:ss tt");
user.Duration = dr.GetString("Duration");
user.Logout = (dr.GetDateTime("LogoutOn") == DateTime.MinValue) ? string.Empty : dr.GetDateTime("LogoutOn").ToString("dd MMM yyyy hh:mm:ss tt");
}
public FeeSchedule FetchClientScheduleGapInfo(FeeSchedule getClientScheduleGapInfo, SafeDataReader dr)
{
getClientScheduleGapInfo.SNO = dr.GetInt32("new_id");
getClientScheduleGapInfo.FromDate = dr.GetDateTime("start_date").ToString("dd MMM yyyy");
getClientScheduleGapInfo.ToDate = dr.GetDateTime("end_date").ToString("dd MMM yyyy");
getClientScheduleGapInfo.Duration = dr.GetInt32("NoofDays");
return getClientScheduleGapInfo;
}
internal void FetchCABErrors(CABErrors ErrorLog, SafeDataReader dr)
{
ErrorLog.ID = dr.GetInt32("ID");
ErrorLog.ERROR_NUMBER = dr.GetString("ERROR_NUMBER");
ErrorLog.ERROR_SEVERITY = dr.GetString("ERROR_SEVERITY");
ErrorLog.ERROR_STATE = dr.GetString("ERROR_STATE");
ErrorLog.ERROR_PROCEDURE = dr.GetString("ERROR_PROCEDURE");
ErrorLog.ERROR_LINE = dr.GetString("ERROR_LINE");
ErrorLog.ERROR_MESSAGE = dr.GetString("ERROR_MESSAGE");
ErrorLog.SCCode = dr.GetString("SCCode");
ErrorLog.ONDate = dr.GetString("ONDate");
ErrorLog.Client = dr.GetString("Client");
ErrorLog.FeeCode = dr.GetString("FeeCode");
ErrorLog.CREATEDATE = dr.GetDateTime("CREATEDATE").ToString("dd MMM yyyy hh:mm:ss tt");
}
private WOStatusAndAssignment FetchGroupHistory(WOStatusAndAssignment objAssignment, SafeDataReader dr)
{
objAssignment.WOCode = dr.GetString("WOCode");
objAssignment.GroupCode = dr.GetString("GroupCode");
objAssignment.AssignedBy = dr.GetString("CreatedBy");
objAssignment.DateForHistory = dr.GetDateTime("CreatedDate");
objAssignment.AssignedDate = objAssignment.DateForHistory.ToString("dd MMM yyyy hh:mm:ss tt");
return objAssignment;
}
internal void FetchErrorLogs(ErrorLogs ErrorLog, SafeDataReader dr)
{
ErrorLog.UserName = dr.GetString("UserName");
ErrorLog.PageName = dr.GetString("PageName");
ErrorLog.ErrorTime = dr.GetDateTime("ErrorTime").ToString("dd MMM yyyy hh:mm:ss tt");
ErrorLog.Browser = dr.GetString("Browser");
ErrorLog.IPAddress = dr.GetString("IPAddress");
ErrorLog.ErrorMessage = dr.GetString("ErrorMessage");
}
private WOStatusAndAssignment FetchStatusHistory(WOStatusAndAssignment objStatus, SafeDataReader dr)
{
objStatus.WOCode = dr.GetString("WOCode");
objStatus.StatusCode = dr.GetString("StatusCode");
objStatus.Comment = dr.GetString("Comment");
objStatus.DateForHistory = dr.GetDateTime("StatusDate");
objStatus.StatusDate = objStatus.DateForHistory.ToString("dd MMM yyyy hh:mm:ss tt");
objStatus.StatusName = dr.GetString("Name");
objStatus.AssignedBy = dr.GetString("AssignedBy");
return objStatus;
}
public CABBatch FetchGapInfo(CABBatch GapInfo, SafeDataReader dr)
{
GapInfo.SNO = dr.GetInt32("new_id");
GapInfo.FromDate = dr.GetDateTime("start_date").ToString("dd MMM yyyy");
GapInfo.ToDate = dr.GetDateTime("end_date").ToString("dd MMM yyyy");
GapInfo.Duration = dr.GetInt32("NoofDays");
return GapInfo;
}
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 WODuplicateDetails FetchWODuplicateShareHoldersDetails(WODuplicateDetails WODuplicateDetails, SafeDataReader dr)
{
WODuplicateDetails.ID = dr.GetInt32("ID");
WODuplicateDetails.Name = dr.GetString("Name");
WODuplicateDetails.CertNo = dr.GetString("CertNo");
WODuplicateDetails.NoofShares = dr.GetString("NoofShares");
//if NULL Displaying as "" in UI
WODuplicateDetails.DateOfIssue = dr.GetDateTime("DateOfIssue") == default(DateTime) ? string.Empty : dr.GetDateTime("DateOfIssue").ToString("dd/MM/yy");
WODuplicateDetails.NoOfNewCertToBeIssued = dr.GetInt32("NoOfNewCertToBeIssued");
return WODuplicateDetails;
}
private InCorpDetails FetchWOInCorp(InCorpDetails WOIncorpData, SafeDataReader dr)
{
WOIncorpData.WOID = dr.GetInt32("WOID");
WOIncorpData.CompanyName = dr.GetString("CompanyName");
WOIncorpData.ClientNo = dr.GetString("ClientNo");
WOIncorpData.ClientID = dr.GetInt32("ClientID");
WOIncorpData.ClientSource = dr.GetString("ClientSource");
WOIncorpData.IncropDate = dr.GetDateTime("IncropDate").ToString("dd/MM/yyyy") == "01/01/0001" ? "" : dr.GetDateTime("IncropDate").ToString("dd/MM/yyyy");
WOIncorpData.RegistrationNo = dr.GetString("RegistrationNo");
WOIncorpData.TypeofCompany = dr.GetString("TypeofCompany");
WOIncorpData.FMGasRegisteredAddress = dr.GetBoolean("FMGasRegisteredAddress");
WOIncorpData.AddressLine1 = dr.GetString("AddressLine1");
WOIncorpData.AddressLine2 = dr.GetString("AddressLine2");
WOIncorpData.AddressLine3 = dr.GetString("AddressLine3");
WOIncorpData.Country = dr.GetString("Country");
WOIncorpData.PostalCode = dr.GetString("PostalCode");
WOIncorpData.FinancialYearEnd = dr.GetDateTime("FinancialYearEnd").ToString("dd MMMM"); //== "01 January" ? "" : dr.GetDateTime("FinancialYearEnd").ToString("dd MMMM");
WOIncorpData.FirstFinancialYearEnd = dr.GetDateTime("FirstFinancialYearEnd").ToString("dd MMMM yyyy") == "01 January 0001" ? "" : dr.GetDateTime("FirstFinancialYearEnd").ToString("dd MMMM yyyy");
WOIncorpData.Currency = dr.GetString("Currency");
WOIncorpData.ClassofShare = dr.GetString("ClassofShare");
WOIncorpData.PaidupCapital = dr.GetDecimal("PaidupCapital");
WOIncorpData.AmountPaidupperShare = dr.GetDecimal("AmountPaidupperShare");
WOIncorpData.ActivityOne = dr.GetString("ActivityOne");
WOIncorpData.ActivityOneDescription = dr.GetString("ActivityOneDescription");
WOIncorpData.ActivityTwo = dr.GetString("ActivityTwo");
WOIncorpData.ActivityTwoDescription = dr.GetString("ActivityTwoDescription");
WOIncorpData.AmountGuaranteedByEachMember = dr.GetDecimal("AmountGuaranteedByEachMember");
WOIncorpData.GuaranteedAmountCurrency = dr.GetString("GuaranteedAmountCurrency");
WOIncorpData.FMGClient = dr.GetBoolean("FMGClient");
WOIncorpData.ClientType = dr.GetInt32("ClientType");
WOIncorpData.IncorporationCountry = dr.GetInt32("IncorporationCountry");
WOIncorpData.CompanyStatus = dr.GetInt32("CompanyStatus");
return WOIncorpData;
}