public KeyValuePair <int, String> ReportRoleNew_Insert(ReportRoleNew model) { var param = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier) { Value = model.ID }, new SqlParameter("@ReportID", SqlDbType.UniqueIdentifier) { Value = model.ReportID }, new SqlParameter("@SecurityRoleId", SqlDbType.UniqueIdentifier) { Value = model.SecurityRoleId }, new SqlParameter("@RetVal", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@Message", SqlDbType.NVarChar, 100) { Direction = ParameterDirection.Output } }; int rc = ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreCommand("exec [rpt].[ReportRole_Insert] @ID, @ReportID, @SecurityRoleId, @RetVal OUTPUT, @Message OUTPUT", param); int retVal = (int)param[3].Value; string valueRes = param[4].Value.ToString(); return(new KeyValuePair <int, string>(retVal, valueRes)); }
public ActionResult Delete() { ReportRoleNew model = new ReportRoleNew(); string ReportID = Request["reportid"]; model.ReportID = new Guid(ReportID); model.ID = new Guid(Request["ID"]); return(formSubmit(model, "Delete")); }
public ActionResult Execute(ReportRoleNew model, string action) { KeyValuePair <int, string> results = new KeyValuePair <int, string>(1, ""); string message = Resources.ReportRole.ReportRoleSuccess; if (action == "Create") { if (db.reportRoleNew.Where(x => x.SecurityRoleId == model.SecurityRoleId).Where(x => x.ReportID == model.ReportID).Count() > 0) { var jsonData = new { flag = false, Message = Resources.ReportRole.ReportRoleSame }; return(Json(jsonData)); } } if (action == "Delete") { message = Resources.NotifResource.PrivilegeExceptionDelSuccess; } switch (action) { case "Delete": results = db.ReportRoleNew_Delete(model); break; case "Create": model.ID = Guid.NewGuid(); results = db.ReportRoleNew_Insert(model); break; } if (results.Key == 0 || results.Key == 16 || results.Key == 6) { var jsonData = new { flag = true, Message = message }; return(Json(jsonData)); } else { var jsonData = new { flag = false, Message = results.Value.ToString() }; return(Json(jsonData)); } }
public ActionResult Create() { ReportRoleNew model = new ReportRoleNew(); string ReportID = Request["reportid"]; string id = Request["ID"]; model.ReportID = new Guid(ReportID); model.SecurityRoleId = new Guid(id); var check = db.reportRoleView .Where(x => x.ReportID == model.ReportID) .Where(x => x.SecurityRoleId == model.SecurityRoleId); if (check.Count() > 0) { var jsonData = new { flag = false, Message = "Report sudah mendapatkan akses untuk Report ini." }; return(Json(jsonData)); } return(formSubmit(model, "Create")); }
public ActionResult formSubmit(ReportRoleNew model, string actionType) { List <string> errorMessage = new List <string>(); string successMessage = Resources.NotifResource.DataSuccess; SessionForSP sessionParam = new SessionForSP(); sessionParam.CurrentUserID = new Guid(Session["CurrentUserID"].ToString()); if (ModelState.IsValid) { KeyValuePair <int, string> results = new KeyValuePair <int, string>(1, ""); // model.ModifiedBy = new Guid(Session["CurrentUserID"].ToString()); var jsonData = new { flag = false, Message = "" }; if (actionType == "Create") { model.ID = Guid.NewGuid(); jsonData = new { flag = true, Message = "Role berhasil ditambahkan" }; results = db.ReportRoleNew_Insert(model); } else if (actionType == "Delete") { jsonData = new { flag = true, Message = "Role berhasil dihapus" }; results = db.ReportRoleNew_Delete(model); } //Update report ReportView reportModel = new ReportView(); reportModel = db.reportView.Where(x => x.ID == model.ReportID).FirstOrDefault(); reportModel.ModifiedBy = new Guid(Session["CurrentUserID"].ToString()); results = db.Report_Update(reportModel); if (results.Key == 0 || results.Key == 16 || results.Key == 6) { UrlHelper u = new UrlHelper(this.ControllerContext.RequestContext); //string urlNew = u.Action("Edit?id="+model.ReportID+"&success="+results.Value, "MasterReport"); string urlNew = u.Action("Edit", "MasterReport", new { id = model.ReportID, success = results.Value }); return(Json(jsonData)); } else { jsonData = new { flag = false, Message = "Swap Column Gagal" }; return(Json(jsonData)); } } else { foreach (var key in ModelState.Keys) { var error = ModelState[key].Errors.FirstOrDefault(); if (error != null) { errorMessage.Add(error.ErrorMessage); } } var jsonData = new { flag = false, Message = errorMessage.First() }; return(Json(jsonData)); } }