//Remove Role From RoleMst Table
public int RemoveRole(Models.RoleModel rolemodel)
{
List <SqlParameter> sqlparam = new List <SqlParameter>();
sqlparam.Add(new SqlParameter("@RoleId", rolemodel.RoleId));
sqlparam.Add(new SqlParameter("@CreatedBy", rolemodel.UpdatedBy));
sqlparam.Add(new SqlParameter("@Operation", 2));
SqlParameter IsSuccessful = new SqlParameter("@IsSuccessful", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
sqlparam.Add(IsSuccessful);
// 2 is to Remove Role
int i = DAL.SQLHelp.ExecuteNonQuery("Usp_UpdateRole", sqlparam);
int value = Convert.ToInt32(IsSuccessful.Value.ToString());
return(value);
}
//Update Role From Temp Table
public int UpdateTempRole(Models.RoleModel rolemodel)
{
List <SqlParameter> sqlparam = new List <SqlParameter>();
sqlparam.Add(new SqlParameter("@TempRoleId", rolemodel.TempRoleId));
sqlparam.Add(new SqlParameter("@UserId", rolemodel.CreatedBy));
sqlparam.Add(new SqlParameter("@Operation", rolemodel.Operation));
SqlParameter IsSuccessful = new SqlParameter("@IsSuccessful", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
sqlparam.Add(IsSuccessful);
// 1 is to Approve Role
// 2 is to Reject Role
int i = DAL.SQLHelp.ExecuteNonQuery("Usp_ApproveOrRejectRoles", sqlparam);
int value = Convert.ToInt32(IsSuccessful.Value.ToString());
return(value);
}
public int AddRole(Models.RoleModel rolemodel)
{
int value = 0;
List <SqlParameter> sqlparam = new List <SqlParameter>();
sqlparam.Add(new SqlParameter("@RoleName", rolemodel.RoleName));
sqlparam.Add(new SqlParameter("@Level", rolemodel.RoleLevel));
sqlparam.Add(new SqlParameter("@CreatedBy", rolemodel.CreatedBy));
sqlparam.Add(new SqlParameter("@Operation", 1));
SqlParameter IsSuccessful = new SqlParameter("@IsSuccessful", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
sqlparam.Add(IsSuccessful);
// 1 is to Insert Role
int i = DAL.SQLHelp.ExecuteNonQuery("Usp_UpdateRole", sqlparam);
value = Convert.ToInt32(IsSuccessful.Value.ToString());
return(value);
}
