public RemarksRes GetRemarks(SearchFiltersReq req)
{
var data = new RemarksRes();
data = this._remarksCommand.GetRemarks(req);
return(data);
}
public SPRes GetSystemParameters(SearchFiltersReq req)
{
var data = new SPRes();
data = _sPCommand.GetSystemParameters(req);
return(data);
}
public AMRes GetAccountMaster(SearchFiltersReq req)
{
var data = new AMRes();
data = _aMCommand.GetAccountMaster(req);
return(data);
}
public SOWSearchResponse GetSOWs()
{
logger.Info(Environment.NewLine + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") + Environment.NewLine);
logger.Info(string.Format("{0}.{1} - START", this.GetType().Name, MethodBase.GetCurrentMethod().Name));
var requestHeader = Request;
var headers = requestHeader.Headers;
if (headers.Contains("esFilters"))
{
searchFilters = headers.GetValues("esFilters").First();
}
SearchFiltersReq req = Newtonsoft.Json.JsonConvert.DeserializeObject <SearchFiltersReq>(searchFilters);
SOWSearchResponse objRes = _sowMasterService.GetSOWs(req);
logger.Info(string.Format("{0}.{1} - END", this.GetType().Name, MethodBase.GetCurrentMethod().Name));
return(objRes);
}
public AMRes GetAccountMaster(SearchFiltersReq req)
{
var length = req.Filters.Count;
var dynamicWhereCondition = string.Empty;
for (var i = 0; i < length; i++)
{
var filterName = req.Filters[i].FilterName;
var filterValue = req.Filters[i].FilterValue;
var filterValueMatch = req.Filters[i].FilterValueMatch;
if (string.IsNullOrEmpty(filterName))
{
continue;
}
dynamicWhereCondition = dynamicWhereCondition + " AND " + "[" + filterName + "]";
if (filterValueMatch == "Exact")
{
dynamicWhereCondition = dynamicWhereCondition + " = '" + filterValue + "'";
}
else if (filterValueMatch == "LikeBefore")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "'";
}
else if (filterValueMatch == "LikeAfter")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '" + filterValue + "%'";
}
else if (filterValueMatch == "LikeBoth")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "%'";
}
}
var queryParameters = new DynamicParameters();
queryParameters.Add("@WhereConditions", dynamicWhereCondition);
var reader = SqlMapper.QueryMultiple(con, "dbo.sp_AccountMasterSelect", queryParameters, commandType: StoredProcedure);
var AccountMasterTableList = reader.Read <AccountMasterTable>().ToList();
var aMCount = AccountMasterTableList.Count;
AMRes aMResponse = new AMRes()
{
Response = new Response()
{
EsAccountMaster = new EsAccountMasterRes()
{
AccountMaster = new List <AccountMasterRes>(aMCount)
}
}
};
foreach (var item in AccountMasterTableList)
{
aMResponse.Response.EsAccountMaster.AccountMaster.Add(
new AccountMasterRes
{
AccountId = item.AccountId,
CustomerName = item.CustomerName,
CustomerLocation = item.CustomerLocation,
SOWAccountName = item.SOWAccountName,
DisplayName = item.DisplayName
});
}
var data = aMResponse;
return(data);
}
public SPRes GetSystemParameters(SearchFiltersReq req)
{
var length = req.Filters.Count;
var dynamicWhereCondition = string.Empty;
for (var i = 0; i < length; i++)
{
var filterName = req.Filters[i].FilterName;
var filterValue = req.Filters[i].FilterValue;
var filterValueMatch = req.Filters[i].FilterValueMatch;
if (string.IsNullOrEmpty(filterName))
{
continue;
}
dynamicWhereCondition = dynamicWhereCondition + " AND " + "[" + filterName + "]";
if (filterValueMatch == "Exact")
{
dynamicWhereCondition = dynamicWhereCondition + " = '" + filterValue + "'";
}
else if (filterValueMatch == "LikeBefore")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "'";
}
else if (filterValueMatch == "LikeAfter")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '" + filterValue + "%'";
}
else if (filterValueMatch == "LikeBoth")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "%'";
}
}
var queryParameters = new DynamicParameters();
queryParameters.Add("@WhereConditions", dynamicWhereCondition);
var reader = SqlMapper.QueryMultiple(con, "dbo.sp_SystemParametersSelect", queryParameters, commandType: StoredProcedure);
var SystemParametersTableList = reader.Read <SystemParametersTable>().ToList();
var aMCount = SystemParametersTableList.Count;
SPRes SPResponse = new SPRes()
{
Response = new Response()
{
EsSystemParameters = new EsSystemParametersRes()
{
SystemParameters = new List <SystemParametersRes>(aMCount)
}
}
};
foreach (var item in SystemParametersTableList)
{
SPResponse.Response.EsSystemParameters.SystemParameters.Add(
new SystemParametersRes
{
SystemParamId = item.SystemParamId,
Code = item.Code,
Name = item.Name,
Description = item.Description,
Active = item.Active
});
}
var data = SPResponse;
return(data);
}
public SOWSearchResponse GetSOWs(SearchFiltersReq req)
{
var length = req.Filters.Count;
var dynamicWhereCondition = string.Empty;
//Testing Code
//int ii = 1, ji = 0;
//var result = ii / ji;
for (var i = 0; i < length; i++)
{
var filterName = req.Filters[i].FilterName;
var filterValue = req.Filters[i].FilterValue;
var filterValueMatch = req.Filters[i].FilterValueMatch;
if (string.IsNullOrEmpty(filterName))
{
continue;
}
dynamicWhereCondition = dynamicWhereCondition + " AND " + "[" + filterName + "]";
if (filterValueMatch == "Exact")
{
dynamicWhereCondition = dynamicWhereCondition + " = '" + filterValue + "'";
}
else if (filterValueMatch == "LikeBefore")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "'";
}
else if (filterValueMatch == "LikeAfter")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '" + filterValue + "%'";
}
else if (filterValueMatch == "LikeBoth")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "%'";
}
}
var queryParameters = new DynamicParameters();
queryParameters.Add("@WhereConditions", dynamicWhereCondition);
var reader = SqlMapper.QueryMultiple(con, "dbo.sp_SOWMasterSelect", queryParameters, commandType: StoredProcedure);
var SOWMastersTableList = reader.Read <SOWMasterTable>().ToList();
var ResourceUtilizationDetailsTableList = reader.Read <ResourceUtilizationDetailsTable>().ToList();
var PricingScheduleDetailsTableList = reader.Read <PricingScheduleDetailsTable>().ToList();
var sowCount = SOWMastersTableList.Count;
SOWSearchResponse sOWSearchResponse = new SOWSearchResponse()
{
Request = new ResponseSR()
{
EsSOWMaster = new EsSOWMasterSR()
{
SOWMasters = new List <SOWMasterSR>(sowCount)
}
}
};
var listRow = 0;
foreach (var item in SOWMastersTableList)
{
sOWSearchResponse.Request.EsSOWMaster.SOWMasters.Add(
new SOWMasterSR
{
SOWId = item.SOWId,
SowNo = item.SOWNo,
SowDesc = item.SOWDesc,
SOWStartDate = item.StartDate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture),
SOWEndDate = item.EndDate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture),
PO = item.PO,
SOWType_SystemParamId = item.SOWType_SystemParamId,
ActionBySPOC = item.ActionBySPOC,
SOWAmount = item.SOWAmount,
AccountId = item.AccountId,
CustMgrId = item.CustMgrId,
Status_SystemParamId = item.Status_SystemParamId,
PartialBilliing = item.PartialBilliing,
FOC = item.FOC
});
sOWSearchResponse.Request.EsSOWMaster.SOWMasters[listRow].ResourceUtilizationDetails = new List <ResourceUtilizationDetailSearchResponse>();
foreach (var RUD in ResourceUtilizationDetailsTableList)
{
if (item.SOWId == RUD.SOWId)
{
sOWSearchResponse.Request.EsSOWMaster.SOWMasters[listRow].ResourceUtilizationDetails.Add(
new ResourceUtilizationDetailSearchResponse
{
ResourceUtilizationId = RUD.ResourceUtilizationId,
SOWId = RUD.SOWId,
ResourceId = RUD.ResourceId,
WorkOrderStartDate = RUD.WorkOrderStartDate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture),
WorkOrderEndDate = RUD.WorkOrderEndDate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture),
BenchStartDate = RUD.BenchStartDate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture),
BenchEndDate = RUD.BenchEndDate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture),
FoCStartDate = RUD.FoCStartDate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture),
FoCEndDate = RUD.FoCEndDate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture)
});
}
}
sOWSearchResponse.Request.EsSOWMaster.SOWMasters[listRow].PricingScheduleDetails = new List <PricingScheduleDetailSearchResponse>();
foreach (var PSD in PricingScheduleDetailsTableList)
{
if (item.SOWId == PSD.SOWId)
{
sOWSearchResponse.Request.EsSOWMaster.SOWMasters[listRow].PricingScheduleDetails.Add(
new PricingScheduleDetailSearchResponse
{
PricingSchId = PSD.PricingSchId,
SOWId = PSD.SOWId,
MonthName = PSD.MonthName,
BillableDays = PSD.BillableDays,
MilestoneName = PSD.MilestoneName,
MilestoneValue = PSD.MilestoneValue,
RevisionNumber = PSD.RevisionNumber,
RevisionDate = PSD.RevisionDate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture)
});
}
}
listRow++;
}
var data = sOWSearchResponse;
return(data);
}
public RemarksRes GetRemarks(SearchFiltersReq req)
{
var length = req.Filters.Count;
var dynamicWhereCondition = string.Empty;
for (var i = 0; i < length; i++)
{
var filterName = req.Filters[i].FilterName;
var filterValue = req.Filters[i].FilterValue;
var filterValueMatch = req.Filters[i].FilterValueMatch;
if (string.IsNullOrEmpty(filterName))
{
continue;
}
dynamicWhereCondition = dynamicWhereCondition + " AND " + "[" + filterName + "]";
if (filterValueMatch == "Exact")
{
dynamicWhereCondition = dynamicWhereCondition + " = '" + filterValue + "'";
}
else if (filterValueMatch == "LikeBefore")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "'";
}
else if (filterValueMatch == "LikeAfter")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '" + filterValue + "%'";
}
else if (filterValueMatch == "LikeBoth")
{
dynamicWhereCondition = dynamicWhereCondition + " LIKE '%" + filterValue + "%'";
}
}
var queryParameters = new DynamicParameters();
queryParameters.Add("@WhereConditions", dynamicWhereCondition);
var reader = SqlMapper.QueryMultiple(con, "dbo.sp_RemarksDetailsSelect", queryParameters, commandType: StoredProcedure);
var RemarksTableList = reader.Read <RemarksDetailsTable>().ToList();
var remarksCount = RemarksTableList.Count;
RemarksRes remarksResponse = new RemarksRes()
{
Response = new Response()
{
EsRemarks = new EsRemarksRes()
{
RemarksDetails = new List <RemarksDetailRes>(remarksCount)
}
}
};
foreach (var item in RemarksTableList)
{
remarksResponse.Response.EsRemarks.RemarksDetails.Add(
new RemarksDetailRes
{
RemarksId = item.RemarksId,
RemarksDetails = item.RemarksDetails,
Remarksdate = item.Remarksdate.ToString("dd-MM-yyyy", CultureInfo.InvariantCulture)
});
}
var data = remarksResponse;
return(data);
}
public SOWSearchResponse GetSOWs(SearchFiltersReq req)
{
return(this._sowMasterCommand.GetSOWs(req));
}
