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");
}
private Vendor FetchUnMatchedVendorDetails(Vendor vendor, SafeDataReader dr)
{
vendor.Date = dr.GetString("TransactionDate");
vendor.UsedBy = dr.GetString("UsedBy");
vendor.Description = dr.GetString("Description");
vendor.VenderReferenceID = dr.GetString("VENDORREF");
vendor.VendorAmount = dr.GetDecimal("VENDORAMOUNT");
vendor.VRID = dr.GetInt32("VRID");
vendor.VRDID = dr.GetInt32("VRDID");
return vendor;
}
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 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 FetchService(Vendor vendor, SafeDataReader dr)
{
vendor.Type = dr.GetString("Type");
vendor.UploadedOn = dr.GetString("UploadedOn");
vendor.Username = dr.GetString("Name");
vendor.VRID = dr.GetInt32("VRID");
vendor.Name = dr.GetString("FileName");
return vendor;
}
private MenuBinding FetchMenu(MenuBinding MenuBinding, SafeDataReader dr)
{
MenuBinding.MainMenuID = dr.GetString("MainMenuID");
MenuBinding.MainMenuClass = dr.GetString("MainMenuClass");
MenuBinding.MainMenuName = dr.GetString("MainMenuName");
MenuBinding.SubMenuID = dr.GetString("SubMenuID");
MenuBinding.SubMenuName = dr.GetString("SubMenuName");
MenuBinding.URL = dr.GetString("URL");
return MenuBinding;
}
private Vendor FetchVendorReportType1(Vendor vendor, SafeDataReader dr)
{
vendor.Code = dr.GetString("Code");
vendor.Name = dr.GetString("Name");
vendor.Username = dr.GetString("Username");
vendor.UploadedOn = dr.GetString("UploadedOn");
return vendor;
}
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;
}
private static CABBatch FetchBATCHType(CABBatch CABBatch, SafeDataReader dr)
{
CABBatch.BatchCode = dr.GetString("BatchCode");
CABBatch.Name = dr.GetString("Name");
return CABBatch;
}
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 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;
}
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");
}
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 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 _ChoosenClient FetchClientInfo(_ChoosenClient getClientInfo, SafeDataReader dr)
{
getClientInfo.ClientCode = dr.GetString("ID");
getClientInfo.ClientName = dr.GetString("Name");
getClientInfo.SourceID = dr.GetString("SourceCode");
getClientInfo.UniqueID = dr.GetInt32("UniqueID");
return getClientInfo;
}
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;
}
///// <summary>
///// Description : To Check Url Access
///// Created By : Pavan
///// Created Date : 16 September 2014
///// Modified By :
///// Modified Date :
///// <returns></returns>
///// </summary>
//public static int CheckURLAccess(string context, int UserID)
//{
// List<string> arr = new List<string>();
// SqlParameter[] sqlParams = new SqlParameter[3];
// sqlParams[0] = new SqlParameter("@UserID", UserID);
// sqlParams[1] = new SqlParameter("@RequestedUrl", context);
// sqlParams[2] = new SqlParameter("@Output", 0);
// sqlParams[2].Direction = ParameterDirection.Output;
// var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpCheckURLAccessForUserID", sqlParams);
// var safe = new SafeDataReader(reader);
// while (reader.Read())
// {
// arr.Add(safe.GetString("FieldName"));
// }
// int output = Convert.ToInt32(sqlParams[2].Value);
// return output;
//}
/// <summary>
/// Description : To Check Url Access
/// Created By : Pavan
/// Created Date : 16 September 2014
/// Modified By :
/// Modified Date :
/// <returns></returns>
/// </summary>
public static string CheckURlAndGetUserRole(string context, int UserID)
{
string Roles = string.Empty;
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
string Result = string.Empty;
SqlParameter[] sqlParams = new SqlParameter[2];
sqlParams[0] = new SqlParameter("@UserID", UserID);
sqlParams[1] = new SqlParameter("@RequestedUrl", context);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpCheckURLAccessForUserID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
Result = (safe.GetString("Result"));
}
string[] output = Result.Split(',');
for (int i = 0; i < output.Length; i++)
{
if (Roles == string.Empty)
{
Roles = Enum.GetName(typeof(UserType), Convert.ToInt32(output[i]));
}
else
{
Roles = Roles + ',' + Enum.GetName(typeof(UserType), Convert.ToInt32(output[i]));
}
}
Roles = Roles.EndsWith(",") ? Roles.Substring(0, Roles.Length - 1) : Roles;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
}
finally
{
log.Debug("End: " + methodBase.Name);
}
return Roles;
}
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 Vendor FetchVendorReportType(Vendor vendor, SafeDataReader dr)
{
vendor.Code = dr.GetString("Code");
vendor.Name = dr.GetString("Name");
return vendor;
}
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 Vendor FetchErrorList(Vendor vendor, SafeDataReader dr)
{
vendor.VRID = dr.GetInt32("VRID");
vendor.UploadedOn = dr.GetString("TransationDate");
vendor.Code = dr.GetString("Description");
vendor.VenderReferenceID = dr.GetString("ReferenceNo");
vendor.ItemNumber = dr.GetString("Amount");
return vendor;
}
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;
}
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;
}
private TemplateMapping FetchTemplateMDocMultipleEntity(TemplateMapping TMapping, SafeDataReader dr)
{
TMapping.EntityName = dr.GetString("EntityName");
TMapping.DisplayName = dr.GetString("DisplayName");
return TMapping;
}
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 TemplateMapping FetchTemplateSetDetails(TemplateMapping TMapping, SafeDataReader dr)
{
TMapping.SetID = dr.GetInt32("SetID");
TMapping.SetName = dr.GetString("SetName");
TMapping.FilePath = dr.GetString("FilePath");
return TMapping;
}
private WODuplicateDetails FetchWODuplicateDetails(WODuplicateDetails WODuplicateDetails, SafeDataReader dr)
{
WODuplicateDetails.WOID = dr.GetString("WOID");
WODuplicateDetails.ClassOfShare = dr.GetInt32("ClassOfShare");
return WODuplicateDetails;
}
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 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;
}
internal static void FetchAllTableNames(SelectListItem Table, SafeDataReader dr)
{
Table.Text = dr.GetString("Name");
}