public SqlParameter[] populateModel(PrivilegeException model) { var param = new SqlParameter[] { new SqlParameter("@PrivilegeExceptionID", SqlDbType.UniqueIdentifier) { Value = model.PrivilegeExceptionID }, new SqlParameter("@StatusChangeID", SqlDbType.UniqueIdentifier) { Value = model.StatusChangeID }, new SqlParameter("@SecurityRoleID", SqlDbType.UniqueIdentifier) { Value = model.SecurityRoleID }, new SqlParameter("@Inclusive", SqlDbType.Bit) { Value = model.Inclusive }, new SqlParameter("@RetVal", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@Message", SqlDbType.NVarChar, 100) { Direction = ParameterDirection.Output } }; return(param); }
public KeyValuePair <int, String> PrivilegeException_Update(PrivilegeException model) { var param = populateModel(model); int rc = ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreCommand("exec [CRM].[PrivilegeException_Update] @PrivilegeExceptionID, @StatusChangeID, @SecurityRoleID,@Inclusive , @RetVal OUTPUT ,@Message OUTPUT", param); int retVal = (int)param[4].Value; string valueRes = param[5].Value.ToString(); return(new KeyValuePair <int, string>(retVal, valueRes)); }
public KeyValuePair <int, String> PrivilegeException_Delete(PrivilegeException model) { var param = new SqlParameter[] { new SqlParameter("@PrivilegeExceptionID", SqlDbType.UniqueIdentifier) { Value = model.PrivilegeExceptionID }, new SqlParameter("@RetVal", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@Message", SqlDbType.NVarChar, 100) { Direction = ParameterDirection.Output } }; int rc = ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreCommand("exec [CRM].[PrivilegeException_Delete] @PrivilegeExceptionID, @RetVal OUTPUT ,@Message OUTPUT", param); int retVal = (int)param[1].Value; string valueRes = param[2].Value.ToString(); return(new KeyValuePair <int, string>(retVal, valueRes)); }
public ActionResult executePE(PrivilegeException model, string actionString) { KeyValuePair <int, string> results = new KeyValuePair <int, string>(1, ""); string message = Resources.NotifResource.PrivilegeExceptionSuccess; model.Inclusive = true; if (actionString == "Create") { if (db.privilegeException. Where(x => x.EntityName == model.EntityName && x.StatusName == model.StatusName && x.Key == model.Key && x.NewKey == model.NewKey && x.SecurityRoleID == model.SecurityRoleID).Count() > 0) { var jsonData = new { flag = false, Message = Resources.NotifResource.PrivilegeExceptionSame }; return(Json(jsonData)); } } if (actionString == "Delete") { message = Resources.NotifResource.PrivilegeExceptionDelSuccess; } switch (actionString) { case "Delete": results = db.PrivilegeException_Delete(model); break; case "Edit": model.StatusChangeID = db.privilegeException .Where(x => x.EntityName == model.EntityName && x.StatusName == model.StatusName && x.Key == model.Key && x.NewKey == model.NewKey).FirstOrDefault().StatusChangeID; results = db.PrivilegeException_Update(model); break; case "Create": model.PrivilegeExceptionID = Guid.NewGuid(); var stChangeId = db.privilegeException .Where(x => x.EntityName == model.EntityName && x.StatusName == model.StatusName && x.Key == model.Key && x.NewKey == model.NewKey); model.StatusChangeID = stChangeId.FirstOrDefault().StatusChangeID; results = db.PrivilegeException_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)); } }