/// <summary>
/// This method returns the pdf details of car from stored procedure based on requestID
/// </summary>
/// <param name="requestID"></param>
/// <returns></returns>
public CarApprovalModel GetPDFDetailsFromCAR(string requestID)
{
string callerMethodName = string.Empty;
try
{
//Get Caller Method name from CallerInformation class
callerMethodName = CallerInformation.TrackCallerMethodName();
CarApprovalModel ObjSA = null;
// Create an array list for storing parameters
ArrayList parameterArray = new ArrayList();
// Initialize a new sql parameter list
List <SqlParameter> sqlParameters = new List <SqlParameter>();
// Initialize a new sql parameters
SqlParameter pRequestID = new SqlParameter("@RequestID", requestID);
pRequestID.Direction = ParameterDirection.Input;
// Adding all sql parameters to sql parameter array
sqlParameters.Add(pRequestID);
// Open a new SQL Connection
sqldataProvider.OpenConnection(ConfigurationManager.ConnectionStrings["BakendAgentCarConnectionString"].ConnectionString);
// Execute stored procedure for fetching PDf details from CAR Backend.
DataSet dsPdfDetails = (DataSet)sqldataProvider.ExecuteDataSet(CommandType.StoredProcedure, ConfigurationManager.AppSettings["GetCarPDFDetailsSPName"], sqlParameters.ToArray());
CarSummary objCarbasicInfo = null;
//stored procedure returns two result sets
if (dsPdfDetails != null && dsPdfDetails.Tables.Count > 0)
{
//getting CARApprovalBasicInfo details from dataset table 1
if (dsPdfDetails.Tables[0] != null && dsPdfDetails.Tables[0].Rows.Count > 0)
{
DataRow row = dsPdfDetails.Tables[0].Rows[0];
objCarbasicInfo = new CarSummary()
{
Name = (!row.IsNull("Name")) ? Convert.ToString(row["Name"]) : string.Empty,
Description = (!row.IsNull("Description")) ? Convert.ToString(row["Description"]) : string.Empty,
Controller = (!row.IsNull("Controller") && !string.IsNullOrEmpty(Convert.ToString(row["Controller"]))) ? Convert.ToInt32(row["Controller"]) : 0,
Requestor = (!row.IsNull("Requestor") && !string.IsNullOrEmpty(Convert.ToString(row["Requestor"]))) ? Convert.ToInt32(row["Requestor"]) : 0,
DateofRequest = (!row.IsNull("DateofRequest") && !string.IsNullOrEmpty(Convert.ToString(row["DateofRequest"]))) ? Convert.ToDateTime(row["DateofRequest"]) : (DateTime?)null,
BrandDescription = (!row.IsNull("BrandDescription")) ? Convert.ToString(row["BrandDescription"]) : string.Empty,
CountryDescription = (!row.IsNull("CountryDescription")) ? Convert.ToString(row["CountryDescription"]) : string.Empty,
MarketDescription = (!row.IsNull("MarketDescription")) ? Convert.ToString(row["MarketDescription"]) : string.Empty,
InvestmentTypeDescription = (!row.IsNull("InvestmentTypeDescription")) ? Convert.ToString(row["InvestmentTypeDescription"]) : string.Empty,
EstimatedStartDate = (!row.IsNull("EstimatedStartDate") && !string.IsNullOrEmpty(Convert.ToString(row["EstimatedStartDate"]))) ? Convert.ToDateTime(row["EstimatedStartDate"]) : (DateTime?)null,
EstimatedCompletionDate = (!row.IsNull("EstimatedCompletionDate") && !string.IsNullOrEmpty(Convert.ToString(row["EstimatedCompletionDate"]))) ? Convert.ToDateTime(row["EstimatedCompletionDate"]) : (DateTime?)null,
Budgeted = (!row.IsNull("Budgeted") && !string.IsNullOrEmpty(Convert.ToString(row["Budgeted"]))) ? Convert.ToBoolean(Convert.ToInt32(row["Budgeted"])) : false,
Capex = (!row.IsNull("Capex") && !string.IsNullOrEmpty(Convert.ToString(row["Capex"]))) ? Convert.ToDecimal(row["Capex"]) : 0,
CapexLocal = (!row.IsNull("CapexLocal") && !string.IsNullOrEmpty(Convert.ToString(row["CapexLocal"]))) ? Convert.ToDecimal(row["CapexLocal"]) : 0,
SpenttodateEUR = (!row.IsNull("SpenttodateEUR") && !string.IsNullOrEmpty(Convert.ToString(row["SpenttodateEUR"]))) ? Convert.ToDecimal(row["SpenttodateEUR"]) : 0,
CAPEXThisRequest = (!row.IsNull("CAPEXthisrequest") && !string.IsNullOrEmpty(Convert.ToString(row["CAPEXthisrequest"]))) ? Convert.ToDecimal(row["CAPEXthisrequest"]) : 0,
LocalCurency = (!row.IsNull("LocalCurency") && !string.IsNullOrEmpty(Convert.ToString(row["LocalCurency"]))) ? Convert.ToInt32(row["LocalCurency"]) : 0,
AssetNo = (!row.IsNull("AssetNo")) ? Convert.ToString(row["AssetNo"]) : string.Empty,
CostCenterInternalOrder = (!row.IsNull("CostCenterInternalOrder")) ? Convert.ToString(row["CostCenterInternalOrder"]) : string.Empty,
IMSNumber = (!row.IsNull("IMSNumber") && !string.IsNullOrEmpty(Convert.ToString(row["IMSNumber"]))) ? Convert.ToInt32(row["IMSNumber"]) : 0,
CAPEXCodeGrape = (!row.IsNull("CAPEXCodeGrape")) ? Convert.ToString(row["CAPEXCodeGrape"]) : string.Empty,
FinanceLease = (!row.IsNull("FinanceLease") && !string.IsNullOrEmpty(Convert.ToString(row["FinanceLease"]))) ? Convert.ToBoolean(Convert.ToInt32(row["FinanceLease"])) : false,
ContractualObligation = (!row.IsNull("ContractualObligation") && !string.IsNullOrEmpty(Convert.ToString(row["ContractualObligation"]))) ? Convert.ToBoolean(Convert.ToInt32(row["ContractualObligation"])) : false,
PurchaseOption = (!row.IsNull("PurchaseOption") && !string.IsNullOrEmpty(Convert.ToString(row["PurchaseOption"]))) ? Convert.ToBoolean(Convert.ToInt32(row["PurchaseOption"])) : false,
GlobalRealEstate = (!row.IsNull("Budgeted") && !string.IsNullOrEmpty(Convert.ToString(row["GlobalRealEstate"]))) ? Convert.ToBoolean(Convert.ToInt32(row["GlobalRealEstate"])) : false,
NoOfYears = (!row.IsNull("NoOfYears") && !string.IsNullOrEmpty(Convert.ToString(row["NoOfYears"]))) ? Convert.ToInt32(row["NoOfYears"]) : 0,
};
}
//getting CarCapexMatrix details from dataset table 2
//writing it into CarCapexMatrixlist
List <CarCapexMatrix> lstCarCapexmatrix = null;
if (dsPdfDetails.Tables[1] != null && dsPdfDetails.Tables[1].Rows.Count > 0)
{
lstCarCapexmatrix = dsPdfDetails.Tables[1].AsEnumerable().Select(row =>
new CarCapexMatrix
{
CapexMatricDescription = row.Field <string>("Description"),
Y1 = row.Field <decimal>("Y1"),
Y2 = row.Field <decimal>("Y2"),
Y3 = row.Field <decimal>("Y3"),
TotalSum = row.Field <decimal>("TotalSum")
}).ToList();
}
//clone CAR pdf details into CarApprovalModel class
ObjSA = new CarApprovalModel()
{
CarBasicInformation = objCarbasicInfo,
CarCapexMatrixDetails = lstCarCapexmatrix
};
}
return(ObjSA);
}
catch (Exception exception)
{
InsightLogger.Exception(exception.Message, exception, callerMethodName);
throw new DataAccessException(exception.Message, exception.InnerException);
}
}
/// <summary>
/// This method returns the pdf details of car from stored procedure based on requestID
/// </summary>
/// <param name="requestID"></param>
/// <returns></returns>
public CarApprovalModel GetPDFDetailsFromCAR(string requestID, string backendID)
{
string callerMethodName = string.Empty;
try
{
//Get Caller Method name from CallerInformation class
callerMethodName = CallerInformation.TrackCallerMethodName();
CarApprovalModel ObjSA = null;
// Create an array list for storing parameters
ArrayList parameterArray = new ArrayList();
// Initialize a new sql parameter list
List <SqlParameter> sqlParameters = new List <SqlParameter>();
// Initialize a new sql parameters
SqlParameter pRequestID = new SqlParameter("@RequestID", requestID);
pRequestID.Direction = ParameterDirection.Input;
// Adding all sql parameters to sql parameter array
sqlParameters.Add(pRequestID);
// Open a new SQL Connection
sqldataProvider.OpenConnection(ConfigurationManager.ConnectionStrings["BakendAgentCarConnectionString"].ConnectionString);
// Execute stored procedure for fetching PDf details from CAR Backend.
DataSet dsPdfDetails = (DataSet)sqldataProvider.ExecuteDataSet(CommandType.StoredProcedure, ConfigurationManager.AppSettings["GetCarPDFDetailsSPName"], sqlParameters.ToArray());
// CarSummary objCarbasicInfo = null;
Dictionary <string, object> objReqDetails = null;
//stored procedure returns two result sets
if (dsPdfDetails != null && dsPdfDetails.Tables.Count > 0)
{
FieldsMapping objFieldsMap = new FieldsMapping();
//call FieldsMapping.GetFiledsMappingJsonString() method which will return RequestFieldsMappingJson,ApproverFieldsMappingJson
MappingTypes ObjMaps = objFieldsMap.GetFiledsMappingJsonString(backendID);
//getting CARApprovalBasicInfo details from dataset table 1
if (dsPdfDetails.Tables[0] != null && dsPdfDetails.Tables[0].Rows.Count > 0)
{
DataRow row = dsPdfDetails.Tables[0].Rows[0];
//Call FieldsMapping.MapDtFieldstoBackendRequest() method, which returns Mapping request details to RequestDetailsMapping class object
//CarSummary objReqDetails = objFieldsMap.MapDtFieldstoBackendRequest<CarSummary>(row, ObjMaps.RequestFieldsMappingJson);
//objCarbasicInfo = new CarSummary()
//{
// Name = (!string.IsNullOrEmpty(objReqDetails.Name)) ? objReqDetails.Name : string.Empty,
// Description = (!string.IsNullOrEmpty(objReqDetails.Description)) ? objReqDetails.Description : string.Empty,
// Controller = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.Controller))) ? Convert.ToInt32(objReqDetails.Controller) : 0,
// Requestor = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.Requestor))) ? Convert.ToInt32(objReqDetails.Requestor) : 0,
// DateofRequest= (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.DateofRequest))) ? Convert.ToDateTime(objReqDetails.DateofRequest) : (DateTime?)null,
// BrandDescription = (!string.IsNullOrEmpty(objReqDetails.BrandDescription)) ? objReqDetails.BrandDescription : string.Empty,
// CountryDescription = (!string.IsNullOrEmpty(objReqDetails.CountryDescription)) ? objReqDetails.CountryDescription : string.Empty,
// MarketDescription = (!string.IsNullOrEmpty(objReqDetails.MarketDescription)) ? objReqDetails.MarketDescription : string.Empty,
// InvestmentTypeDescription = (!string.IsNullOrEmpty(objReqDetails.InvestmentTypeDescription)) ? objReqDetails.InvestmentTypeDescription : string.Empty,
// EstimatedStartDate = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.EstimatedStartDate))) ? Convert.ToDateTime(objReqDetails.EstimatedStartDate) : (DateTime?)null,
// EstimatedCompletionDate = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.EstimatedCompletionDate))) ? Convert.ToDateTime(objReqDetails.EstimatedCompletionDate) : (DateTime?)null,
// Budgeted= (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.Budgeted))) ? Convert.ToBoolean(Convert.ToInt32(objReqDetails.Budgeted)) : false,
// Capex = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.Capex))) ? Convert.ToDecimal(objReqDetails.Capex) : 0,
// CapexLocal = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.CapexLocal))) ? Convert.ToDecimal(objReqDetails.CapexLocal) : 0,
// SpenttodateEUR = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.SpenttodateEUR))) ? Convert.ToDecimal(objReqDetails.SpenttodateEUR) : 0,
// CAPEXThisRequest = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.CAPEXThisRequest))) ? Convert.ToDecimal(objReqDetails.CAPEXThisRequest) : 0,
// LocalCurency = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.LocalCurency))) ? Convert.ToInt32(objReqDetails.LocalCurency) : 0,
// AssetNo = (!string.IsNullOrEmpty(objReqDetails.AssetNo)) ? Convert.ToString(objReqDetails.AssetNo) : string.Empty,
// CostCenterInternalOrder = (!string.IsNullOrEmpty(objReqDetails.CostCenterInternalOrder)) ? Convert.ToString(objReqDetails.CostCenterInternalOrder) : string.Empty,
// IMSNumber = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.IMSNumber))) ? Convert.ToInt32(objReqDetails.IMSNumber) : 0,
// CAPEXCodeGrape = (!string.IsNullOrEmpty(objReqDetails.CAPEXCodeGrape))?objReqDetails.CAPEXCodeGrape : string.Empty,
// FinanceLease = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.FinanceLease))) ? Convert.ToBoolean(Convert.ToInt32(objReqDetails.FinanceLease)) : false,
// ContractualObligation = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.ContractualObligation))) ? Convert.ToBoolean(Convert.ToInt32(objReqDetails.ContractualObligation)) : false,
// PurchaseOption = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.PurchaseOption))) ? Convert.ToBoolean(Convert.ToInt32(objReqDetails.PurchaseOption)) : false,
// GlobalRealEstate = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.GlobalRealEstate))) ? Convert.ToBoolean(Convert.ToInt32(objReqDetails.GlobalRealEstate)) : false,
// NoOfYears = (!string.IsNullOrEmpty(Convert.ToString(objReqDetails.NoOfYears))) ? Convert.ToInt32(objReqDetails.NoOfYears) : 0,
//};
objReqDetails = objFieldsMap.MapDBFieldstoBackendRequest(row, ObjMaps.RequestFieldsMappingJson);
}
//getting CarCapexMatrix details from dataset table 2
//writing it into CarCapexMatrixlist
List <CarCapexMatrix> lstCarCapexmatrix = null;
if (dsPdfDetails.Tables[1] != null && dsPdfDetails.Tables[1].Rows.Count > 0)
{
//call FieldsMapping.MapApproverFieldstoBackendRequest() method, which returns list of approver details after Mapping into ApproverFeildsMapping class object
lstCarCapexmatrix = objFieldsMap.MapApproverFieldstoBackendRequest <CarCapexMatrix>(dsPdfDetails.Tables[1], ObjMaps.MatrixFieldsMappingJson);
//lstCarCapexmatrix = dsPdfDetails.Tables[1].AsEnumerable().Select(row =>
// new CarCapexMatrix
// {
// CapexMatricDescription = row.Field<string>("Description"),
// Y1 = row.Field<decimal>("Y1"),
// Y2 = row.Field<decimal>("Y2"),
// Y3 = row.Field<decimal>("Y3"),
// TotalSum = row.Field<decimal>("TotalSum")
// }).ToList();
}
//clone CAR pdf details into CarApprovalModel class
ObjSA = new CarApprovalModel()
{
CarBasicInformation = objReqDetails,
CarCapexMatrixDetails = lstCarCapexmatrix
};
}
return(ObjSA);
}
catch (Exception exception)
{
InsightLogger.Exception(exception.Message, exception, callerMethodName);
throw new DataAccessException(exception.Message, exception.InnerException);
}
}
