public ActionResult Report(ReportMOD model) { try{ DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); var Name = model.Name.Trim(); var checkname = objdb.CustomReports.Where(x => x.ReportName == Name && x.IsActive == true).Select(o => o.ReportID).FirstOrDefault(); if (checkname != 0) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } var Desc = ""; if (model.Description != null) { Desc = model.Description.Trim(); } var sp = model.sp; var userId = (int)Session["UserId"]; var ReturnDate = System.DateTime.Now; var roles = model.roles.Split(','); var Parameter = model.Parameter; DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var Assignobj = objdb.CustomReports.CreateObject(); Assignobj.ReportName = Name; Assignobj.ReportDescription = Desc; Assignobj.ReportQuery = sp; Assignobj.CreatedBy = Convert.ToString(userId); Assignobj.CreatedDate = ReturnDate; Assignobj.IsActive = true; objdb.CustomReports.AddObject(Assignobj); objdb.SaveChanges(); model.ReportID = Assignobj.ReportID; var roles1 = model.roles.Split(','); foreach (string userID in roles1) { var Function = objdb.CustomReports_UserMapping.CreateObject(); Function.ReportID = model.ReportID; Function.RoleID = Convert.ToInt32(userID); objdb.CustomReports_UserMapping.AddObject(Function); objdb.SaveChanges(); } } 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("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult EditRoll(ReportMOD model) { try { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); var Name = model.Name.Trim(); int Report = int.Parse(Session["ReportID"].ToString()); var data = objdb.CustomReports.Where(x => x.IsActive == true && x.ReportID != Report).Select(o => o.ReportName); foreach (var check in data) { if (check.ToLower() == Name.ToLower()) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } } var checkname = objdb.CustomReports.Where(x => x.ReportName == Name && x.IsActive == true && x.ReportID != Report).Select(o => o.ReportID).FirstOrDefault(); if (checkname != 0) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } var Desc = ""; if (model.Description != null) { Desc = model.Description.Trim(); } var Role = objdb.CustomReports_UserMapping.Where(x => x.ReportID == Report).Select(o => o.RoleID).ToList(); var sp = model.sp; var ReportID = (int)Session["UserId"]; var ReturnDate = System.DateTime.Now; var roles = model.roles.Split(','); var Parameter = model.Parameter; DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var Editroll = db.CustomReports.Where(q => q.ReportID == Report).Select(r => r).FirstOrDefault(); Editroll.ReportID = Report; Editroll.ReportName = model.Name; Editroll.ReportDescription = model.Description; Editroll.ReportQuery = model.sp; Editroll.CreatedBy = Convert.ToString(Report); Editroll.IsActive = true; db.SaveChanges(); var roles1 = model.roles.Split(','); foreach (string userID in roles1) { //var Function = objdb.CustomReports_UserMapping.CreateObject(); var Function = db.CustomReports_UserMapping.Where(q => q.ReportID == Report).Select(r => r).FirstOrDefault(); Function.ReportID = Report; Function.RoleID = Convert.ToInt32(userID); db.SaveChanges(); } } 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("Success", JsonRequestBehavior.AllowGet)); }
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)); }