public ActionResult DashBoard(CustomReports obj, FormCollection form, string Column)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
List <DSRCManagementSystem.Models.CustomReports> value = new List <DSRCManagementSystem.Models.CustomReports>();
List <DSRCManagementSystem.Models.CustomReports> Report = new List <DSRCManagementSystem.Models.CustomReports>();
List <DSRCManagementSystem.Models.CustomReports> ExportValue = new List <DSRCManagementSystem.Models.CustomReports>();
TempData["Column"] = Column;
ViewBag.Column = Column;
int roleid = Convert.ToInt32(Session["RoleID"]);
try
{
if (Column == null)
{
string CusReportId = (form["Id3"] == "") ? "0" : form["Id3"].ToString();
int cusId = Convert.ToInt32(CusReportId);
var Id =
objdb.CustomReports.Where(x => x.ReportID == cusId && x.IsActive == true)
.Select(o => o.ReportQuery)
.FirstOrDefault();
string ZoneId = Id;
var temp = objdb.CustomReports.Where(r => r.ReportQuery == Id).Select(f => f.ReportName).ToList();
foreach (var list in temp)
{
ViewBag.ReportName = list;
}
if (CusReportId == Convert.ToString(0))
{
var Purpose = (from cr in objdb.CustomReports
join cru in objdb.CustomReports_UserMapping on cr.ReportID equals cru.ReportID
where (cru.RoleID == roleid && cr.IsActive == true)
select new
{
ReportID = cr.ReportID,
ReportName = cr.ReportName
}).ToList();
ViewBag.Purpose = new SelectList(Purpose, "ReportID", "ReportName", 0);
ModelState.AddModelError("RoleName", "Select Report Name");
}
TempData["cusId"] = cusId;
TempData["ReportID"] = ZoneId;
if (CusReportId != Convert.ToString(0))
{
List <string> Parameter = new List <string>();
List <string> value1 = objdb.SP_GetName(Id).ToList();
foreach (var s in value1)
{
DSRCManagementSystem.Models.CustomReports ob =
new DSRCManagementSystem.Models.CustomReports();
var trims = s.TrimStart('@');
var newValue = trims.Substring(trims.IndexOf('_') + 1);
var trim = Regex.Replace(newValue, "([a-z])([A-Z])", "$1 $2");
ob.CustomName = trim;
value.Add(ob);
Parameter.Add(ob.CustomName);
}
ViewData["Parameter"] = Parameter;
ViewBag.Id = value;
string id1 = Id;
if (value.Count() == 0)
{
var pose = (from cr in objdb.CustomReports
join cru in objdb.CustomReports_UserMapping on cr.ReportID equals cru.ReportID
where (cru.RoleID == roleid && cr.IsActive == true)
select new
{
ReportID = cr.ReportID,
ReportName = cr.ReportName
}).ToList();
ViewBag.Purpose = new SelectList(pose, "ReportID", "ReportName", cusId);
string constr = ConfigurationManager.AppSettings["connstr"];
DataSet ds = new DataSet();
SqlConnection objcon = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(id1, objcon);
cmd.CommandText = id1;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adap = new SqlDataAdapter(cmd);
adap.Fill(ds);
List <object> chartData = new List <object>();
List <DSRCManagementSystem.Models.CustomReports> value5 =
new List <DSRCManagementSystem.Models.CustomReports>();
List <object> Listvalue = new List <object>();
List <object> Val = new List <object>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
DSRCManagementSystem.Models.CustomReports ob =
new DSRCManagementSystem.Models.CustomReports();
Array x = dr.ItemArray;
ob.ReportName1 = x;
Listvalue.Add(ob.ReportName1);
chartData.Add(new object[]
{
dr[0]
});
ExportValue.Add(ob);
}
foreach (DataColumn dr in ds.Tables[0].Columns)
{
DSRCManagementSystem.Models.CustomReports ob1 =
new DSRCManagementSystem.Models.CustomReports();
ob1.CustomNameId = dr.ColumnName;
Val.Add(ob1.CustomNameId);
}
ViewBag.Val = Val;
ViewBag.ListValue = Listvalue;
ViewBag.data = chartData;
return(View(ExportValue));
}
var Purpose = (from cr in objdb.CustomReports
join cru in objdb.CustomReports_UserMapping on cr.ReportID equals cru.ReportID
where (cru.RoleID == roleid && cr.IsActive == true)
select new
{
ReportID = cr.ReportID,
ReportName = cr.ReportName
}).ToList();
foreach (var item in value)
{
ViewBag.Purpose = new SelectList(Purpose, "ReportID", "ReportName", cusId);
}
}
}
}
catch (Exception Ex)
{
//string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
//string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
//ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
//return Json("Warning", JsonRequestBehavior.AllowGet);
ModelState.AddModelError("RoleName", "Stored Procedure Was Not Supported ");
}
try
{
if (Column != null)
{
string Id = Convert.ToString(TempData["ReportID"]);
List <string> value1 = objdb.SP_GetName(Id).ToList();
foreach (var s in value1)
{
DSRCManagementSystem.Models.CustomReports ob = new DSRCManagementSystem.Models.CustomReports();
ob.CustomName = s;
value.Add(ob);
}
ViewBag.Id = value;
string values = string.Empty;
List <string> objuser = new List <string>();
string[] value2 = Column.Split(',');
for (int k = 0; k < value2.Count(); k++)
{
if (value2[k] != "")
{
objuser.Add(value2[k].Replace(",", "''"));
}
}
var pose = (from pi in objdb.CustomReports
select new
{
Id3 = pi.ReportQuery,
Template = pi.ReportName
}).ToList();
ViewBag.Purpose = new SelectList(pose, "Id3", "Template");
string constr1 = ConfigurationManager.AppSettings["connstr"];
DataSet ds1 = new DataSet();
SqlConnection objcon1 = new SqlConnection(constr1);
SqlCommand cmd1 = new SqlCommand(Id, objcon1);
TempData["ReportID"] = ds1;
int i = 0;
foreach (var s in value1)
{
cmd1.Parameters.Add(s, SqlDbType.VarChar).Value = value2[i];
i++;
}
cmd1.CommandText = Id; // Stored procedure name
cmd1.CommandType = CommandType.StoredProcedure; // set it to stored proc
SqlDataAdapter adap1 = new SqlDataAdapter(cmd1);
adap1.Fill(ds1);
TempData["ID"] = adap1;
List <object> chartData = new List <object>();
List <object> List = new List <object>();
List <object> valueList = new List <object>();
foreach (DataRow dr in ds1.Tables[0].Rows)
{
DSRCManagementSystem.Models.CustomReports ob = new DSRCManagementSystem.Models.CustomReports();
Array column = dr.ItemArray;
ob.ReportName1 = column;
List.Add(ob.ReportName1);
Report.Add(ob);
}
foreach (DataColumn dr in ds1.Tables[0].Columns)
{
DSRCManagementSystem.Models.CustomReports ob1 = new DSRCManagementSystem.Models.CustomReports();
ob1.CustomNameId = dr.ColumnName;
valueList.Add(ob1.CustomNameId);
}
ViewBag.List = Report.ToList();
TempData["Value"] = Report.ToList();
TempData["List"] = ViewBag.Val = valueList;
TempData["ReportIDs"] = TempData["cusId"];
ViewBag.Val = valueList;
ViewBag.ListValue = List;
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
return(Json("Warning", JsonRequestBehavior.AllowGet));
}
var userid = Convert.ToInt32(Session["UserID"]);
ViewBag.permission = (from p in objdb.ReportsPermissions
where p.UserId == userid && p.IsAuthorized == true
select p.UserId).SingleOrDefault();
ViewBag.UserID = Convert.ToInt32(Session["UserID"]);
return(View(value));
}