public ResultDTO GetSummaryReportByAccount(SummaryRequestDTO obj) { ResultDTO accInfo = new ResultDTO(); try { obj.StartList = Utilities.Common.GeStartListByYear(obj.YearList); obj.EndList = Utilities.Common.GeEndListByYear(obj.YearList); accInfo = _repository.GetSummaryReportByAccount(obj); } catch (Exception ex) { Utilities.AppLog.WriteLog("GetSummaryReportByAccount", ActionType.GetData, ex.Message.ToString(), obj.SessionKey); accInfo.StatusCode = Utilities.Common.ConvertErrorCodeToInt(RetCode.ECS9999); accInfo.StatusMsg = ex.Message.ToString(); } return(accInfo); }
public static ResultDTO GetSummaryReportByAccount(this IEntityBaseRepository <Affiliate> repository, SummaryRequestDTO obj) { var result = new ResultDTO(); var dbContext = new ApplicationContext(); var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output }; result.Details = dbContext.Database.SqlQuery <AffiliateOfMonthDTO>("EXEC [dbo].[sp_GetSummaryReportByAccount] @StartList,@EndList, @UserName,@SessionKey,@errorCode out", new SqlParameter("StartList", DB.SafeSQL(obj.StartList)), new SqlParameter("EndList", DB.SafeSQL(obj.EndList)), new SqlParameter("UserName", DB.SafeSQL(obj.UserName)), new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)), errorCode).ToList <AffiliateOfMonthDTO>(); result.StatusCode = int.Parse(errorCode.Value.ToString(), 0); result.SetContentMsg(); return(result); }
public HttpResponseMessage SummaryLeadsChartByAccount(HttpRequestMessage request, SummaryRequestDTO obj) { return(CreateHttpResponse(request, () => { HttpResponseMessage response; response = request.CreateResponse(HttpStatusCode.OK, _service.SummaryLeadsChartByAccount(obj)); return response; })); }
public static ResultDTO SummaryLeadsChartByAccount(this IEntityBaseRepository <Account> repository, SummaryRequestDTO obj) { var result = new ResultDTO(); var dbContext = new ApplicationContext(); var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output }; LeadsChartOfMonthDTO LeadsChart = new LeadsChartOfMonthDTO(); int f*g = 0; LeadsChart.EnrolledItems = dbContext.Database.SqlQuery <LeadsOfMonthDTO>("EXEC [dbo].[sp_SummaryLeadsChartByAccount] @LeadType,@FunnalID,@SoloID,@StartList,@EndList, @UserName,@SessionKey,@errorCode out", new SqlParameter("LeadType", f*g), new SqlParameter("FunnalID", obj.FunnalID), new SqlParameter("SoloID", obj.SoloID), new SqlParameter("StartList", DB.SafeSQL(obj.StartList)), new SqlParameter("EndList", DB.SafeSQL(obj.EndList)), new SqlParameter("UserName", DB.SafeSQL(obj.UserName)), new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)), errorCode).ToList <LeadsOfMonthDTO>(); f*g++; var errorCode1 = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output }; LeadsChart.ColdItems = dbContext.Database.SqlQuery <LeadsOfMonthDTO>("EXEC [dbo].[sp_SummaryLeadsChartByAccount] @LeadType,@FunnalID,@SoloID,@StartList,@EndList, @UserName,@SessionKey,@errorCode out", new SqlParameter("LeadType", f*g), new SqlParameter("FunnalID", obj.FunnalID), new SqlParameter("SoloID", obj.SoloID), new SqlParameter("StartList", DB.SafeSQL(obj.StartList)), new SqlParameter("EndList", DB.SafeSQL(obj.EndList)), new SqlParameter("UserName", DB.SafeSQL(obj.UserName)), new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)), errorCode1).ToList <LeadsOfMonthDTO>(); f*g++; var errorCode2 = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output }; LeadsChart.WarmItems = dbContext.Database.SqlQuery <LeadsOfMonthDTO>("EXEC [dbo].[sp_SummaryLeadsChartByAccount] @LeadType,@FunnalID,@SoloID,@StartList,@EndList, @UserName,@SessionKey,@errorCode out", new SqlParameter("LeadType", f*g), new SqlParameter("FunnalID", obj.FunnalID), new SqlParameter("SoloID", obj.SoloID), new SqlParameter("StartList", DB.SafeSQL(obj.StartList)), new SqlParameter("EndList", DB.SafeSQL(obj.EndList)), new SqlParameter("UserName", DB.SafeSQL(obj.UserName)), new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)), errorCode2).ToList <LeadsOfMonthDTO>(); f*g++; var errorCode3 = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output }; LeadsChart.HotItems = dbContext.Database.SqlQuery <LeadsOfMonthDTO>("EXEC [dbo].[sp_SummaryLeadsChartByAccount] @LeadType,@FunnalID,@SoloID,@StartList,@EndList, @UserName,@SessionKey,@errorCode out", new SqlParameter("LeadType", f*g), new SqlParameter("FunnalID", obj.FunnalID), new SqlParameter("SoloID", obj.SoloID), new SqlParameter("StartList", DB.SafeSQL(obj.StartList)), new SqlParameter("EndList", DB.SafeSQL(obj.EndList)), new SqlParameter("UserName", DB.SafeSQL(obj.UserName)), new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)), errorCode3).ToList <LeadsOfMonthDTO>(); result.Details = LeadsChart; result.StatusCode = int.Parse(errorCode.Value.ToString(), 0); result.SetContentMsg(); return(result); }