public ActionResult Report()
{
try{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
var categories = objdb.Master_Roles.Select(c => new
{
CategoryID = c.RoleID,
CategoryName = c.RoleName
}).ToList();
ViewBag.Categories = new MultiSelectList(categories, "CategoryID", "CategoryName");
List <DSRCManagementSystem.Models.ReportMOD> objmodel = new List <Models.ReportMOD>();
string constr = ConfigurationManager.AppSettings["connstr"];
DataTable dt = new DataTable();
SqlConnection objcon = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("Sp_Names", objcon);
cmd.CommandText = "Sp_Names";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adap = new SqlDataAdapter(cmd);
adap.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
DSRCManagementSystem.Models.ReportMOD obj = new DSRCManagementSystem.Models.ReportMOD();
obj.Name = dt.Rows[i]["SP"].ToString();
objmodel.Add(obj);
}
SelectList list = new SelectList(objmodel, "Name", "Name");
list.OrderBy(a => a);
ViewBag.Roles = 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(View());
}
public ActionResult EditRoll(int ReportID)
{
var ReportDetails = new ReportMOD();
List <DSRCManagementSystem.Models.ReportMOD> objmodel = new List <Models.ReportMOD>();
try
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
var Role = objdb.CustomReports_UserMapping.Where(x => x.ReportID == ReportID).Select(o => o.RoleID).ToList();
ViewBag.Role = Role;
var categories = objdb.Master_Roles.Select(c => new
{
CategoryID = c.RoleID,
CategoryName = c.RoleName
}).ToList();
ViewBag.Categories = new MultiSelectList(categories, "CategoryID", "CategoryName", Role);
Session["ReportID"] = ReportID;
//var RoleName=objdb.Master_Roles.Where(o=>o.RoleID==Role
//var Role = (from u in objdb.CustomReports_UserMapping
// where u.ReportID == ReportID
// select new
// {
// u.RoleID
// }).FirstOrDefault();
ReportDetails = (from u in objdb.CustomReports
where u.ReportID == ReportID
select new ReportMOD
{
rollid = u.ReportID,
Name = u.ReportName,
Description = u.ReportDescription,
sp = u.ReportQuery,
}).FirstOrDefault();
string constr = ConfigurationManager.AppSettings["connstr"];
DataTable dt = new DataTable();
SqlConnection objcon = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("Sp_Names", objcon);
cmd.CommandText = "Sp_Names";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adap = new SqlDataAdapter(cmd);
adap.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
DSRCManagementSystem.Models.ReportMOD obj = new DSRCManagementSystem.Models.ReportMOD();
obj.Name = dt.Rows[i]["SP"].ToString();
objmodel.Add(obj);
}
SelectList list = new SelectList(objmodel, "Name", "Name");
list.OrderBy(a => a);
ViewBag.Roles = 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(View(ReportDetails));
}