public ResponseModel DashBoardGraphData(string BrandID, string UserIds, string fromdate, string todate)
{
ResponseModel objResponseModel = new ResponseModel();
DashBoardGraphModel db = new DashBoardGraphModel();
int statusCode = 0;
string statusMessage = "";
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
DashBoardCaller dCaller = new DashBoardCaller();
var temp = SecurityService.DecryptStringAES(token);
authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token));
db = dCaller.GetDashBoardGraphdata(new DashBoardService(Cache, Db), BrandID, UserIds, fromdate, todate, authenticate.TenantId);
statusCode = db == null ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success;
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = db;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
/// <summary>
/// Load Dashboard Graph Data
/// </summary>
public DashBoardGraphModel GetDashBoardGraphdata(string BrandID, string UserID, string fromdate, string todate, int TenantID)
{
DataSet Graphds = new DataSet();
MySqlCommand cmd = new MySqlCommand();
MySqlDataAdapter da = new MySqlDataAdapter();
DashBoardGraphModel dashBoardGraphdata = new DashBoardGraphModel();
List <OpenByPriorityModel> OpenPriorityTktList = new List <OpenByPriorityModel>();
try
{
if (conn != null && conn.State == ConnectionState.Closed)
{
conn = Db.Connection;
}
if (conn != null && conn.State == ConnectionState.Closed)
{
conn.Open();
}
#region DashBoardGraph Data
MySqlCommand cmd1 = new MySqlCommand("Sp_DashBoardGraphData", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@_BrandID", string.IsNullOrEmpty(BrandID) ? "" : BrandID);
cmd1.Parameters.AddWithValue("_userid", string.IsNullOrEmpty(UserID) ? "" : UserID);
cmd1.Parameters.AddWithValue("_tenantID", TenantID);
cmd1.Parameters.AddWithValue("_fromdate", fromdate);
cmd1.Parameters.AddWithValue("_todate", todate);
da = new MySqlDataAdapter();
da.SelectCommand = cmd1;
da.Fill(Graphds);
if (Graphds != null && Graphds.Tables.Count > 0)
{
if (Graphds.Tables[0].Rows.Count > 0) //PriorityGraph
{
dashBoardGraphdata.PriorityChart = Graphds.Tables[0].AsEnumerable().Select(r => new OpenByPriorityModel()
{
priorityID = r.Field <object>("PriorityID") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("PriorityID")),
priorityName = r.Field <object>("PriortyName") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("PriortyName")),
priorityCount = r.Field <object>("PriorityCount") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("PriorityCount")),
}).ToList();
dashBoardGraphdata.OpenPriorityTicketCount = dashBoardGraphdata.PriorityChart.Count > 0 ?
dashBoardGraphdata.PriorityChart.Sum(x => x.priorityCount) : 0;
}
if (Graphds.Tables[1].Rows.Count > 0) //Ticket To Bill
{
dashBoardGraphdata.tickettoBillGraph = Graphds.Tables[1].AsEnumerable().Select(r => new TicketToBillGraphModel()
{
ticketSourceID = r.Field <object>("TicketSourceID") == System.DBNull.Value ? 0: Convert.ToInt32(r.Field <object>("TicketSourceID")),
ticketSourceName = r.Field <object>("TicketSourceName") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("TicketSourceName")),
totalBills = r.Field <object>("TotalBills") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("TotalBills")),
ticketedBills = r.Field <object>("TicketedBills") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("TicketedBills"))
}).ToList();
}
if (Graphds.Tables[2].Rows.Count > 0) //Ticket Generation Source
{
dashBoardGraphdata.ticketSourceGraph = Graphds.Tables[2].AsEnumerable().Select(r => new TicketSourceModel()
{
ticketSourceID = r.Field <object>("TicketSourceID") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("TicketSourceID")),
ticketSourceName = r.Field <object>("TicketSourceName") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("TicketSourceName")),
ticketSourceCount = r.Field <object>("TicketSourceCount") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("TicketSourceCount"))
}).ToList();
}
if (Graphds.Tables[3].Rows.Count > 0) //Ticket TO Task
{
dashBoardGraphdata.tickettoTaskGraph = Graphds.Tables[3].AsEnumerable().Select(r => new TicketToTask()
{
totalTickets = r.Field <object>("AllTicket") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("AllTicket")),
taskTickets = r.Field <object>("Task") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("Task")),
Day = r.Field <object>("AllDay") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("AllDay"))
}).ToList();
}
if (Graphds.Tables[4].Rows.Count > 0) //Ticket TO Claim
{
dashBoardGraphdata.tickettoClaimGraph = Graphds.Tables[4].AsEnumerable().Select(r => new TicketToClaim()
{
totalTickets = r.Field <object>("AllTicket") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("AllTicket")),
ClaimTickets = r.Field <object>("Claim") == System.DBNull.Value ? 0 : Convert.ToInt32(r.Field <object>("Claim")),
Day = r.Field <object>("AllDay") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("AllDay"))
}).ToList();
}
}
#endregion
}
catch (Exception ex)
{
throw ex;
}
return(dashBoardGraphdata);
}
