public ActionResult UsersEventsAccess_Bind(EventPermissionModel model)
{
actionResult = new ActionResult();
try
{
actionResult.dtResult = EventDL.UsersEventsAccess_Bind(model);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
}
return(actionResult);
}
public ActionResult EventsAccessPermission_ByRole(EventPermissionModel model)
{
actionResult = new ActionResult();
try
{
actionResult.dtResult = EventDL.EventsAccessPermission_ByRole(model);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(actionResult);
}
public ActionResult EventPermissionCheck_User(EventPermissionModel reportsBase)
{
try
{
actionResult.dtResult = EventDL.EventPermissionCheck_User(reportsBase);
if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0)
{
actionResult.IsSuccess = true;
}
else
{
actionResult.IsSuccess = false;
}
}
catch (Exception ex)
{
ErrorReporting.ActionLayerError(ex);
}
return(actionResult);
}
public bool AddAll_UsersAndRoles_EventsAccess(EventPermissionModel model)
{
try
{
MyParameter[] myParams =
{
new MyParameter("@EventID", model.EventID),
new MyParameter("@CreatedBy", model.CreatedBy)
};
Common.Set_Procedures("AddAll_UsersAndRoles_EventsAccess");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
return(Common.Execute_Procedure());
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable RemoveRolesEventsAccess(EventPermissionModel model)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@ID", model.ID)
};
Common.Set_Procedures("RemoveRolesEventsAccess");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
public DataTable EventsAccessUsers_Bind(EventPermissionModel model)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@UserID", model.UserID),
new MyParameter("@EventID", model.EventID)
};
Common.Set_Procedures("EventsAccessUsers_Bind");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
public DataTable EventPermissionCheck_User(EventPermissionModel reportsBase)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@EventID", reportsBase.EventID),
new MyParameter("@EventAccessBy", reportsBase.UserID)
, new MyParameter("@EventAccessRole", reportsBase.RoleID)
};
Common.Set_Procedures("EventPermissionCheck_User");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
public DataTable AddRolesEventsAccess(EventPermissionModel model)
{
dtContainer = new DataTable();
dsContainer = new DataSet();
try
{
MyParameter[] myParams =
{
new MyParameter("@EventID", model.EventID),
new MyParameter("@EventAccessRole", model.RoleID),
new MyParameter("@CreatedBy", model.CreatedBy)
};
Common.Set_Procedures("AddRolesEventsAccess");
Common.Set_ParameterLength(myParams.Length);
Common.Set_Parameters(myParams);
dtContainer = Common.Execute_Procedures_LoadData();
}
catch (Exception ex)
{
throw ex;
}
return(dtContainer);
}
