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)); }