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));
}
}
